K Kamarlon New Member Nov 10, 2011 #1 I have a list of numbers eg 1 5 3 8 5. What formula will tell me that number 8 is the 4th number in the series
I have a list of numbers eg 1 5 3 8 5. What formula will tell me that number 8 is the 4th number in the series
F fred Member Nov 10, 2011 #3 assuming all numbers are showing on different cells. =match(8,array,0) note that this will only return only the first "8" on the array.
assuming all numbers are showing on different cells. =match(8,array,0) note that this will only return only the first "8" on the array.
C Clarity New Member Nov 10, 2011 #4 Another option may be MATCH() =Match(Lookup Value, Lookup array, match type) Eg: =Match(8,range,0)
Luke M Excel Ninja Staff member Nov 10, 2011 #5 Hmm. I see Fred & I interpretted the question differently. My formula lets you know what the 4th numbers is, Fred's lets you find what position the 8 is in. Which question were you asking?
Hmm. I see Fred & I interpretted the question differently. My formula lets you know what the 4th numbers is, Fred's lets you find what position the 8 is in. Which question were you asking?
K Kamarlon New Member Nov 10, 2011 #6 I would say Fred interpreted it correctly. I wanted to know what position the 8 is in. Thanks guys. Will try it out and see.
I would say Fred interpreted it correctly. I wanted to know what position the 8 is in. Thanks guys. Will try it out and see.
