Excel Formula for fleet sales listings

**Andy-SRIXP** · 03-31-2009, 09:36 AM

Hi All,

I'm new to all this so please go gentle on me.

I am trying to set a formula in a spreadsheet of 2500 lines which ones are the most popular, I can do this using the LARGE formula but the only problem is some of the data is duplicated, ie more than one name mentioned twice.

I have a list of clients and the same name appears more than once, I would like to be able to create a graph of the client names that appear more than ten times.

Hope this makes sense.

Andy

**NBVC** · 03-31-2009, 09:38 AM

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Also give some sample data and expected results...

**NBVC** · 03-31-2009, 10:59 AM

Thanks for taking the time to read and comply with the rule

.

Please have a look at the attached...

Formula in E2:

Please Login or Register  to view this content.

extracts the largest values (including dupes)

Formula in F2:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down extracts unique corresponding items.

**Andy-SRIXP** · 04-01-2009, 10:29 AM

Thanks for the code, it works but I need to ask another question related to it. I am trying to have a graph of the sales ofver 10 units from a list that is ever growing, is there any way that this could be done so that the company with the most sales units is on the left and the least on the right.

**NBVC** · 04-01-2009, 10:34 AM

If you arrange the formula columns so that the Company is on the left of the Largest numbers... then when you create the graph, it should default to the largest on the left...