Picking From a drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-2817215%22%20slang%3D%22en-US%22%3EPicking%20From%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817215%22%20slang%3D%22en-US%22%3E%3CP%3EWithout%20using%20tables%2C%20how%20do%20I%20use%20the%20'pick%20from%20a%20drop%20down%20list'%20function%20with%20figures%20%3F%20It%20works%20fine%20with%20text%2C%20but%20not%20with%20figures.%20I'm%20probably%20doing%20something%20basically%20pretty%20stupid%2C%20so%20any%20guidance%20would%20be%20appreciated.%20Thanks%20in%20advance.%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2817215%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2817789%22%20slang%3D%22en-US%22%3ERe%3A%20Picking%20From%20a%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1176992%22%20target%3D%22_blank%22%3E%40DannyMac784%3C%2FA%3E%26nbsp%3BWith%20%22figures%22%20you%20mean%20numbers%3F%20If%20so%2C%20you%20can%20type%20e.g.%20%221%2C2%2C3%2C4%2C5%22%20(without%20the%20quotation%20marks)%20in%20the%20Data%20Validation%20list%20box.%20This%20will%20create%20a%20dropdown%20list%20with%20numbers%201%20through%205%20to%20select%20from.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Without using tables, how do I use the 'pick from a drop down list' function with figures ? It works fine with text, but not with figures. I'm probably doing something basically pretty stupid, so any guidance would be appreciated. Thanks in advance.

 

4 Replies

@DannyMac784 With "figures" you mean numbers? If so, you can type e.g. "1,2,3,4,5" (without the quotation marks) in the Data Validation list box. This will create a dropdown list with numbers 1 through 5 to select from.

@Riny_van_Eekelen 

Hi Riny - thanks for your help my fried, that was extremely useful. 

I have another question, and I promise it will be the last one

Can I stop a duplicate entry being made in a cell ?

For example, I have a column of numbers, and I don't want someone to input the same number into a different cell in the same column ?

This also applies to a column of letters or names.

If I don't want the user to repeat a name in the same column, can this also be achieved in the same manner ? Thank you once again for your assistance...

@DannyMac784 Mmmmm... can't really think of an easy way to do that right now.

I know. I've looked at probably every tool within excel, and unless I'm looking in totally the wrong places, which I doubt, I don't think there is an option to warn, highlight or prevent input of the same entry into a column. Back to the drawing board. Thanks for your help anyway Riny, it's much appreciated mate.