Excel: Retrieve rows based on string search
Closed
Dennis
-
Aug 18, 2010 at 07:39 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 07:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 07:44 AM
Related:
- Excel: Retrieve rows based on string search
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Kernel for excel - Download - Backup and recovery
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 18, 2010 at 07:44 AM
Aug 18, 2010 at 07:44 AM
I would say you need to use two functions
a. Match. This would allow you to use wild card so you can locate the sub string and will give you the row number where the match occured.
b. indirect. since match gives you the row number, and assuming columns and sheet name are static, you can hard code them and get to the result indirectly
a. Match. This would allow you to use wild card so you can locate the sub string and will give you the row number where the match occured.
b. indirect. since match gives you the row number, and assuming columns and sheet name are static, you can hard code them and get to the result indirectly