Link to home
Get AccessLog in
Avatar of Patricia Timm
Patricia TimmFlag for United States of America

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
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Forgot the attachment..

No attachment found. Better attach a sample excel file instead of snip.

Avatar of 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.
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Thank you and I will look into advanced filter as a future option