I have an excel file that has listings with grouped entries. For example
1 1200-100-100
1 1200-100-100
2 1000-500-100
2 1200-100-100
3 1000-500-100
3 1200-100-100
3 1200-100-100
4 1200-100-100
4 1200-100-100
Is there a way to filter out all the entries that start with 1000-500-100 and their associated sub lines? For instance, I would want to separate out the following:
2 1000-500-500
2 1200-100-100
3 1000-500-100
3 1200-100-100
3 1200-100-100
Thanks!
1 1200-100-100
1 1200-100-100
2 1000-500-100
2 1200-100-100
3 1000-500-100
3 1200-100-100
3 1200-100-100
4 1200-100-100
4 1200-100-100
Is there a way to filter out all the entries that start with 1000-500-100 and their associated sub lines? For instance, I would want to separate out the following:
2 1000-500-500
2 1200-100-100
3 1000-500-100
3 1200-100-100
3 1200-100-100
Thanks!