|
|
|
|
46 |
2,610 |
|
|
|
|
2 |
228 |
|
|
Lookup List to Index by
SSR
Hello,
I have a sheet with 2 columns as Below
A B
1 Apples 1
2 Oranges 3
3 Bannanas 2
Cells in Column A have data...
|
|
2 |
199 |
|
|
2003 update link when Source open by
Ausrobbo
I have a similar problem. We have a procedure which opens a (multiple sheet)
Excel workbook, then open a Word document with links to the workbook. We
rename...
|
|
0 |
456 |
|
|
VLOOKUP by
Lori
I can't remember how to use VLookup! I have to worksheets with columns of
common data I need to "merge" the two without duplicates. Can someone tell me
how to...
|
|
3 |
200 |
|
|
hex to decimal convert by
Nadia
Hi
Is it possible to have a formula convert a string of hex values to decimal
numbers?
say put hex values, in column A1- A8
and as soon as you put in values in...
|
|
4 |
207 |
|
|
Adding times together by
[email protected]
Hi
I need to add times together, i.e. 6:30, 5:30, 5:00 etc to get and answer of
17 hours
Can someone help me with the formula please.
Thanks
Yvonne
|
January 16th, 2005 10:19 PM
by Max
|
2 |
171 |
|
|
Conditional formatting by
Versateo
When using the conditional formatting dialog box, if you want more than one
condition to apply, you click the ADD button. However, you can only do this
twice,...
|
|
1 |
180 |
|
|
"Conditional" summing by
Aladin Akyurek
In B2 on the destination sheet enter & copy down:
=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)
Replace Sheet1 with the name of your source sheet.
Gilbert De Ceulaer...
|
|
0 |
135 |
|
|
Formula help by
DEEKABEE
I want to sum a cell that contains a formula with another cell that contains
a formula. How do I write a formula that will show the rersult?
|
|
3 |
144 |
|
|
Need formula for sheet & cell reference by
MPH
Help
Have a list of sheet names and want to create a formula to use sheet name
as a reference in a formula. Have tried "Indirect" but haven't succeeded
with...
|
January 16th, 2005 03:39 PM
by MPH
|
0 |
159 |
|
|
How To Suppres #N/A Values by
John
I've finally worked out the formula to work, which is below
=IF(ISNA(MATCH(A2,StaffNo,0)),"Crew",INDEX(StaffGrade,MATCH(A2,StaffNo,0)))"
However I am now...
|
|
2 |
155 |
|
|
Several Dates -Verify by
zeek
Greetings,
I have 6 cells A1 - A6 with dates.
Approximately 23000 Rows.
They should be the same, however, fat-fingers are involved making inputs.
What can...
|
January 16th, 2005 01:31 PM
by Ola
|
4 |
169 |
|
|
Autosum ignores cell values by
D
I have inherited a complex spreadsheet and have encountered the following
problem:
I am trying to add up a row and although the formula is correct, the...
|
January 16th, 2005 12:59 PM
by D
|
4 |
138 |
|
|
Edit Hyperlinks by
yazz22
I have an excel sheet with around 2000 hyperlinks pointing to files on our
company's internal server. The location of the files has to be changed (new
network...
|
|
1 |
119 |
|
|
|
|
1 |
358 |
|
|
Help adding text values by
Texas-DC_271
I have a row of cells that I need to add. The row of cells do not
contain a number but rather a text value. I have created a table
linking my text values to...
|
|
5 |
547 |
|
|
countif by
Becky
hi I need help. In column A I have male=1, female=2. In column E I have
less than 5 yrs=1, two-5yrs=2 and over 5 yrs=3. How do I find out how many
males...
|
January 15th, 2005 05:51 AM
by Biff
|
1 |
126 |
|
|
|
|
1 |
137 |
|
|
|
|
0 |
315 |