Managing Lists

I

iwilkin

In sheet 1 have a list of people in column A, against whom i hav
written "yes" when i have received a confirmation email from them. Al
is good.

Is it possible to have sheet 2 list the names of those people who hav
not replied - by reference to the fact that there is a blank cell i
column b(sheet 1) next to their name?

Is this possible? Any alternative suggestions? Many Thanks, Ia
 
M

Max

One way ..

In Sheet1
-----------
Assume you have in cols A and B,
data from row2 down

List
name1 Yes
name2
name3 Yes
name4
name5 Yes
name6 Yes
etc

Use an empty col to the right, say, col D
Put in D2: =IF(TRIM(B2)="",ROW(),"")
Copy down as many rows as there is data in col A

In Sheet2
-----------
With the header in A1: List

Put in A2:

=IF(ISERROR(MATCH(SMALL(Sheet1!$D:$D,ROW(A1)),Sheet1!$D:$D,0)),"",OFFSET(She
et1!$A$1,MATCH(SMALL(Sheet1!$D:$D,ROW(A1)),Sheet1!$D:$D,0)-1,))

Copy down by as amny rows as there is data in col A in Sheet1

Col A will extract only those names from Sheet1's col A
who have yet to reply (i.e. those names w/o a "Yes" in col B)
 
D

Dave Peterson

Another couple of options.

Sort your data to group it into two parts.

Or what I'd do:
select your range of data
data|filter|autofilter

Use those dropdowns to just show what you want to see (or print).
 
Top