Ignore Blank or 0 cells

[Dave]

1. I'm having trouble making a formula not use the blank or 0 cells. My
"pairings" sheet uses info from my "sign-up sheet" to pair up couples for a
golf tournament. There are blank cells in the "sign-up sheet" that get put
into the "pairings sheet" because the formula goes further than the list is.
That's so that I can add new couples as they sign up. I need the formula to
ignore those cells unless they have entries. My formula is this:
=INDEX('Sign-Up Sheet'!B3:B124,MATCH(LARGE('Sign-Up
Sheet'!F3:F124,1),'Sign-Up Sheet'!F3:F124,0))
It goes down 15 more rows.

2. I would also like to be able to pair up couples in a Random order from
the sign-up sheet. It would be a seperate sheet of course.

I would like to post this workbook but don't know how.

Thanks for any help on this!
Dave

 

[Peo Sjoblom]

Try a dynamic range

--


Regards,


Peo Sjoblom

 

[Dave]

I don't know what a dynamic range is. Please explain.
Thanks

 

[Peo Sjoblom]

Sorry Dave, I was supposed to paste in a link, here it is


http://www.contextures.com/xlNames01.html#Dynamic

--


Regards,


Peo Sjoblom

 

[Dave]

I tried this and it doesn't work. It only refers to part of the column.