Thread: Return values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
enyaw enyaw is offline
external usenet poster
 
Posts: 108
Default 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.