What is the best way to get the average cost on a FIFO basis when I only have 1 product. EG. A 5 @ 1.00 A 5 @ 1.10 A -3 @ 1.30 A 2 @ 1.30

i want to convert a number for example 1245 to its text format (one thousand two hundred forty five ) please tell how to do this in excel (office xp)

Hi All I wish to apply conditional formatting to cell B3 If the cells in range C3:F3 *all* contain "Yes" then the condition is true. If any of the cells is...

Hi, I am trying to get a formula to sum a range of data up to (and including) where the report date matches the column date. I have got a statement which adds...

I need help reverse engineering the following: By using the formula below, I'm able to take the number 1031023 and convert it to...

I need to track if a specific goal is not met. I would like to have an ALERT show in an empty cell if the goal (B2) is not achieved in any 2 of the prior 6...

Hi I was given this code to copy from one sheet to another This will copy the range given to sheet 1 A1 How can I modify this macro to make the destination...

Please, how can I freeze both horizontal & vertical in a worksheet. I can freeze either by WINDOW, FREEZE, but this only seems to do the Horizontal. Peter.

I have a whole row which has comments on them. How do i transfer them to a whole row?

I am tryingto convert a Rota, which has columns like , name, L=late shift, M=Middle shift , O=off, V=Vacation,etc(Please see attached file)

I have this formula: =sum(G25:G29) for adding up the 8:00 hours per day and instead of adding up to 40, it adds up to 16:00. What am I doing wrong? Louis

I have an XL2000 spreadsheet and want to connect a worksheet to a table in an Access 2000 database. I am trying to connect via MSQuery (DATA GET EXTERNAL...

I have 3 columns of data. Col 1 is either the number 1 (to indicate that the person lsited on that row has signed up for volunteer work) or the number 2...

I have 50 employees who all have their own worksheet. These worksheets are linked to a monthly worksheet with changes every month. Instead of manually changes...

Hi, A couple of things i need help with :- I need to calculate the volume of a room. I have four cells, Height, Width, Depth and Total I need to put a value...

Any thoughts on this? I have a Worksheet on which I am using 15 columns and, anything up to 250 rows. When printing, I only want to print the rows with data...

Hello, I posted this this morning and got an answer but I'm new to excel and I think the person who replied may have taken for granted my actuall knowlage of...

Ok Formula =sum(c:h) should equal out to be 14 instead equals out to be 153.96...any ideas?

I want to use auto filter or some other device to hide those rows whose first column has a zero in it. I would like to come up with a macro that automatically...