How do I construct a formula to return multiple entries meeting a criteria? I want the formula to return a vertical list of names where grade=2 or...

I am trying to make excel count the number of cells that have a certain criteria. Lets say that I want it to count how many of the cells in a list say...

Hi, How can I disable the display of "####" in a cell whenever a formula has errors? I am using formula's to populate the sheet2 depending on the values...

my data: A B C -2500 -2000 250 ...

Hi can anyone help?? i have a speadsheet that has 5 headings, name, save rate, wrap time, aht, and notes! i am trying to copy a row to another sheet if in...

I have 2 sets of data that should be identical but I know they are not - how can I filter so that it gives me only the unique values? I have found ways of...

I have a spreadsheet that has 3 sizes in a text string in cells. For example, A2 may have 1 Gal, A3 may have 1 Qt and A4 may have 5 Gal. I want to create an...

I have a worksheet containing an annual budget. Column A is coded to help identify the source of the revenue/credit and has the debit and credit figures...

hi, i would need to lock a command button so when i protect a worksheet it is locked. any good suggestions? thanks

Suppose I have data that looks like: 1/1/2008 1/3/2008 2/7/2008 Ordered Ordered Ordered Aardvarks 8 7 3 Baboons 3 10 7 Cats 5 3 2 Ducks 5 1 7 Elephants 7 2 8

I would like to have different worksheet tabs that are only viewable based on answers given on a main page. Say I have 4 conditional pages, based on 1 of 4...

Hey, I have a speadsheet with a bunch of numbers in Column B From B3 to B367 and i want to find the number that is closest to zero. (Numbers are rounded off...

I have two columns P and R that contain both date information and numbers. I want to count everytime a date is entered in the cell. Example...

Col A Col B Col C Row1 $1,000.00 $2,500.00 10% Row2 $2,501.00 $5,000.00 12% Row3 $5,001.00 ...

Excel 2007. Challenge: I have a calculated value in :mm-format "37:00" (summing up the number of worked hours for a month) and a single value in general...

Hello, I am exporting a data file from another program into a text file and then into an Exel file. The numbers are correct in the original program, but once...

I need to add up 23 independent random numbers. My first try was: =RAND()*23 This proved to be insufficient since it really only added the same random...

Good day, Would anyone know of a way to include the if(isblank()) in reference to a column with every fourth cell populated with a value that needs to be...

Hi All, I have a single column, dynamic named range called "Data" that contains numeric values. Is it possible without the use of a helper column (or other...