2016-02-16_195805.png
Simple question maybe, help pls.
Column A (not unique values), Column B (unique values).
In F and G columns need dropdown list, based on A and B columns values. If category 1 (1st drop-down) then can choose one from all values for that category (drop-down 2).
Looks simple, but in column A values are not unique... And it not comfortably
And I need to avoid any helper columns.
Last edited by Remphan; 02-16-2016 at 01:35 PM.
Perhaps this might help..
http://www.contextures.com/xlDataVal02.html
Life's a spreadsheet, Excel!
Say thanks, Click *
Assuming your Drop Downs are in F2 and G2-
First you need to create two helper columns to extract the required data.
In this example I am using Column J and Column K as the Helper Columns.
So in cell J2 use this formula-
and in cell K2-
Please Login or Register to view this content.
Now create two drop-downs with range J2:J till end and K2:K till end..Please Login or Register to view this content.
Check attached for reference.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
I thought that could be avoided helper columns, but how I can understand browsing many examples in internet forums - it's no possible.Originally Posted by sourabhg98
Thank you very much for your response, It is useful for me.
Glad to know that helped!!
If your query is resolved, please take a moment to mark this thread as "Solved" from the "Thread Tools" at the top of this page.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks