K
Kevin Gallagher
I have this which works....
{=MIN(IF((list!$C$3:$C$7202=B4),list!I3:I7202))}
This formala returns the value in column I (the minimum value that
meets the criteria), however once I find the minimum, I would also like
to know the values in the other columns within the same row (e.g. other
information about the row entry).
How can I find other infomation in the same row as the value I am
finding with the array formala above.
All help woudl be very much appreciated
{=MIN(IF((list!$C$3:$C$7202=B4),list!I3:I7202))}
This formala returns the value in column I (the minimum value that
meets the criteria), however once I find the minimum, I would also like
to know the values in the other columns within the same row (e.g. other
information about the row entry).
How can I find other infomation in the same row as the value I am
finding with the array formala above.
All help woudl be very much appreciated