Hi I have an excel workbook with 2 sheets, the first sheet has all the
information in it and the second is where I want the results displayed.
- Dec 18 Mon 2006 20:34
EXCEL LOOKUP
- Dec 18 Mon 2006 20:34
custom number formats
Hi all
- Dec 18 Mon 2006 20:34
How do I cycle through all of the worksheets
I need to check all of the worksheets to collect and sum contents. Is there a
with method or something along those lines?
- Dec 18 Mon 2006 20:34
How can I check for duplicate $'s?
I have made an Excel (2003 version) spread sheet (370 entries) of money
spent. I want to check the column containing the dollar amounts to see if I
- Dec 18 Mon 2006 20:34
Complicated formula help required
- Dec 18 Mon 2006 20:34
why is there a quot;^quot; in the cell?
Copied a worksheet, now both original and copy have quot;^quot; in the cells, causing
formatting to be off. Words won't center horizontally or vertically and can't
- Dec 18 Mon 2006 20:34
NETWORKDAYS
NETWORKDAYS is an extreemly usefull function especially in building timesheets.
This function is based on the United States of America system, but not all
- Dec 18 Mon 2006 20:34
IF amp; VLOOKUP
This is the formula that I am using which works very well. =IF(E2=0,quot;
quot;,(VLOOKUP(E2,Worcester,2,FALSE))). I have a range named WORCESTER for
- Dec 18 Mon 2006 20:34
If/AND/Or Formula Help
I tried but cannot get a formula to give me the result.
- Dec 18 Mon 2006 20:34
Pivot table problems
I'm trying to create a pivot table and I'm having problems with 1
field. The error message reads: