View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PaulinaDi PaulinaDi is offline
external usenet poster
 
Posts: 36
Default Hghlight the best price for each row

Unfortunately I didnĀ“t understand what to do.
I would like this formula to take me all the range once but select for each
row the best price.
e.g.

column J O R U X
row
15 10 11 9 8 5
16 13 12 11 8 14
17 20 12 5 13 16
18....
19....
44....

I would like on row 15 the number 5 be selected, on row 16 number 8
selected, on row 17 number 5 to be selected and so on.

"Don Guillett" wrote:

select row formula is
=a3=min($a$3:$x$3)
format as desired.