I wan needing to hide certain rows in a spreadsheet, but not the same ones each time. I was thinking I may be able to do something like if the number is...

i am creating a entry form for an event. there are checkboxes throughout that have a value connected to each. when a checkbox is chosen, i need the...

I have a spreadsheet with names and dates of training next to them. I want to pick up the names which are in the A column if either the B or C column have...

I'm looking lo count the number of consecutive occurances of a 1 without a zero in a table but only if it is a new run. i.e. Data Result 0 0 1 ...

I am working on an excel sheet that someone else has created. They have turned on the list manager and it is driving me crazy!! How do I turn this silly...

I encountered a problem that's new to me while using autosum on a row of numbers and blank cells =SUM(D9:R9) it seems to produce the correct sum, which is...

Hi all, I am making a spredsheet with my user logon names. What I want to do is genarate a logon name field automaticly. For example: User ID First Name...

I need to tell column B if there there is something in column C greater than zero then use column A figure. Otherwise use A/2. A B ...

I have the following columns. Svgs Fee Total 1 $25.00 $15.00 $15.00 2 $25.00 $0.00 $25.00 I need to be able to tell Total to either...

I have been trying to find a simple answer to my NPV problem without creating all the monthly cash flows if I have only the following information. I want to...

I am using Excel 2007 and have tried using conditional formatting to format a cell's number format based on a condition in an adjacent cell but its not working...

I have a model where I'm trying to calculate the accurate price for a product every month. Unfortunately, I have a product where the price increases by 3%...

I have to calculate the future value of several cost items that occur from 2009 to 2013. Assume all costs are incurred Jan 1 of each respective year. The...

I need to sum multiple columns based on the value in one column and the excel formula I used below always evaluates to 0 and I can't understand...

I'm trying to create a formula to sum a range of cells, like A1:A10, but only if all the values are numbers. On occassion I may place the text "TBD" into a...

my link formula in summary workbook (destination workbook) is showing error when source workbooks are closed

Hi, I have a range of only names I wanted entered, anything that is not one of these names I want to be highlighted somehow, maybe with IF Formula...

Hi, while using Excel i came across with the problem of comparisions. In Sheet 1 i have three Columns (A, B & C ) and on Sheet 2 i have two columns A& B. I...

Dear Sir, my excel file is corrupted i think due to virus. when i open my excel file that not show in english language but shown in other language like @,$...