View Single Post
  #1   Report Post  
MarciaAnn
 
Posts: n/a
Default Is it possible to do this ...

I have a 5-column set of data: Artists, US Sales Low, US Sales High,
ROW Sales Low, ROW Sales High. What I want to do is find the top 100
artists total, from both Sales High columns combined and conversely the
lowest 100. What formula would I use to make such a comparison?