Formula to compare pairs of cells in a row

kip

New member
Joined
Apr 4, 2014
Messages
1
Reaction score
0
Points
0
I have attached an example of a spreadsheet where I must compare stock share balances from two databases that should be equal but are sometimes different. I need a formula which will take two cells (in the first two rows) and return the mathematical difference. Then it must move to the next two lines and
do the same calculation and continue on to the end. I cannot make anything work.

Kip
 

Attachments

  • research.xlsx
    8.9 KB · Views: 14

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Wouldn't =B3-B4 do it?
 
Top