Sirs, I request formula if Col-A & B Having Duplicate (NOT ONE COLUMN), that cells to be highlighted. (AS PER BELOW SAMPLE - ROW 1 & 5 OF COL-A & B TO BE...

I have a rather lengthy list of products sold by the company I work for; one column with the product name, one column with the number of articles sold. There...

I am setting up a spreadsheet that has dates. I have made it so I can change the month and the year. How do I get a formula of another cell to figure the...

I am trying to have stale dated cells copied into blank cells but cannot seem to find a formula that might do that. Any character in the new cell would be...

Dear Friends I want to lookup value from defferent range of tables as per value in a cell Vlookup("Text", RangeName, 3, 0) Range name will be provided in...

I am trying to have stale dated cells copied into blank cells but cannot seem to find a formula that might do that. Any character in the new cell would be...

I have the following data: A1 = 5 A2 = 10 A3 = 4 A4 = 4 I would like to use the icon sets (3 arrows) conditional formatting to show the changes of the value...

Hi all, Can you help? I have the following data on one worksheet called lamps: A B C D 1 ME4a 1 10 140w Cosmo 2 ME4b 1 8 140w Cosmo 3 S4 1 7 60w Cosmo

Here is what I am attempting: On worksheet 2, I want to reference worksheet one looking at 2 variables. What I want is to reference column D if columns I...

I'm trying to find if there is a formula that will look for a specific value in one column and return another value from the corresponding position in...

I need help in returning a pre designated number dependent upon the passing of dates. For instance, I need to calculate when 13 months have passed since...

I have a pivot table in which I use a date field as my columns. I have used the Group function to group the dates by financial year: our financial year runs...

i want to write standard operation procedure for using excel.

Is there any way to update a workbook (which is getting data from another workbook) without shutting it down, opening it again and clicking 'Yes' to the update...

I know there is a limit as to how many characters you can input in an Excel cell (alpha). Lately, I have been running into a quite anoying situation when,...

Needing to set a macro that can create averages of the number directly above and the number directly below. For example the spreadsheet would looke like...

I am attempting to run regression and get the error message: "Regression- Estimated output table will extend beyond bounds of the worksheet. Please choose...

I have 7 workbooks with 15 columns of data in each. All 15 columns have the same labels. I need to import all the data from each workbook into a single...

Hi, I have a database of clients with revenue range from less than $ 25,000 to 300,000 +. I need to assign each client a segment based on their revenue....