LinkBack URL
About LinkBacks
Hi,
I want to learn on how to filter data by groups. as for my example, if i want to filter by product# cell B14 which is 182514 values from J14:J25 should remain.
thanks in advance.
Filtering_groups.png
Hi,
I want to learn on how to filter data by groups. as for my example, if i want to filter by product# cell B14 which is 182514 values from J14:J25 should remain.
thanks in advance.
Filtering_groups.png
In order for this to work, the filtered value needs to appear on every row that you want to remain when you filter. Columns A to I need copying down in each group.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Doing what Ali suggests is a good way to do this, but with 180 000 + rows of data, maybe not practical
Another option would be to use a helper column to fill in the gaps for you.
I used T, but use whichever is best for you...
T2=IF(b2="",T1,b2)
copied down
You can then filter on that column
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It could be done quickly and easily using Power Query's fill down feature.
yes you are right, my problem is that i have more than 10,000 datas on columns J
Originally Posted by FDibbins
Doing what Ali suggests is a good way to do this, but with 180 000 + rows of data, maybe not practical
Another option would be to use a helper column to fill in the gaps for you.
I used T, but use whichever is best for you...
T2=IF(b2="",T1,b2)
copied down
You can then filter on that column
thank you mam. but I have more than 10,000 values on columns J
It could be done quickly and easily using Power Query's fill down feature.
So did you try my suggestion yet?
Yes sir i have tried it but confuse, correct me if I'm wrong. Since B2, B14 and B26 has different values, with your formula given, it is just I only copied the value from B2 to B26
The whole point of my suggestion is to test to see if a cell in B is empty.
If it IS, it takes the answer from the cell above (in the helper column).
If it is NOT, then it takes teh contents of that B cell
T2=IF(b2="",T1,b2)
You need to copy that ALL the way down
thanks. I already did the Fill down feature.
It could be done quickly and easily using Power Query's fill down feature.
So the issue is now solved - yes?
SOLVED. thank you
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks