Drop down list from index/match formula

A

Alberto Martinez

Good morning!

Is it possible to show a drop down list form a formula designed to index distinct dates in a range ?

By using this formula I get a list of all the days in the year when we did inventory, I however would like to know if its possible to use the formula directly in the data validation drop down option so I don't have to create a list using formula in another page;

=INDEX(inventory_date,MATCH(0,COUNTIF($M$1:M1,inventory_date),0))

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
How to make repeating drop-down lists? 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
Countif, index and match 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
drop down list 1

Top