Avatar of Patricia Timm
Patricia Timm
 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
Microsoft ExcelMicrosoft Office

Avatar of undefined
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
Your help has saved me hundreds of hours of internet surfing.
fblack61
Tom Farrar

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
Saqib Husain

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Rob Henson

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.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Patricia Timm

ASKER
Thank you and I will look into advanced filter as a future option