I exported data from a scheduling program to an excel spreadsheet and data is now formatted as as date instead of a number. What was 4631-01-10 is...

I have a list of 20 names in Column A of my spread sheet. Then I have 13 columns which represent 13 weeks (1/4 of a year). Each week there are 6 people...

Apologies for the re-post. Need to clarify this to avoid confusion. Is is possible to compare two ranges and return a list of booleans illustrating where...

Hello, I have a sheet that has data such as: Hr mL gas 0 0 0.05 3.5 0.1 3.5 0.15 3.5 0.19 3.5

Hello everyone The 2007 East Coast Excel / Access User Conference will be held at the Trump Marina Hotel Casino on April 18-20. If you have missed the past...

I've got a worksheet, and it references values in a second worksheet. The values are transposed (via cell formula from the second worksheet) onto the first...

Hi ! I have a table of several rows and columns. I want to extract the values of select rows fully. The rows I want to select based on 3 different...

I installed the latest Office 2003 updates around 25 July 2007. I now see that, e.g., XIRR is no longer available. If I fiddle around and use the Add-Ins...

Hi, Having a problem here. Essentially: In cell B9 =IF(either B6 OR B7=0,"",If(B6B7,"",B6-B7) Can someone sort this one out for me? Thanks -- Traa Dy Liooar

I am trying to import info on some cells to another worksheet. I type = in the destination sheet and click the cell I want from the original sheet but the...

I have an address worksheet it has two columns. Name in column A and Adress in column B In the rows 1- 10,000 is the data , Some of the rows have no data...

I hope this is the right board, so here goes... Hi all, I know this has been covered many times over, but I just can't seem to figure it out. I have an...

The Grouping Present in Excel dosen't allow the user to take full function of excel function. The suggestion is as follows the group will be defined by the...

Hello. What I am trying to do is return a value that is in column G *IF* column A and column B meet my criteria. Column G is a quantity value, and column A is...

I am working on an excel project in which I have a rent price say $5000. With this rent I am trying to find a formula in which I can find the maximum one...

I am getting unexpected results from a simple multiplication formula. Column A contains rates, Column B contains billing discounts and Col C calculates the...

i have to do a shortage analysis of various part numbers at work. i do this on a weekly basis , putting each weeks new data in a new worksheet. i need to be...

Hello from Steved I have 5401 to 5499 and need it to be 5601 to 5699 please If there a formula I can use to acheive the above. Thanks

I need to be able to count items in a column, but also have it add multiple items with in one cell. Any ideas?

Would you please advise of =If formula where I can round 5.020(c) so It displays something like that at the end 5.02(c) or any other letter that can show up...