D
dkenebre
How can I use the vlookup table to calculate how many orange rows bac
since each value (0-9) has last occurred in each of the 3 columns AF
AG and AH.
Also, everytime a 0-9 digit is entered in the
rows with the 3 orange cells (AF, AG and AH) they will update th
Vlookup table. The Vlookup
should calculate how many orange rows back since each digit las
occurred in each of
the 3 cells. . eg. ….The last entry was 871 (AF434:AH434), which shoul
be programmed to update the record in the vlookup table.
In the vlookup table ED49 is 0 for digit #8 and EF48 is 0 for digit #
and EG42 is 0 for digit 1. The orange row entry before that wa
(AF432:AH432) 109, which is updated in the vlookup table as 1 orang
row back, see ED42=1, EF41=1, EG50=1.
Let me know if this need further explanation. Thank
since each value (0-9) has last occurred in each of the 3 columns AF
AG and AH.
Also, everytime a 0-9 digit is entered in the
rows with the 3 orange cells (AF, AG and AH) they will update th
Vlookup table. The Vlookup
should calculate how many orange rows back since each digit las
occurred in each of
the 3 cells. . eg. ….The last entry was 871 (AF434:AH434), which shoul
be programmed to update the record in the vlookup table.
In the vlookup table ED49 is 0 for digit #8 and EF48 is 0 for digit #
and EG42 is 0 for digit 1. The orange row entry before that wa
(AF432:AH432) 109, which is updated in the vlookup table as 1 orang
row back, see ED42=1, EF41=1, EG50=1.
Let me know if this need further explanation. Thank