This seems really basic, but I looked and looked and couldn't find an
answer....
A              B                C            
Date          Wage         OT Calc

hi members
i want to compare 5000 rows of data with 1000 rows of data.
you may say i have got a list of 1000 selected workers for
training out of 5000. how can i compare that 1000 rows with 5000 rows

How can I reset the size of a spreadsheet?
If if hit 'end' 'home' it goes to g1000.
The data I need is a1 to g700.
thanks

I have 65 sheets of data in excel consisting of three columns.  I want to
combine all 65 sheets into one long sheet.  I am aware that I can just
manually copy each sheet over, however it is a very tedious process and in
the future I may have way too many sheets.  I was wondering ...

I am currently trying to have the date auto fill for 6 days of the week on a
spreadsheet with 5 sheets on it. Our work week is Mon - Sat and I was
wondering if there is a formula that I can use that when I entered the date
for Monday July 31st it would auto fill in the correct ...

Hi, In the past you all have help me tremendiously.
I'm stuck again.  I have a very unuserfriendly report that looks like this
State  -    ype  - County/City - Invoice # - Ref # - Amount
UT -    Tax Billed - Salt Lake - 073714 - 238025 - $10.82

Dear Sir,
I have tested MS Excel 2007 (Beta) recently. I have van idea in my mind that
I would like to present it to you for product improvement.
At present if a user need to set the cell and font properties at a

I have the following IF statement working, but I'd like to add another
criteria to the second IF statement withing the MIN function.  For
example: IF($B16:$B25<> "BER" *and* "IW"
Can I do this without adding another IF statement?

If a formula returns a number or an error message how do I use the error
message in a logical test.

How do I format cells to get rid of a green triangle in the cell?

I am looking to find the most frequent occurrence of a text field in a row.
Example of the rows and columns:
     AZ Sais Supplemental Daily Attendance Daily Attendance Student
     Student Entry Special Education Student Entry Parent/Guardian

I am trying to modify an ininventory count sheet.  I would like the final
column to read current inventory value, whether it be Monday or Friday.
So, if there is a # in A1, it display's that.  However if there is a # in
D12, it display's that...

What site is best for learning to use "IF" functions in EXCEL???

Is there a way to delete all values in a colum without deleting formula
cells?

Hopefully the solution to this is quite straightforward.
I have an excel worksheet that has about 11000 cells.  Some cells have
data in them and some do not.
I need if possible, to calculate the total % of how many cells have