D
dkenebre
I would like to create a VBA or formula that allows me to go back to
specific rows or number of records in the database to locate and list
how many records since the last time the farthest back value of the 3
evaluated cell values last occurred.
example:
,,,,,,,,,,,,C41
9,,,,6,,,,2
,,,,,,,,,,,,C47
0,,,,7,,,3
A49
7,,,,4,,,,1
A51 B51 C51 (The evaluated cells)
3,,,,7,,,,2
Therefore, the result would list 7, because from the cell values
3,7,2, #2 was the farthest back, when we manually selected the last 10
odd row records and the last 2 previous even row records of cells A,
B and C to review. This is a total of 12 records of A, B and C cell
values being evaluated by this condition. Number 2 last occurred 7
records ago, which were within the 2 previous A,B, C cell records and
last 5 odd A,B, C cell row records back.
Another way to explain it is:
F28 G28 H28 (The evaluated cells)
6 5 2
The last occurrence of number 6 was 2 days ago at G26, it is the
earliest most recent days back occurrence of the numbers within F28,
G28 and H28, then number 5 appears the next most recently back in cell
H24, then number 2 is the furthest days back since it’s last
occurrence, it’s last occurrence was in F20, or 8 rows back Because
number 2 was furthest back, I want to list the number of rows since the
occurrence of the furthest back of the numbers 6, 5 and 2 in the P
column, in this case cell C28. Because I manually selected the last 20
consecutive rows back to evaluate this condition. Therefore, the answer
would be 8, because number 2 last occurred 8 cell rows back within the
20 selected rows of cells F, G and H and is the furthest back of the 3
cell values evaluated. The function or formula will only review the of
rows back that have been manually selected. I would like to pick the
rows to evaluate this condition.
So I would want the function or formula if possible to evaluate cells
ae, af, and ag and place the answer in cell p
specific rows or number of records in the database to locate and list
how many records since the last time the farthest back value of the 3
evaluated cell values last occurred.
example:
,,,,,,,,,,,,C41
9,,,,6,,,,2
,,,,,,,,,,,,C47
0,,,,7,,,3
A49
7,,,,4,,,,1
A51 B51 C51 (The evaluated cells)
3,,,,7,,,,2
Therefore, the result would list 7, because from the cell values
3,7,2, #2 was the farthest back, when we manually selected the last 10
odd row records and the last 2 previous even row records of cells A,
B and C to review. This is a total of 12 records of A, B and C cell
values being evaluated by this condition. Number 2 last occurred 7
records ago, which were within the 2 previous A,B, C cell records and
last 5 odd A,B, C cell row records back.
Another way to explain it is:
F28 G28 H28 (The evaluated cells)
6 5 2
The last occurrence of number 6 was 2 days ago at G26, it is the
earliest most recent days back occurrence of the numbers within F28,
G28 and H28, then number 5 appears the next most recently back in cell
H24, then number 2 is the furthest days back since it’s last
occurrence, it’s last occurrence was in F20, or 8 rows back Because
number 2 was furthest back, I want to list the number of rows since the
occurrence of the furthest back of the numbers 6, 5 and 2 in the P
column, in this case cell C28. Because I manually selected the last 20
consecutive rows back to evaluate this condition. Therefore, the answer
would be 8, because number 2 last occurred 8 cell rows back within the
20 selected rows of cells F, G and H and is the furthest back of the 3
cell values evaluated. The function or formula will only review the of
rows back that have been manually selected. I would like to pick the
rows to evaluate this condition.
So I would want the function or formula if possible to evaluate cells
ae, af, and ag and place the answer in cell p