edwardtong694
Board Regular
- Joined
- Aug 21, 2009
- Messages
- 125
Hi Guys,
Bit of a strange question this time but I hope someone can help.
I have a list in excel which I cannot determine the values before it is created. As this will differ each time data is copied into the template.
What I would like to do is create a formula which will automatically populate, two columns of data one containing the unique values entered into Cell A1 and then another column next to it with a count of the amount of times the values occur.
I would also like the data to be shown so it is arranged by the highest count at the top to the lowest.
Is this possible?
Thanks Ed
Bit of a strange question this time but I hope someone can help.
I have a list in excel which I cannot determine the values before it is created. As this will differ each time data is copied into the template.
What I would like to do is create a formula which will automatically populate, two columns of data one containing the unique values entered into Cell A1 and then another column next to it with a count of the amount of times the values occur.
I would also like the data to be shown so it is arranged by the highest count at the top to the lowest.
Is this possible?
Thanks Ed