Hi everybody
attached sheet 1 is question and sheet answer is we needed
sheet1.
In B: there is different name aaa,bbb,ccc,ddd. when first meet
aaa in b2. then take i2 value(133) to calculate the balance
that is ba3=i2-i3 , ba4=i2-i4 , ba5=i2-i5
when first meet bbb in b6, then ba7=i6-i7 .....
if we have many name in column b , then how to setup formula
for ba to calculate like that ...
Thanks for your help
Tom
Hi,
Enter this formula and confirm it with Ctrl-Shift-Enter as it's an array formula:
Formula:
Please Login or Register to view this content.
HtH,
Joris
--------------------------------------------------------------------------------
If you found my answer helpful, please hit the Like or Thank button.
Please follow the forum Rules and Guidelines and use Code tags around your VBA code.
Remember: test VBA code always on a copy of your file because usually you can't use undo
in BB3
=IF(INDEX(I$2:I$21,MATCH(B3,B$2:B$21,0),1)-I3=0,"",INDEX(I$2:I$21,MATCH(B3,B$2:B$21,0),1)-I3)
and copy down to BB21
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
in BB3
=IF(INDEX(I$2:I$21,MATCH(B3,B$2:B$21,0),1)-I3=0,"",INDEX(I$2:I$21,MATCH(B3,B$2:B$21,0),1)-I3)
and copy down to BB21
Thank Special K and Joris
An afterthought:
Enter in BB2 and fill down.Formula:Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks