January 7, 2012
I am having what is known by the 'kids' as a brain fart!
I have a spreadsheet that contains several hundred rows of goods and services which the user can select what they need to complete a project - yes, it's a glorified shopping list...
Anyway within the list are some groups of items where if they select one of the items, I need to then stop them from selecting others of a similar nature.
For example, to complete the project, the user may need to order a mobile crane, and can select from a range of cranes of different sizes - they can only select one crane from the range, but they can have use of it for as many days as they need.
the list has 5 cranes (A,B,C,D,E). If the user selects Crane A then I need to block them from also selecting cranes B, C, D and E. Each crane is detailed on a separate row in the workbook.
Likewise, if they select Crane C then they can't have A, B, D or E...
I hope this makes sense. ♂️
I know it would be easier to use a drop-down list to select from, but the workbook is not mine and therefore I am restricted to adding logic functionality to it and not changing the original layout.
This all said - I can't for the life of me, think how to achieve this - and I know it shouldn't be that difficult... as stated Brain Fart!
Any guidance will be gratefully received.
December 7, 2016
Can you add a sample with some dummy data so we can see how the data is structured and what the limitations are? Makes it much easier to hopefully find a solution.
Attached is a simple solution using the FILTER function, either to be used in a data validation list or to check against. If it is doable or not for you I don’t know.
January 7, 2012
Thank you so much for your response - what you have shown is very interesting, and will be of use on some other issues I am having.
However, the current issue is simpler, and yet is still eluding me.
I have attached a spreadsheet with an example, and as you will see its simpler, but I can't see how to deal with stopping or flagging 'illegal' selections.
Any pointers are gratefully received.