Hi all, I have 10 col and 100 rows of random numbers. For simplicity and ease of example lets assume they are in order from 1 to 100 and repeating. i.e R1C1(A1)=1, R1C2(B1)=2...... R1C10(J1)=10,
R2C1(A2)=11, ..... R2C10(J2)=20
R10C1(A10)=91 ..... R10C10(J10)=100
R11C1(A11)=1, R3C2(B11)=2...... R3C10(J11)=10
.
.
.
.
R100C1(A100)=91 .......... R100C10(J100)=100

I would like a formula to find the row no of the nth occurrence of a particular value. In this example, lets say I would like to find the row numbers(just row no, irrespective of which column they occur in)) of the first 5 occurrences of Number '1', the answer should be 1, 11, 21, 31, and 41. For this example lets assume the answers are in R110C1(A110) to R114C1(A114). ie R110C1(A110)=1... etc. I tried googling and could not any solutions that worked. I tried experimenting with some solutions offered for other similar question but they did not work. I would like formulas and without any macros or VB. Thanks in advance, your help is much appreciated.
Jay