View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Goz Joe Goz is offline
external usenet poster
 
Posts: 1
Default How do I Hi- lite the max of last 20 entries

I'm using Excel to track price quotes that are entered once a day. I need to
Hi-Lite the 10 day Hi and 20 day Hi in one column, and the 10 day low and 20
day low in another column. The Hi and Low are to seperate columns.