How do I add up columns of cash figures to exclude the hidden amounts after the two decimal points for the pence eg on the spread sheet the amount may be...

I'ce got a sheet with begin week (colomn A) and end week (colomn B) going back a number of years. How do I add the cumalative months in colomn C?

I am looking for the correct formatting to reconcile two spreadsheets. I am looking to reconcile sales with commission payout. Any suggestions on how to...

I have a spreadsheet where I record individual scores on a daily and weekly basis. The spreadsheet consists of a column of names down the left side to which...

I want to get multiple entries to paste to another sheet. I have the following input box working to request one entry. Can anyone tell me how to use the same...

I have 100 different invoices with the same PO#, I want to add all of the invoices# with that po# to come up with one total to put on sheet two, in other...

Laser Skin Treatment – A Popular Way Of Curing Various Skin...

I have a set of numbers in rows, e.g., 56887 in 1 row, 95886 in another, etc. and I want to only show the last 4 digits of each cell in a separate column. I...

I have a spreadsheet with card numbers such as 12345678. that is used as a master inventory list. Every week I have to compare my weeks worth of card usage...

We recently bought new HP flatscreen monitors. Our computer workstations are Dell's. After installing the new monitor I am not able to view any colored...

hello, I check and uncheck items from the data dropdown box on many occations but today if I uncheck an item on the list, the item disappears from the list...

I just want a simple formula to automatically return a result for number of rows in a sheet (minus the heading). I don't want to have to review the last row...

I have days that repeat Mon Wed Mon Wed, etc... on a schedule. Next to those days are dates like 8/25/08 and 8/27/08. It would be NICE if I could highlight...

Win. XP, Excel 2003. I have a worksheet that has several thousand rows. I have filters set on two columns (one for attorneys, the other for practice...

I am trying to keep the first letter of each name in a column. I have approximately 1600 different first names in this column and I want to keep the first...

I know this is a basic function, but I can't remember how to do it. Col A Col B Job: 08-098 started 1/2008 In col A I only want the 08-098...

I've entered the formula =(L25-M3) in a target cell to count the length of stay of patients on a hospital unit. L 25 contains the formula to enter the...

I am buying a new business with partners. The cost is $386,450. We may have up to 10 partners, so each would contribute $38,645. I would like to build a...

I have to calculate a column of NPV. However only during the years an employee is in retirement. So I need to "build" the range reference starting at...

Hi again group! A small question. I am using an INDIRECT formula for turning a row a certain color, and it works well. How would one turn this formula into a...