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
Sort/filter of List in excel with specified format
-
- 2StarLounger
- Posts: 171
- Joined: 02 Mar 2015, 17:00
Sort/filter of List in excel with specified format
You do not have the required permissions to view the files attached to this post.
-
- 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
I added a helper column. You can easily sort or filter on this column.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 171
- Joined: 02 Mar 2015, 17:00
Re: Sort/filter of List in excel with specified format
Thank you sir for sort out the solution. Thank you for your support.
with regards
prince
with regards
prince