A B C
1 Component RHrs Rhrs Since Last
2 S021 200 0
3 S021 400 200
4 P011 600 0
5 P011 900 300
6 S021 1000 600
7 S021 1200 ?
8 P011 1400 ?
Hi there.
Need help with formula that calculates C7=B7-B6 if A7 and A6 are the latest values of same component S021.
Also C8=B8-B5 as A8 and A5 are the latest entries of the same component P011.
I wish to have this formula in C column so i could drag it down for any number of entries in A and B column.
Bookmarks