Quote:
Originally Posted by Shawnski
In the help menu, check the "countif" function. It will do what you want.
Alternatively you could make a pivot table from any column.
And if you need anything starting with just LX, not unique LX****, create a column using the "left" function, taking just two characters. You can then use either the countif, or pivot table methods on the new column.
|
Thanks, I will give it a look later