Pivot table showing how a Batsman was given out

[Aussiebear]

In the attached workbook is a summary of the runs scored by the Mythical VBAX cricket club for three matches. I would like (if possible) for a pivot table to show how each of the Batsmen were given out per match. For you non Cricket lovers.... there are two innings possible per match.

[Paul_Hossler]

This is the best non-VBA solution I could come up with

Requires formatting the PT data area with Wingdings and a custom number format

30884

Two typos in Table1 (marked)

[Aussiebear]

Thank you Paul

[p45cal]

a pivot table to show how each of the Batsmen were given out per match. For you non Cricket lovers.... there are two innings possible per match.maybe also:30888

[Aussiebear]

Thank you P45cal. Unfortunately your version does not run on a Mac for some reason. I like the fact that it shows the reason rather than a count in my version. Paul's version is clever but shows as a tick. By the way I've been going over your bowling performances and I think you should be picked for the Lord's Test.

Error message given. Data Model features will not run on this version of Excel.

[p45cal]

MS365 without Data Model or Pivot:
30890
In haste, 3 formulae in green, the one in L2 copied down and across.

[Aussiebear]

Thank you P45cal