Excel Question - Blanks https://www.lotterypost.com/thread/235861 Lottery Post Forum Topic: Excel Question - Blanks en-us Lottery Post RSS Generator Reply #3 https://www.lotterypost.com/thread/235861/2184844 https://www.lotterypost.com/thread/235861/2184844 Fri, 26 Aug 2011 20:01:04 GMT Teamprofit I used this formula and it works fine..

=LARGE(A1:A6,1)

=LARGE(A1:A6,2)

=LARGE(A1:A6,3)

It gives me the numbers i'm looking for while skipping the blanks :)

Thanks raven62 for trying to help

]]> Teamprofit Reply #2 https://www.lotterypost.com/thread/235861/2184763 https://www.lotterypost.com/thread/235861/2184763 Fri, 26 Aug 2011 19:15:17 GMT Teamprofit No, it didn't work

]]> Teamprofit Reply #1 https://www.lotterypost.com/thread/235861/2184675 https://www.lotterypost.com/thread/235861/2184675 Fri, 26 Aug 2011 18:07:26 GMT Raven62 Instead of A1:A6 try NOTA1:A6

]]> Raven62 Excel Question - Blanks https://www.lotterypost.com/thread/235861 https://www.lotterypost.com/thread/235861 Fri, 26 Aug 2011 17:57:17 GMT Teamprofit How can I create a formula that would give me the 2nd 3rd non blank cell?

Example.

A1 - blank

A2 - 48

A3 - blank

A4 - 05

A5 - blank

A6 - 20

(INDEX(A1:A6,MATCH(TRUE,A1:A6 ,0)) )

The formula above would give me the first number that is not blank - which is 48

I would like a formula that would give me the second number - which is 05

the third number - which is 20

Is this possible

]]> Teamprofit