What if I want to put it in a table that is on the same sheet just 15-20
rows below the original table.

It becomes less neat, but you could adapt it like this
Assume source data is within A2:C30, key col B = RSVP (as before)
In A50: =IF(B2="No",ROWS($1:1),"")
In B50:
=IF(ROWS($1:1)COUNT($A$50:$A$78),"",INDEX(A$2:A$3 0,SMALL($A$50:$A$78,ROWS($1:1))))
Copy B50 to C50. Select A50:C50, fill down to C78. Cols B & C returns source
lines where RSVP = "No"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lee" wrote:
Max...Thanks that worked great when I put the data on a chart on a different
sheet.

What if I want to put it in a table that is on the same sheet just 15-20
rows below the original table. I have tried using a similar formula but
nothing seems to work. I can't figure out what I need to change. Thanks so
much!