I am trying to build a sequential list without the use of either VBA or ARRAY Formulas. The example below uses Array Formula, but I have used this to demonstrate what I am trying to achieve.
Column B - List Ref is a random entry of numbers
Column C will define the Point reference, associated to the number found in the adjacent cell in column B
Column D determines whether to display the Point Reference. 0 = ignore 1 re-act.
The way this works is that if Col D is a 0, then Column B is ignored and Col C remains blank.
If Col D is a 1 then Col B is checked. Col C will check to see if the value in col B has already be represented, if it has not then it will display the value from Col C. If the value HAS been represented it will determine the next point value available and increment accordingly.
Does this make sense, can it be done without Arrys formula or VBA?
Any thoughts would be welcomed.
Column B - List Ref is a random entry of numbers
Column C will define the Point reference, associated to the number found in the adjacent cell in column B
Column D determines whether to display the Point Reference. 0 = ignore 1 re-act.
The way this works is that if Col D is a 0, then Column B is ignored and Col C remains blank.
If Col D is a 1 then Col B is checked. Col C will check to see if the value in col B has already be represented, if it has not then it will display the value from Col C. If the value HAS been represented it will determine the next point value available and increment accordingly.
Does this make sense, can it be done without Arrys formula or VBA?
Any thoughts would be welcomed.
