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!
 
Ad

Advertisements


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

Index/ Match 1
Index, Match?? 1
index and match 11
Index Match Functions 1
Match/ Index question 2
index/match help 1
Countif, index and match 2
Vlookup, Index or Match - Problem 2

Top