Please can some expert show me me how to apply Auto Filter method to filter my data. There are about 1000 rows and about 25 columns in my data set. Column A shows the Account Numbers and the filtering needs to be done based on Column A. The numbers in Column A look like this.
Acc. Nos.
1
3
4
7 etc. upto 799, then come Acc. Nos.
900
902 etc. upto 999, then come Acc Nos.
800
803 etc. upto 899
I would like someone to help me filter the data based on the following conditions.
Case 1. Filter the data from 1 to 999 leaving all 800 numbers.
Case 2. Filter the data for all 800 numbers.
Thank you very much
Acc. Nos.
1
3
4
7 etc. upto 799, then come Acc. Nos.
900
902 etc. upto 999, then come Acc Nos.
800
803 etc. upto 899
I would like someone to help me filter the data based on the following conditions.
Case 1. Filter the data from 1 to 999 leaving all 800 numbers.
Case 2. Filter the data for all 800 numbers.
Thank you very much