We help IT Professionals succeed at work.

Format a filtered result set

Patricia Timm
Patricia Timm asked
on
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
Comment
Watch Question

View Solutions Only

Tom FarrarConsultant
CERTIFIED EXPERT

Commented:
Forgot the attachment..
Saqib Husain, SyedEngineer
CERTIFIED EXPERT

Commented:

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

Patricia Timm

Author

Commented:
Did the attachment work? Otherwise, I typed the result. Thanks
Tom FarrarConsultant
CERTIFIED EXPERT

Commented:
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.
Engineer
CERTIFIED EXPERT
Commented:

The row numbers would not change in the filtered range. That is how excel works.


You might like to consider workarounds eg

   -   copying the filtered data to another sheet and then sending out

   -   adding a column for row numbers

Rob HensonFinance Analyst
CERTIFIED EXPERT
Commented:
The attachment is a Word document, can you upload an Excel file instead?

One way of creating an extract from data based on criteria, eg a filter, is to use Advanced Filter.

Advanced Filter doesn't use the dropdown selections like Auto Filter. Instead you create a separate table of criteria with specific entries or Wild Card or comparison style entries. A sample file would make it much easier to demonstrate.
Patricia Timm

Author

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