Return values

E

enyaw

I have a table with peoples names in the left column. Under the different
headings in the table are numbers. What i want to do is have a seperate
sheet and have the peoples name on it. I want it to return the heading of
the column if the number for that person is equal to four. I dont want any
headings returned if they are not equal to four. Can anyone help.
 
G

Gary''s Student

Use AutoFilter:

Select the column heading for the column containing the numbers and:

Data > Filter > Autofilter

then select 4 from the pull-down

Copy the visible rows and paste them into the separate sheet.
 
Top