View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jkr@knord.dk is offline
external usenet poster
 
Posts: 8
Default Match and Tables

Can anybody tell me what to do:

I have a calculated table {=TABLE(B6,C6)} in cells C22:H33 and use
this formula:

=MATCH(MAX(C22:H33),C22:H33) but it alwys returns N/A.

Is there another way to get the row number for the cell, containing
the maximum value?

Jan