So basically I followed this:
http://www.get-digital-help.com/2010...lues-in-excel/
...to make the file I attached. Right now I have no idea as to why column B of the Functions sheet only displays 3 out of the 6 unique entries. What do I need to change to make it display as many unique entries as possible?
Last edited by ObiWanBaloney; 05-11-2012 at 02:00 PM.
Remove +(Airline<>CName!$A$2) from the formula.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Oh sorry, I forgot to specify! The whole point is that when you pick the first drop list option (airline), it narrows down the second drop list options (destination) to the destinations unique to what airline you picked.
Change +(Airline<>CName!$A$2) to +(Airline<>Query!$B$1)
Doesn't work either, it returns the #N/A error for the first 7 rows and the #VALUE! error for the rest.
Can anyone shed some light on this?
ObiWanBaloney,
Attached is a modified version of your posted workbook. I made a few changes to the named range formulas and to the formulas on the Functions worksheet. It now seems to be working properly. It is important to note that the CName worksheet will need to be sorted by airline (I also did this) to keep it working properly. So when you add rows to the cname sheet, just do a sort and it'll be fine.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Ah that does work, thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks