i have a spreadsheet and i want to move from coulmn g to columns m t x aa ac
if a product is in column g e,g if cell g8 equals paper then go to coulmn t8
or if cell g8 equals book then go to cell x8.
would i need to make a macro or is there a function that excel has that i

I cannot find the auto-recovered files! Why are they so difficult to find?
The file path given where they should be stored does not exist...
The "Search" function doesn't find them either.
Do they have a seperate extension or .xls?

Please if someone can help me with this…
I have a worksheet 1500 lines with 17 random numbers, 1 to 70.
How I can find 9 or 10 numbers from 17 that are keep repeating over an
over

I am using several drop down lists in a worksheet.
Some of the drop downs show the items starting at the top of the list,
others start half way through a list.
Can i make then all start with the first item on the list?

This worked for me for a 5 column Time Sheet (Line 7)... providing that
the center time out/in is used for lunch or left blank if no lunch is
taken....is there a better array out there?
=IF(H7=I7,((((HOUR(J7)*60)+(MINUTE(J7)))-((HOUR(G7)*60)+(MINUTE(G7)))))/60 ...

this is my first post here, could anyone help me out a bit, basicall
what i am trying to do is to use excel to calculate maximum mortgag
term available to someone, for example, i want to input the person
date of birth (23/07/75) and i want it to calculate the maximum ter

Is there a 'quick-key' for adding fill colour to a cell?
Anything similar to creating a quick-key for adding a symbol...

I have a list of NFL teams in column A (alphabetized) with their rating in
column B:
1    COL B        COL C
2

I have macros in a worksheet that others use.  Can i have the macros enabled
without it prompting the user when they open the worksheet?
Thanks :)

take a bunch of data from one cell, and put it into columns?
I have a couple hundred email addresses that, when I copy them from the
email, they only paste into one cell. I would like to put each address into
its own column ... but can't figure it out ... but it looks like this:

I have 2 columns of 30 numbers, side by side.  All numbers are 1 to 6.
I need to count every time the numbers in a row both equal 2, 3, 4, or
5.  (Matching pairs.)
I cannot think of how to do this without using 30 if functions for each

How can I find duplicate data set..Say My data is in Column A B And C from
Row 6 to row 200, Now I want to check whether the data depicted in Column A,
B and C are also stored else where say in Columns G, H and I..?
I have three fields In column A is Date, In Column B is IDs and ...

I can't seem to get the fill handle "+" sign to give the correct amounts when
I want to copy a formula down a column. It seems to skip every 2nd row with
the wrong amount or sometimes it will give a 0.00 sign.
Any suggestions.

Is ther a formula to convert hours and minutes to minutes
eg 2:25 (2hrs 25minutes) = 145 minutes

on 7/24/05 StuNVA asked:
"I have a spreadsheet that I need to insert a blank row under a number
everytime it changes. The column may have 500 rows and the first twenty
or so may all be the number 10 for example, the next five might be the