Pick header Date when digit 2 appears for the very first time

[Noman050]

Hi all,

Can you help in creating a formula where you pick date of the row when the digit 2 appears for the very first time.

Attached is my data set.

Thanks in advance.

[ron2k_1]

Hey,

Here is a simple way to do it:

Please Login or Register  to view this content.

[Noman050]

Thanks it worked.