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
Microsoft ExcelMicrosoft Office
Last Comment
Patricia Timm
8/22/2022 - Mon
Tom Farrar
Forgot the attachment..
Saqib Husain
No attachment found. Better attach a sample excel file instead of snip.
Patricia Timm
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.