Retain Value of Variable's First Instance

[rschmidt46]

I'm posting this question again with a different name in hopes that I'll get an answer! A variable is set at the value of a cell during a loop. How can I retain that first value while the loop continues? The loop resets it the next time it finds a condition that meets the criteria. The loop goes from column to column looking for a value of "Yes". I need to keep the value of the cell in Row 1 of the column in which the first "Yes" occurs and then locate the value of the cell in Row 1 of the column in which the 2nd "Yes" is found. I need to put both values into a statement.

 

[NdNoviceHlp]

A review of the forum etiquette may be helpful re. Keep First Value of Variable in a Loop but not Exiting the Loop
It seems that help was being offered but was not accepted or acted upon. Dave
ps. TempVar= 1stValue

 

[Peter_SSs]

Duplicate as mentioned.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread above.