|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 10th, 2004, 06:03 PM
|
|||
|
|||
excel formula
I have a spread sheet in which column A has Account
numbers and also Salary. So A1=Smith and A2=5,000. and so on. In another sheet, I would like to have account in A, salary in B. Instead of writing the same formula many times, I would like to say = offset by 1. How do I do that? Thanks 
|
|
#2
September 10th, 2004, 06:35 PM
|
|||
|
|||
|
Hi
just copy the formula. See: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany wrote: I have a spread sheet in which column A has Account numbers and also Salary. So A1=Smith and A2=5,000. and so on. In another sheet, I would like to have account in A, salary in B. Instead of writing the same formula many times, I would like to say = offset by 1. How do I do that? Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Formula - IF Formula & Conditional Formatting | rhhince | Worksheet Functions | 1 | June 20th, 2004 06:34 PM |
| Excel changes my formula when I add values! | MJ13 | General Discussion | 7 | June 17th, 2004 04:38 PM |
| Excel formula for year calc. | Bobby | New Users | 3 | May 11th, 2004 04:07 PM |
| Copying a Formula from NotePad to Excel | carl | Worksheet Functions | 4 | March 21st, 2004 09:25 AM |
| Formula Layout Excel | Thor's Castle | Worksheet Functions | 2 | March 16th, 2004 04:53 PM |
Linear Mode
