Home

Excel filter

Nadia39
Occasional Visitor

Hi Guys I am trying to filter Column B to E without changing Column A info how do I do that . Column A is numbers 1 to 10 in the rows and then Column B to E has info name, job, tel no etc. When I filter Column A must stay 1 to 10 and not adjust to the filters number. I know this might be a dumb question but could seriously need some help

 

I

1 Reply

Hi,

 

If you generate you index in column A by formula which ignores hidden cells. For example, for data like this

image.png

put in A3

=AGGREGATE(4,5,$A$2:$A2)+1

and drag it down

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies