Return values
 

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.

Return values
 

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.
--
Gary''s Student - gsnu200717


"enyaw" wrote:

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.