=IF(O141000000000,"DUAL VP",IF(O14500000000,"VP", IF (O14100000000,"AVP", "OFFICER"))) I what above condition to be true only when Cell A1 is selected...

I can't remember the formula to find the top 20% of the dollars spent in a column. I have 692 rows with dollar amounts I need to report the % (rank) compared...

=IF(O141000000000,"DUAL VP",IF(O14500000000,"VP", IF (O14100000000,"AVP", "OFFICER"))) I what above condition to be true only when Cell A1 is selected...

I am trying to multiple 6h22m by 5.8 people. When I do the calculations by hand I get I get 36h8m. The formula gives me 12h55m. The cell formats are above the...

Hi, I'm new to excel. I want to delete (sort of) duplicate records. My spreadsheet has many columns. My spreadsheet has many records

need help for page set-up for excel to catalog small museum library, Category, ISBN#, Title, Author, Subject. I have very limited knowledge of excel but know...

I have a need for a simple balance sheet like the one in Excel 2007. The problem with that one it allows such a small number of entries. Does anyone know...

Hi, I use a file created in Excel 2003 and need to check if the Pivot table calls proper ranges. Is there any way to check what the source for the Pivot is?...

Hi, I have a graph that is being updated weekly, so every time the X-axis extends. I add comment texts and / or pointers/lines to the graph from time to...

I am trying to count the number of rows where specific text strings appear. If I found "jim" count it likewise, if I had "jack,jim" or "jim,john" count them...

Hi, I'm looking for an Excel site similar to and as good as "The Word MVP Site" http://word.mvps.org/index.html Anyone have some suggestions? Thanks, Doug

I deal with a number of huge spreadsheets and need to remove all rows with the values 2 through -4 in col AE; first I sort AE in descending order, then...

Dear sir, with best regards : I have a workbook with around 25+ sheets on it and I was wondering if its possible if I could put these sheets in a drop down...

I am trying to create a formula that is probably simple for others but not me. I am trying to find out how to create a formula that will help me finda drop ...

I am new to this - I would like to know how to change the font color conditional to a formula result. for example =if((A1than 0,"font red", "font blue") I...

I created a set of documents with Excel in which users can enter data into cells in an "InputSheet" (sheet 1) which will populate to several other "recipient...

I have a amortization schedule based on months. I would like one that I could use bi-weekly payment schedule 26 half month payments over the year.

I'm trying to copy a mail list of donors that was emailed to me in excel into works. When I copy and past into works all I get is the word "picture". ...

Ok, Kinda new a formuals for Execl 2003 / 2007 I have catalog numbers in column A B LNL FNM BLB TNT KBA BER these are cross reference...

I'm using Excel 2003, Win XP. I just want to enter a funtion/formula that counts how many times a record appears in a range between two specific dates...