Hi there and welcome
Is ti just one value you are looking for in column B? Or exactly what are the rules for this?
ok, can you give me the file and Ill do it for you.
Attach it here please
ok... so you mean row 3 should be blank?
As its shown in row 2?
ok, I tried to think through how you could do this with all the different criteria but could not see how.
I will opt out for a different expert that may see how this can best be done.
i have your example sheet, but I am not exactly following what you want to do.
if you want to do a remote session to show me anything we can do that.
but is it my unsterstanding that for example YFP is one of the values in column B but you only want that to show 1 time instead of 2 times
the only way to do a pivot table like function is with a macro. Now you said that there will be selling purchases and multiple people, I would like to see an example of what that looks like, because any attempt to write a macro could change things if you have a different format