pivot table n filtering of data
 

Hi,
My data is huge. Some 2 million rows n 50 coloumns.
Need to find duplicate invoice nos. from the vendors.Both are in coloumns.
But problem is while keyin data the special charactors like \ , / or. are
missing or not correctly entered.

Is there any formula where i can ignore this special charactors and only
match the aplphanumeric charactors.