When creating a worksheet with main categories on the top line (i.e. Date, amount, notes, etc.) how do I adjust preferences so that when I scroll down the page...

IThe short version of this question is above the line......you can help a lot if you respond to only THAT. I am using Excel 2003 on an XP machine. If two -...

I have filter media that I need to order every week and some filter medias I have too much of. I need a formula that can tell me the exact date I need...

2Please help with the syntax for the following: If the contents in A1 = the contents in A2, put the contents of B2 in D1. Thanks, ck

I would like to use a range of numbers in an IF statement. As an example IF("C8 =3,4,or5",25,0) which is meant to read if cell C8 is equal to the number 3,...

When attempting copy/paste, a message pops up that reads "Microsoft cannot empty clipboard." However, my clipboard is empty. This is preventing me...

In the previous version I could select "show page" from the drop down menu to create new tabs per page field. I can't find that funcionality in this version,...

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

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

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

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

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

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

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

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

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

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