LinkBack URL
About LinkBacks
Hello to all,
I would like to know if there is a function to display two values according to a filter in an table.
I have attached an excel describing the need.
In advance I thank you and wish you all a happy holiday season.
Sincerely.
Benten667
Function reacting with an table filter
Hello to all,
I would like to know if there is a function to display two values according to a filter in an table.
I have attached an excel describing the need.
In advance I thank you and wish you all a happy holiday season.
Sincerely.
Benten667
Last edited by Benten667; 12-23-2022 at 11:26 AM.
Try:
=IF(SUMPRODUCT(($C$4:$C$8=C5)*(SUBTOTAL(103,OFFSET($C$4,ROW($C$4:$C$8)-ROW($C$4),0))))>0,"FV6","FV7")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
You are a boss, thanks 1000x for the responsiveness!
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
Or tryFormula:
Please Login or Register to view this content.
Indeed, Hans!
Thank you for your answer also it works and it is shorter.
Unfortunately for me the application in which I want to use this formula does not work.
Indeed I filter through checkboxes with the values of the column in a window that I display via a button in vba (my original file is 30 tabs).
I have the impression that filtering via a vba code does not activate the formula (?)
Does mine work in your real sheet?
No unfortunately it's identical, the vba macro filter doesn't seem to work with the formula...
I know virtually nothing about VBA... but certainly cannot tell without seeing the macro in a sample file.
I have attached a second excel to my initial post. You can see that with sorting on FV 1 or FV 31 in the second tab the function does not interact.
But... since, when you apply the filter you are KEEPING either FV1 or FV31.... the 8th row (with the formula) is being hidden... or am I missing the point?
Hello Glenn,
Sorry for the late reply and happy new year 2023.
The problem I am having with this is that the formula works in the second tab when you do a "manual" sort on the column.
On the other hand, when we check in the box containing a vba code the "FV1" or the "FV31" the formula of the cell of the second tab does not apply and indeed the cell becomes hidden.
I hope to have been clear in which case I remain always at disposal.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks