View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Reza Reza is offline
external usenet poster
 
Posts: 88
Default returning a different cell value

heya,

based on a condition, i want the return value to be the value at the top of
the column.
for example,

i want to find the largest and 2nd largest values in a row =LARGE(B4:Q4,1)
& =LARGE(B4:Q4,2), but i want there return values to be the text in their
respective columns. so if B4 was the largest i want the return value to be
text in B1 (column header)

Thank you person who is smarter than me :), thanks