Calgary_Neil
Board Regular
- Joined
- Apr 5, 2014
- Messages
- 79
I am wanting to find the column of the Nth (2nd) occurrence of "Y". The array that SMALL works on is correct, but SMALL returns 0, which is the 2nd smallest number after 0.
How do I remove the 0's or do this another way? TProd is a named range of 28 Columns, which has 2 "Y" in it (12, 19)
SMALL( (N( TProd="Y") * COLUMN( TProd)), 2)
Thankyou for reading
Neil (Excel 365)
How do I remove the 0's or do this another way? TProd is a named range of 28 Columns, which has 2 "Y" in it (12, 19)
SMALL( (N( TProd="Y") * COLUMN( TProd)), 2)
Thankyou for reading
Neil (Excel 365)