Thread: Help me
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Help me

Try in H4 and copy down
=INDEX($B$3:$F$3,MATCH(SMALL(B4:F4,1),B4:F4))

"Kinghart" wrote:


I'm attaching a sample... can anyone help me


+-------------------------------------------------------------------+
|Filename: 1226710576.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=124|
+-------------------------------------------------------------------+



--
Kinghart