I have a column of data (Excel 2000) which I would like to sort alphabetically. Some entries have a double asterisk preceeding the first word (**word). I...

I'm not sure if this is a VLOOKUP or IF/COUNTIF. How can I count the number of occurrences of a value in column D that match column E and will put the values...

I have four checkbox per a single row...I want to be able to click one one and have the other three remain unchecked...that way I know only one can be selected...

I am looking for help with nested functions. I found one on the site that works well for part of what I want to do. It...

Hope someone can help here! Code Year Jan Feb Mar Apr......

How to extend the Excel sheet from sheet 1 ( i.e. IV 256) to other sheet(e.g. sheet 2)? E.g. I want to input data 512 point into the column, but Excel only got...

Hi I get the following error message "Can't Find Project or Library" when I run the following code: Application.ScreenUpdating =...

I have been trying without any success to refer to a range name by using text within a cell. To set the scene...... There are three names ranges which are...

Here is my formula: IF(SUMPRODUCT(($A$3:$A$5=$A$8)*($B$2:$E$2=$B$7)*($B$3:$E$5))="","", SUMPRODUCT(($A$3:$A$5=$A$8)*($B$2:$E$2=$B$7)*($B$3:$E$5))) I get a 0...

Hi, A while back I posted regarding a challenge that I had, and I got great information. Here is another: I am trying to calculate the occurrence of an...

How can I create a function to do this? A1 1 One A2 2 Two A3 3 Three A4 4 Four A5 5 Five A6 6 Six .......

Hi I'm part of an Excel user group that meets every other month in my company. There are about 65 members with a wide range of experience. Some are...

Greetings all - I have a workbook that consists of a summary sheet, and several worksheets which contain monthly data. In the summary worksheet, I have the...

I have 12 separate spreadsheets that sum dollar amounts in a single cell. I created a thirteenth spreadsheet which summarizes all the info. I want to input a...

Hi, I have a huge file with 10,000 records with like +25 rows and some of the jobs are repeated several times. Using the Job as the reference in vlookup i am...

I know there is a way to select arrays on different sheets one array at a time. Is there is a way to select arrays (located in the exact same cell range) on...

How can I compare value in column A to column D and also compare column B to column E? If A & D agree and B & E agree, return value of column C. Thank you!

Let's say I've got several rows of data for one column updated each day downward. DAY 1 DAY 2 DAY 3 DAY 4 DAY 5 EMPTY EMPTY

I am trying to copy/paste a formula using roundup to other cells but it is not working. The formula, =ROUNDUP(M2*N2/W2, 0 ) works when I type it in. However,...

Hi, I was wondering whether is there an option (Excel 2002) to make between function. I mean that cell A1 is my variable. Now, by using IF I would like to say...