ArPharazon
Board Regular
- Joined
- May 3, 2004
- Messages
- 51
- Office Version
- 2016
- 2013
- 2007
- Platform
- Windows
I may be explaining this badly, which is probably why I haven't been able to come up with anything on Google for this.
I run a report every day for my job that I'd like to use a formula on that shows each distinct text value from a column and then how many instances of each there are.
At least I hope it can be done with a formula
Below is a generic example. What I'd like to end up seeing is: Name1 | 10 / Name2 | 6 / Name3 | 4 and filter out #N/A if possible. The values in this column are all the result of a vlookup.
I run a report every day for my job that I'd like to use a formula on that shows each distinct text value from a column and then how many instances of each there are.
At least I hope it can be done with a formula
Below is a generic example. What I'd like to end up seeing is: Name1 | 10 / Name2 | 6 / Name3 | 4 and filter out #N/A if possible. The values in this column are all the result of a vlookup.