asked on
Format a filtered result set
I have attached a snip for review. I apply a filter to my column and when I get results they look like the attached file. I want to keep my results but would like them listed as A1, A2, A3 not as the results show A129, A153, A169. If I remove the filter - obviously my result set that I need is not there.
I am sending to someone and would rather it look clean, Thanks in advance and included is the attachment
Looks like this
A B
1 client Group
129 Jim A
153 Bob B
169 John C
So this is how the filtered portion looks
Should be
A B
1 client Group
2 Jim A
3 Bob B
4 John C
Filtered_format_result_set.docx
I am sending to someone and would rather it look clean, Thanks in advance and included is the attachment
Looks like this
A B
1 client Group
129 Jim A
153 Bob B
169 John C
So this is how the filtered portion looks
Should be
A B
1 client Group
2 Jim A
3 Bob B
4 John C
Filtered_format_result_set.docx
Microsoft ExcelMicrosoft Office
Last Comment
Patricia Timm
Forgot the attachment..
No attachment found. Better attach a sample excel file instead of snip.
ASKER
Did the attachment work? Otherwise, I typed the result. Thanks
There may be a way to do this without copy/pasting the records into a new sheet before sending out. The filtered numbering makes sense as the 1, 129, 153... was the row that the data was in before filtering.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you and I will look into advanced filter as a future option