I have a spreadsheet, that shows many different customers that purchase many different products each product bought will be a new row on the spreadsheet. What I want to do is on a seperate sheet have each customer shown only once and find out if at any point on the original sheet there is the word Permanent in the next column and if there is how often.
I'm sure there must be a way of doing this but I have never needed to.
Any help will be greatly appriciated.
Bookmarks