cavemonkey
06-19-2007, 05:44 PM
Hi
I've been asked to write a code that can allow the user to filter out any repeated values or cells in a spreadsheet and also count the number of times that particular value or cell has been repeated. I have no idea where to start. Finding a particular cell is easy but to filter out all repeating cells and to also count the number of times they are repeated is a little challenging to me.
Please help. Thanks
Attached is a example of what I'm hoping to achieve. Its a bit messy hopefully it won't further confuse anyone.
I've been asked to write a code that can allow the user to filter out any repeated values or cells in a spreadsheet and also count the number of times that particular value or cell has been repeated. I have no idea where to start. Finding a particular cell is easy but to filter out all repeating cells and to also count the number of times they are repeated is a little challenging to me.
Please help. Thanks
Attached is a example of what I'm hoping to achieve. Its a bit messy hopefully it won't further confuse anyone.