Not sure how to accomplish this so i will attempt to explain. Any assistance would be greatly appreciated! Sheet1 - consists of four columns of data for...

I would like to use Sum to toal a range but exclude any data in hidden rows. That way I could filter another column and run totals for the rows that meet the...

hi to evereyone i want to make a function that i have in cell a1 a number 5 and each time the week changes, to add to that number the value 1 eg. if at that...

i have a spread with 7200 zip codes, not all unique. I am just trying to find out how many times each zip code appears so i can see where most of our business...

Thanks everyone Reference Thread preceding this text Background I need to show a minus figure in the total if the result is better than target ie target (c40)...

does anyone have a solution for unique ranking when 2 cells have the same value. e.g., to have them rank #8, #8, and then the next cell as rank #10 creates...

Cell D24 will either be blank or will have NON-OP in it. Cell E24 will either be blank or will have a time (HH:MM) in it. If Cell E24 has a time in it F24 will...

I can't get my head around what must be a routine issue even though using http://www.mvps.org/dmcritchie/excel/vlookup.htm I will have 2 tables on 2...

Hi, I have about 50 Fields. I am trying to create 25 out of 50 fields into one fields so that I like to see 26 fields instead of 50 fields. Your help would...

Is there any way to join IF statements? I find the fact that you can only use 7 IF statements very useless! I'm trying to create a spreadsheet using an...

I need to find a formula which when I enter a value between 1 and 4 will copy the four names (from the data below) into the active cell and the three other...

Not sure how to ask this and I am very much a beginner in EXCEL. I am trying to find a way to track periodic reviews that are required every time an individual...

When you are using Data Validation List, Is there any way to assign a macro or formula that will choose preselected entries... for example, I have 10 different...

I have a column of cells formatted as dates "23-Mar-03". Sometime a date is missing becuase that action has not occur as of yet. The cell in this case is...

Hi, I have a large excel data worksheet which has the basic look: Item: PointA PointB PointC PointD PointE #01 01-Feb 04-Feb 05-Feb 13-Feb...

Hi, I have a large excel data worksheet which has the basic look: Item: PointA PointB PointC PointD PointE #01 01-Feb 04-Feb 05-Feb 13-Feb...

I'm experiencing something REALLY wierd. I'm a VERY experienced EXCEL user, and I've just installed the Excel 2003, and I am having the Da**ed-est of times to...

The Office 2003 Student/Teacher upgrade does not appear to have an xirr function. Is this seperate function available as a download or do I have to purchase...

Excel's help wrote: TBILLEQ is calculated as TBILLEQ = (365 x rate)/(360-(rate x DSM)), where DSM is the number of days between settlement and maturity...

I have an array formula as follows (excell...