how to calculate the difference of values (numbers) in a column?

H

Huseyin

A B C D
A1 10
A2 9 1
A3 8 2 1
A4 7 3 2
A5 6 4 3 1

I need to calculate the differences of each value in a column and have the
answers on second third column. For example subtract A2 from A1, A3 from A1,
A4 from A1, A5 from A1; and subtract A3 from A2, A4 from A2, A5 from A2;
subtract A4 from A3, A5 from A4; and finally subtract A5 from A4.

Any help is appreciated.
 
T

teylyn

Hi, try this

select B2:B5 and enter this formula in B2 =$A$1-(A2:A5), confirm wit
Ctrl-Shift-Enter.
similarly for
C3:C5 =$A$2-(A3:A5)
D4:D5 =A3-(A4:A5)

hth

teylyn
'The Code Cage - Microsoft Office Help - Microsoft Office Discussion
(http://www.thecodecage.com)
 

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

Calculate end date and time 1
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Average Question 2
Using two Vlookup in one Cell 1
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) 6
VBA Linest function for polynomial regression on horizontal range 0
Sum of Variable Cells in a fixed Row 3
adding numbers in a column with dates 5

Top