PDA

View Full Version : Solved: "Attaching" and sorting arrays?



bdl004
09-23-2010, 01:18 AM
Hi guys,

I am stuck on a problem involving arrays (again). What I have is a bunch of names in one array (say: joe john jack jack joe joe john eric kevin) and I want to make a bar chart showing the name, and the percentage of times it occurs. I wish to sort this bar chart in descending order.

I would prefer to avoid making a pivot table or writing to a sheet too much as the data series is very large.

Thanks in advance!

Brett

Bob Phillips
09-23-2010, 02:16 AM
Surely, a pivot table/chart is ideal for managing large sets of data.

bdl004
09-23-2010, 04:18 AM
OK I will give this a go. Cheers!