using the 2004 at the moment though owing to the VBA and Macro support (not good taking this out of 2008?!). I am using Excel for Mac and have both the 20 versions.
If needs be more than happy to post a small file if it would be useful. In Worksheet 1 if I choose 'Dog' from my Combo box (or drop-down) along with showing all of the duplicates it returns '3', instead of what I want 'Dog' and no duplicates.Ĭan anyone point me in the direction of what else I could try? Hope that someone can help, please. In addition the drop-down was linked to a cell and the value returned to the cell was a number based on the position in the list when what I actually wanted was the text. A drop-down box will return a complete list (including all of the duplicates). The values in the column have many duplications, and I simply want the combo box to return a unique list.Īfter trying this using various options like drop-down boxes, combo boxes etc it does not seem to work. I need to create a drop-down (or a combo list) list based on a column in a separate worksheet (in the same workbook). In 2008, I was selected as one of the best instructors in the entire California Community College system. Learn how to 'transpose data' - switching the columns and rows in Excel. Learn how to remove duplicates from data in Excel. Hi All, first post here and have already used the search for some valuable advice and hope someone can be kind enough to help with the following: The training uses Excel 2011 for an Apple Mac.
