excel formula

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Complex formula 0
sumif issues 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
need help with creating a formula which checks more than 40 cells 1
Section and Page numbering 0
Bugs in Office 2019 0
Lookup dates and values 5

Top