Hi, when placing an "x" in columns B and C the output is listed in Columns D and E respectively. Is there a way to replace the "x" in columns B and C with Check boxes? I am planning to create up to 200 check boxes so I'm not sure if this will effect performance or if there is a better way?. The main aim is to be able to click in and out of cells to select or de-select items that will add themselves to the list results in D and C - Thanks for any help or ideas.
How about this for a sample. Adding all of those check boxes could be a nightmare.
Just double click on anything in B2:C20.
Also, I added an additional formula due to the fact the Aggregate function is not available with an Excel version earlier than 2010. That might not be a problem for you, but just in case.
Last edited by jeffreybrown; 06-07-2018 at 11:41 AM.
HTH
Regards, Jeff
Awesome, thank-you, that is a great solution and even better than check boxes. If I may ask, if I wanted to add more item lists eg, a new list in columbs G M and S with essential and desirable is it possible to have the result output in the original 2 columbs D and E as in the new example attached?, thanks again for your help on this.
For future reference, try to include the full setup in your initial post, because nothing is coming to mind on this and I may have left this to others.
I will leave a post for some of the formula guru's to step in.
will do - sorry I am a bit of a newbie on forums so just getting used to how they work but will put full question at the start in future. Thanks again for your help, your solution has got me much further ahead in a better way than I expected, so glad you picked up on it. thanks again
S8S,
Your new example has the same items in G M and S as the items listed in A... so how would they be distinguishable from each other?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
sorry, they will be different, I didnt update the sheet properly - please see attached for updated example
Lets see if this works... instead of formulas the code does the listing, and kept jeffreybrown's great checkmark code, just expanded to use any columns defined in an array at the start
I also made it more dynamic, so you can go to any row and the code should be good. (listing and double-clicking will work up to last row of the column it belongs with). So if last row in Col A that has data is row 40 then B and C will also work for clicking up to row 40.
Last edited by Arkadi; 06-07-2018 at 01:50 PM.
That, is absolutely perfect - thank-you guys, much appreciated - this has really really helped me out cheers :-)
So happy you now have your solution.
Thanks Arkadi, great work.
Thanks for the rep and feedback S8S, as well as marking the thread as solved.
Thanks jeffreybrown, I just added some to the great job you had already done! By the way, it WAS your request in Call in the Cavalry that brought me here, so the OP owes his solution to your efforts there also
Last edited by Arkadi; 06-07-2018 at 02:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks