Thread: Finding top 20% of spend dollars in a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wjs81866 wjs81866 is offline
external usenet poster
  
Posts: 1
Default Finding top 20% of spend dollars in a column
I can't remember the formula to find the top 20% of the dollars spent in a
column.

I have 692 rows with dollar amounts I need to report the % (rank) compared
to everything else in the column.
Reply With QuoteReply With Quote