Hello, I have seen this done with conditional formatting, where the top ten values in a column are highlighted, But for the life of me I can not come up with...

I am trying to cap a cell that I use for discounts. eg the cell could read 35%, but I only want a max of 30% on some products I am using a cell to input a...

I have a worksheet that one of my sales people set up to track the materials for a job they are doing. They have seperated the various stages by highlighting...

Hi, Sorry for posting this one again, but I had 2 questions in my last post and only one was answered. I thought my other question might be getting...

Does =GetPivotData work in a reliable way????? I have an Access table of data relating to the current working days of the week (Mon to whatever day of the...

I am trying to add a footer that shows when the last time the document was saved. Is there a way to do this?

I want my file to use vlookup and pull data from the current worksheet but I also want to copy the formula to subsequent columns which represent dates (week...

I can't figure out how to average non-contiguous numbers. Any suggestions?

In column A, I have a list of names (Abbott, Addas, Amling, Benner...) In column B, I have the sector they are in (Media, HealthCare, Media, Telecom...) In...

I have one column with a list of dates that show when orders are or were expected to ship and one column with a list of dates that show when those orders did...

I am trying to concatinate a row of 30 cells. Some of these are empty or blank. I want to combine these 30 cells where they are not blank. I have tried several...

I need to take this list and pick a color by means of priority. In this example, I put a priority of 1 for the color of orange in the cell next to the color,...

Excel gives an incorrect calendard week number. =num.week(A1) gives 4 if in A1 is 21/01/05. Actually 21/01/05 is in week 3! Why? and more important , may I...

I need a little help on a calculation. Col A contains dates, Col C contains amounts. I need to calculate an average by day given that there can be multiple...

I have inherited an Excel file that has many worksheets and one summary worksheet at the front. The summary takes information from certain cells in all of the...

I need vlookup to capture and sum all figures pertaining to the same G/L code even if there is more than one of the same line item on the data sheet. The data...

I'd like to find out the number of days between todays date and the latest date from a range of dates (D7:D37). Thanks for any help.

Hi, I have a several exam scores, eg 85%,75%,65% etc etc I would like to know the easiest way of banding the scores such as 90% is shown as A+, 8090 is...

Hi I have first and last names in 2 columns and I need to count the number of unique people. It's already a busy worksheet and would rather not have to filter...

Hi all. New to pivot tables so I do not know if this can be done. I have a table that give the total amt. of all sales order for a contract. I want to write...