Ignore Blank or 0 cells
 

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

Ignore Blank or 0 cells
 

Try a dynamic range

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
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

Ignore Blank or 0 cells
 

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

"Peo Sjoblom" wrote:

Try a dynamic range

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
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

Ignore Blank or 0 cells
 

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


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

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
I don't know what a dynamic range is. Please explain.
Thanks

"Peo Sjoblom" wrote:

Try a dynamic range

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
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

Ignore Blank or 0 cells
 

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

"Peo Sjoblom" wrote:

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


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

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
I don't know what a dynamic range is. Please explain.
Thanks

"Peo Sjoblom" wrote:

Try a dynamic range

--


Regards,


Peo Sjoblom

"Dave" wrote in message
...
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