Similar to the top 10 function, but need it to be expressed in %, say top 80% of the data population. Is there a simple way to do this? Many thanks.

Hi all, Could anyone help me how to check the column content by different condition? If the content of the cell is "Father" then replace it to "1" in the...

I am working with multiple worksheets. I've split up the worksheets by person (8 in total). I need to carry the calculations from each worksheet into one...

I am looking for a formula which I believe may be accomplished with SUMPRODUCT. My first worksheet (sheet1) is a capacity planning report by consultant....

Have multiple people reporting to me on a monthly basis & I include on their individual spreadsheet the data in a monthly column, what I need to be able to...

i am giving following data. Date Description Amount 1/2/09 Mobile bill £50 3/2/09 Lycatel (mobile) £10 3/3/09 ...

Thank you both (Fred Smith and JoeU2004) for your responses. My apologies for replying so late therefore have lost the thread! What I am trying to compile is...

I posted to this community and it says when I tried to open the thread that "Community Message Not Available". What does this mean? My question was to find...

Hi, I am looking for a quick formula that can take a number and round it up to the next higher integer that is a multiple of 5. Does anyone have a formula...

I'm using Excel 2003. The following formula works fine (returns the reference...

In my opinion this is quit advanced stuff I am trying to do here. That’s why I am posting here were all the excel experts meet. This is my challenge: in...

I have a spreadsheet with 24 months across the columns. The rows contain customer names. The cells contain data beginning with the date that amounts were...

Hello I have a spreadsheet that I need to count up to 500 items for. For example how many people between the ages of 19 and 29 fell. right now I am doing...

I have a large spreadsheet and I regularly paste out a small section and get many people to update fields. I then want excel to find this small section (via...

I tried the code below for flashing cells, and it didn't work. Will you please help me. CODE: In Workbook Private Sub Workbook_BeforeClose(Cancel As Boolean)...

Hello, I want to combine the 2 formulas using the IF function. Each scenario has its own formula but I want to integrate them into one formula. I'll...

Hi all, I have a excel file which contains with several numbers of rows and columns data. Since, I need to rename the data inside the cell A1, B1,...

I have a check box in K6......how can I set it up so that when the check box is checked, it changes the font color in L6 through T6 to red?

I need an if, then formula that will display sheet 2 B1 if sheet3 B3= sheet 2 B32, but I also need it to have a range of displays that if could equal. ...

Hey everyone, Excel 2007 I have a set of data listed like such: Column A COLUMN B (DATES) (NAME) 4/1/2009 Joe 4/1/2009 Joe