code in a PivotTable

[#1]

Hello All,

I am creating a PivotTable. This table shows unique numbers where test numbers included. As an example:

Column1

(unique numbers)      Column2 (testnumbers)       

11254                      38546

11254                      58745

11254                      98562

11589                      38596

11589                      65845

11589                      25698

11589                      25845

11589                      54856

When I make a PivotTable from here (see annex) do I should actually have a formula that represents whether there is a testnumber (38546 of 38596) in it. If attachment is an example of what I mean. So if there is a testnumber (38546 of 38596) in the unique numbers that must give Yes or No.

thank you very much for the reply.

with kind regards,

Hans

[jvitantonio · Accepted solution]

Hi, check this application. I hope it helps.

[#3]

Hoi,

Heel erg bedankt , hier kan ik zeker wat mee.

p.s. is dit een nederlands forum of is het beter dat ik alles er in het Engels neer zet?

[jvitantonio]

Sorry, I don't speak your language. You can post in any language but you will definetly get more answers if you post in English that is the common language!

[#5]

Oke Thanks