I have date in Cloumn A, Name in Cloumn B and Product sale data in Cloumn C. Now I want formula which gives me in return in another table, If that person has sold someting on particulur date that sale data entry is shown

CodePudding user response：

Do it with a pivot table so that you will have the answer without any formula.

CodePudding user response：

Try query() with a pivot clause, like this:

=query(A1:C, "select A, B, count(B) where A is not null group by A, B pivot C", 1)