How can I Show the first, second, and third deposit in every Member name? Pivot Table.

CodePudding user response：

Assuming your spreadsheet starts at cell A1 and your data is sorted by date, create a new column to the right called Deposit No. and put this formula into cell D2 ...

=COUNTIF($A$2:$A2,A2)

... then fill down.

Now include that field in your pivot table and filter on it.