I'm not entirely sure how to express what I am attempting to do, but I will do the best I can.
I'm wanting to count non-contiguous cells in Excel in the order which they are clicked.
For instance, lets say that column A
has a drop down and I want column B
to record in what order the column A
drop down was selected. So if a person were to skip past A1:A3
and select A4
then B4
would equal 1
; next they select A2
then set B2=2
.
Is this at all possible? I've tried indexing, vlookups, counts, helper cells, and nothing seems to work since I'm assuming Excel thinks in a sequential manner and what I'm doing is trying to account for seemly random non-sequential human interaction.
Disabling iterative calculation is also not an option as there are other references that rely on iterations.
I know VBA, but only very lightly. Any help on would be greatly appreciated. Thank you.