|
|
|
|
1 |
128 |
|
|
Please help - Find & copy Macro by
Damil4real
Please help -
Macro to find "E4" value in column A. If found, copy found value from
the A column and paste in cell A5.
All info are in sheet named is...
|
May 7th, 2009 02:30 PM
by JCS
|
1 |
121 |
|
|
Help with Lookups by
silentpro
My apologies if this is a duplicate post.....
Maybe I should've done this to begin with, but here's my example
From worksheet MAIN
ALLEN,...
|
|
1 |
125 |
|
|
Lookup for a word in a table by
T.Mad
Hi there,
I wonder if anyone can give me a good piece of advice in how to find a
specific value in a table. For example I have the next table:
A ...
|
|
7 |
120 |
|
|
|
|
10 |
161 |
|
|
|
|
3 |
69 |
|
|
IF Statement using several columns by
klcmomy
I want to write an if statement that will allow me to pull information from
several columns and give me one result at the bottom of my sheet. Example:
IF...
|
|
3 |
103 |
|
|
Text from a comment box into a cell by
MFS
Hi, is there any solution to extract the text written in a comment box to a
specific cell
I tried the following but this message “#name?” appeared
...
|
|
2 |
65 |
|
|
GETPIVOTDATA on Excel 2000 by
Louja
Hi,
I have seen that you can use GETPIVOTDATA with more than one field on
Excel 2003 and 2007. But is there any way of doing this with Excel
2000.
I am...
|
|
1 |
77 |
|
|
Conditional Testing of an array by
Lord Robocop
Ok, my spreadsheet skills may be showing a little out of date here, but I am
hoping an Excel-God can show me the light.
I have an array consisting of column...
|
|
1 |
78 |
|
|
|
|
7 |
88 |
|
|
if formula by
MSKC LLC
i need a formula that will do the following function: If A1 equals either
D/S, Sunday, or Daily and write 16.84 for D/S, 8.48 for Sunday, 8.06 for Daily
|
|
2 |
67 |
|
|
calendar control for week day by
retired bill
I figured out how to add a calendar control to my excel spreadsheet.
For example, when I click in cell B7, the calendar appears, I click on a
November 11,...
|
May 7th, 2009 01:36 AM
by John
|
2 |
78 |
|
|
Is there a way to use Formula to resolve by
Sky
Is there a way or formula in the excel that could help to add the nearest
month to get the figure for Column F.
The month added up can be greater than or...
|
|
5 |
80 |
|
|
List to Table - formula by
Joe
Hello
I am trying to put a list of data into a table. I would like to use a
formula to do this as the list is updated on a regular basis.
If the ‘data’...
|
|
3 |
164 |
|
|
Conditional Format by
Kashyap
Hi, I was trying to apply conditional format for A2. That is if the value of
A2 repeats in either Column D or Column H or Column L, A2 should be
highlighted.
|
|
6 |
90 |
|
|
|
|
6 |
112 |
|
|
|
|
1 |
64 |
|
|
VLookup - find new items by
Shazaxacpcc
I have a regular spreadsheet with large number of data lines. I would like
to identify new items that appear on the spreadsheet each time it is run but
I...
|
|
0 |
74 |
|
|
|
|
0 |
76 |