Forum Discussion

shalinprasad's avatar
shalinprasad
Copper Contributor
Apr 13, 2021

Excel AutoFilter

I have more than 10000 records in a coloumn with 5 unique values but the excel auto filter is able to fetch only 3 values out of 5

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    shalinprasad 

    I'd first check the range if all data are covered and if "unique" values are actually identical (no no-printable characters, etc) simply by something like =A5=A873