July 11, 2017
Hi There,
I'm trying to find a way that when I select a group from the drop-down list the associated hotels to that group appear, I have attached an example of the output required.
Any help gratefully accepted.
Thanks
Paul
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
July 11, 2017
Hi Sunny,
I'm still not able to get the formula to work on my worksheet? Is it because in my worksheet the Hotel column is before the Hotel Group column? and my workbook is sorted by Hotel where as yours is by Hotel Group?
Finally your formula has { } these brackets, not sure where these have come from?
So sorry to be a pain, perhaps you could update the formula in the attached so I can see where I'm going wrong?
Thanks
Paul
VIP
Trusted Members
June 25, 2016
Hi Paul
Please refer attachment.
The formulas are ARRAY formulas and need to be completed by CTRL+SHIFT+ENTER instead of ENTER.
The curly brackets {} are automatically inserted by Excel. You don't key them in.
You can refer https://www.myonlinetraininghu.....ay-formula for more detail about ARRAY formulas.
I could have given you a VBA solution but not sure if you would prefer it.
Whenever possible, make sure that your data is in a tabular format. It will make life more easy when you need to extract data using formulas,Pivot Table etc.
You can learn more about tabular format here https://www.myonlinetraininghu.....ata-format
Hope this helps.
Sunny
Answers Post
1 Guest(s)