View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Top 10 Publications and Matching Text Values

Hi,

And by top 10 you mean what? The most frequently occuring items, the ones
with the largest cost, most circulation, biggest print?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kristy_6278" wrote:

Hello,

I am working on an excel document and I need to find out the top 10
publications in column E and then I need to match these top 10 against the
service lines in column J.

I have over 10000 lines and there are over 40 publications and 4 different
service lines. A lot of people have said do the autosort and count, but I
would be here all day.

Is someone able to help me?
--
WitkosRobinson