Thread: maximum formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Graciegirl Graciegirl is offline
external usenet poster
 
Posts: 8
Default maximum formula

=IF(B20,A2,"")

based on Age as a number in column A
based on Mode in column B based on a number greater than 0 (if zero or
empty, will leave the cell blank.
--
Gracie


"excelguy" wrote:

I created to 2 columns one next to the other called Mode and Age. I want to
create a formula so that the value in column Age will appear only if the
maximum value in the Mode column is on the same row.