Using Excel 2002. I need to take a row of 60 cells of data and convert it into a 4x15 array. Ideally, I would create the array on a separate worksheet.

I need a roster sheet for my 3 children to work in the house as day by day house cleaning chores like eg; taking out the trash,vacuming the floor and so in...

I have a spreadsheet with multiple records per person and I need to move the data from the secondary listings to the first record so that I have only...

OK I have data in a rate card sheet that I want to display in another worksheet in the same book. This information will be selected from a drop down list. For...

I can export a client list from our 2003 and 2004 tax systems. They are in xls format. Is there a way to run a compare on the name field in Excel and generate...

Just a question - I'm not sure exactly how to google what I want to know. I am interested in using conditional formatting, formula based, where using a...

I am using excel 2002. I have two groups of data in one spreadsheet that I am trying to comare. Here is my example: Column A = value of a statement cycle,...

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...

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,...

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

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!

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...

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 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...

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...

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...

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, 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...

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...

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...