manojxls
New Member
- Joined
- Dec 21, 2017
- Messages
- 24
- Office Version
- 365
- 2007
- 2003 or older
- Platform
- Windows
HI
I have data like
A |B | D | E |F |REQUIRED ANSWER
account# |old.count | account# | new.count |
12345678 |2 |12345678 |5 |=VLOOKUP | =5-2=3
23456789 |4 |23456789 |4 | |=4-4=0
78945612 |2 |78945612 |3 | | =3-2=1
78945615 |1 |78945615 |3 | |=3-1=1
|45678912 |2 | |=NEW ACCT
Can anyone help me to vlookup or any formula so i compare AB column(OLD COUNT) with DE column(NEW COUNT) SO i can get difference in count., please suggest.thanks Manoj
I have data like
A | B | C | D | E | F | |
account | old.count | account | new.count | |||
12345678 | 2 | 12345678 | 5 | =5-2=3 | ||
account# |old.count | account# | new.count |
12345678 |2 |12345678 |5 |=VLOOKUP | =5-2=3
23456789 |4 |23456789 |4 | |=4-4=0
78945612 |2 |78945612 |3 | | =3-2=1
78945615 |1 |78945615 |3 | |=3-1=1
|45678912 |2 | |=NEW ACCT
Can anyone help me to vlookup or any formula so i compare AB column(OLD COUNT) with DE column(NEW COUNT) SO i can get difference in count., please suggest.thanks Manoj
Last edited: