Sort/filter of List in excel with specified format

prince
2StarLounger
Posts: 171
Joined: 02 Mar 2015, 17:00

Sort/filter of List in excel with specified format

Post by prince »

Hello Sir/Madam, In the above-attached sheet I want the record of those candidates who have rollno started from (last digits) 2,6,10,14,18,22 (Gap of 4 digits in each number). which formula or code will work to sort these records according to their rollno?
Thanks and regards
Prince
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sort/filter of List in excel with specified format

Post by HansV »

I added a helper column. You can easily sort or filter on this column.

House List.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

prince
2StarLounger
Posts: 171
Joined: 02 Mar 2015, 17:00

Re: Sort/filter of List in excel with specified format

Post by prince »

Thank you sir for sort out the solution. Thank you for your support.
with regards
prince