This may be a double post; apologies. This problem seems to happen only when my RANGE is on a different worksheet than my CRITERIA. When I run a COUNTIF, if...

I have a macro that I want to run on 100 of my 103 worksheets, is there a way this can be done. My code is: Sub...

I have Excel 2002 (I know, way out of date, but I have to use what the company provides) and have suddenly started having problems with a 'countif'...

Hi, I am looking for a formula that will examine cells E4:N4 and return the value of the one cell that is not blank in that range to cell P4. Any...

Please help! I have a number of imported worksheets with some fields formatted in mixed case and some in UPPER case. I want all data to look consistent. ...

I want to use a macro to set an active cell to return a value from the 2nd column of an array called RollLastRecost. If specific row is empty I want no...

I am looking to be able to put values in the order of 1 to 5 in a range of cells based on the order of values in another range - as an example the values in...

please help me to find how i can convert gram to microliter

I have a worksheet where every other row has a 'pattern' in it to help make it easier to read across the spreadsheet. The problem I'm running into is as I...

Hi, I have the following sample data in column A. germany (testing) Germany (cold) Germany Austria (Testing) Austria (cold) Austria (working)

Hi, I am working through a long worksheet with data. It is made for me by someone else. It has about 2300 rows. In Column C are measuring results, Bottom...

when I copy an excel file that contains sum if equations many cells in this file are corrupted when they are copied to another computer. can you please...

I want a drop down box that shows the current month calender that I can choose a particular date to be inserted into my excel sheet. Any ideas would be great.

hello, I wonder if anyone can help with the following, I have a colleague who would like to sum and multiply at the same time in a large spreadsheet. He...

How can I make it so that everytime I type say the phrase "Turned Down" it appears in red throughout a specific column? And "Booked" would appear in green,...

I need to take a total from one workbook and link it to another book on the same network. The 2nd book will be edited by other users and i need to be able...

This may be a double post; apologies. This problem seems to happen only when my RANGE is on a different worksheet than my CRITERIA. When I run a COUNTIF, if...

Hi I often want to generate simple patterns of numbers, but have yet to find an easy way of doing this in excel. It's really easy in minitab (for example)...

I have a workbook and I want info from sheet 1 to be transferred to sheet 2 on todays date. Is this possible?

Is there anyway I can suppress creation of Aggregate columns when I open/import XML into Excel? I'm using Excel 2002 and 2003. Many thanks in advance.