I have a 2007 spreadsheet that is looking to another worksheet Column F for the month of March, Column K for salesperson Dawn, and Column D for a product...

Hi all, I have a worksheet using a vlookup based on data validation. I want to do one of two things with my result. One, I would like the cell with the...

I have different values in a a column that I need to count. Column A: 2,25,45,52,25,30,2,45,80,60 and I want to count values as follows 30 = 4 30 and 60 =...

I am looking for a free-ware shock response spectrum Excel application? If you have a suggestion, could you please respond? Thanks, Bill Waring

This question was posted before but the solution proposed used different functions. I would like to insist. Is there a modification to the formula below,...

i need to add thirty days from column A to make column B

How do I use the countif on non-concecutive cells, i.e. I want to know the number of certain cells in worksheet that contain a specific value. For instance,...

Wouldn't ya know after I built all of this the stupid columns are coming out as: 120, 120, 30, 60, 90 I need for them to look this way: 30, 60, 90,...

Hi I need to convert 1,567.98 to german format 1.567,98 could you please help me how this is done in excel. Thanks

how do you calculate hours i.e. 3:45am-11:15am = ______hrs?

-- CCG

Let's say I have a table, a database, as it were, in Excel. Each record consists of a date, a person's name, and a couple of other things. The name field is...

Okay I have figured out how to do a VLOOKUP in a column of some 250 entries and it returns the highest value in the column, however I would also like to have...

HOW DO I USE OR SIMULATE COUNTIF FOR NON-CONSECUTIVE OR MULTIPLE RANGES? -- Marty

Hi, i have date from 01/01/10 in cell A. In Cell E mixed up dates with values in cell F. I want value from cell F copied to cell b when date in cell A and...

I have a course development spreadsheet with several courses. I would like to print a report that lists the courses that are new to development (in the sheet...

I can't get the minute and hour function to work. I even copied and pasted the example from Excel Help and it still doesn't work. Any idea what I'm missing?

I have a worksheet that has several columns of numbers, when I opened it today all of the numbers were changed to dates. I had to reformat them back to...

Hi, I have 2 column of data in sheet 1. Column A is date and B is value. I want the value in column B sheet 1 to copy column B sheet 2 according to...

I have a list in 'sheet1' that contains names. B3:B23 In 'sheet2' I have 2 columns that I want to use to pair the list in random order. I used this formula in...