D
dkenebre
I would like to build a formula that allows me to
go back 50 records in the database to locate and list how many records
since the last time the farthest back of the 3 evaluated cells last
occurred.
example:
,,,,,,,,,,,,C42
9,,,,6,,,,2
,,,,,,,,,,,,C48
0,,,,7,,,3
A49
7,,,,4,,,,1
A51 B51 C51 (The evaluated cells)
3,,,,7,,,,2
Therefore, the result would list 9, because from the cell values
3,7,2, #2 was the furtherest back in the last 50 records.
It last occurred 9 records ago.
go back 50 records in the database to locate and list how many records
since the last time the farthest back of the 3 evaluated cells last
occurred.
example:
,,,,,,,,,,,,C42
9,,,,6,,,,2
,,,,,,,,,,,,C48
0,,,,7,,,3
A49
7,,,,4,,,,1
A51 B51 C51 (The evaluated cells)
3,,,,7,,,,2
Therefore, the result would list 9, because from the cell values
3,7,2, #2 was the furtherest back in the last 50 records.
It last occurred 9 records ago.