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

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

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

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

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 to change a lot of formulas to "Indirect". Example, A1, =B1 - Need to change it to =Indirect("B1") I have been trying find and replace; Find =,...

when i open a form how can i make the form number change everytime i open the form. For example: Workbook 1 has form number 1001 when i open workbook 2 i want...

is there any way to populate multiple data from different workbooks at once using any function? EX: workbook 1 col1 col2 a 1 b 2 c 3 d 4 e 5 f 6

I have a worksheet where the first column is an index with customer number. I the other columns, from B onwards, I have the item numbers each customer has...

Hi All, I am using Office XP. I want to convert a text value to scientific notation form. If I enter =TEXT(0.000000006036,"0.000e-9"), it gives...

I have a worksheet with data that contains the following headers: Year Dollars Vendor Invoice # and Vendor Name I want to group each year information in to a...

I am trying to take a set of data and make it simpler to work with, but don't want to have to retype all the data. On sheet 1(data), I have names in column A,...

Hello everyone, I’m new to excel forums! I’m a Quality Analyst for a financial company and am using excels built in functions to create test scenarios for...

I have a spreadsheet where i have an customer number in the first column, and the item number each customer has ordered in the subsequent columns. In order to...

What the heck am I supposed to do here- 1 What is $B$3/G4, $B$3/G5, & $B$3/G6? 2 What is B5/E4? 3 What is $E$2/G5, $E$2/G3, AND $E$2/G7? 4 What is $C$4*E2,...

I have one excel spreadsheet that I am inputting data for tracking purposes. I need to also print out this information, in a different format, and forward to...

I need a formula to calculate attendance on a rolling calendar, updating date each time you open

....that formula you have at the bottom of your post should work fine. Is it not? -- Regards, Dave "Garbunkel" wrote: