View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
St@cy St@cy is offline
external usenet poster
 
Posts: 24
Default Please help w/ INDIRECT

I get "No Show" everytime for the following:

=IF(ISERROR(INDIRECT(ADDRESS(26,MIN(COLUMN(X33:IV3 3)*(X33:$IV33<"")))))=TRUE,"No Show",INDIRECT(ADDRESS(26,MIN(COLUMN(X33:IV33)*(X3 3:$IV33<"")))))

I have an INDIRECT function that works for MAX, but I now want to use MIN.
I need a way to return "No Show" if all columns are blank in columns X:IV.
Please help me fix this function.