I have a table (C7:J19) that I use to calculate checks then I scan both sides of check .
Trying to have cell (K1)to display :
that when I select cell with check amount from table C7:J19),
to count all cells that have check amounts, from active cell back to the beginning of table,
multiply by 2 (because check scans 2 sides) to know which check # it's @ scanned checks
Trying to have cell (K1)to display :
that when I select cell with check amount from table C7:J19),
to count all cells that have check amounts, from active cell back to the beginning of table,
multiply by 2 (because check scans 2 sides) to know which check # it's @ scanned checks