Hi
I have a drop down list on a different sheet based on column A below. Ideally in my list I would like to set it up so that items don't appear if the status in column F changes to Complete.
List Example
A.........................F
Job 245 ...............Complete
Job 356 ...............Live
Job 500 ...............Live
Thanks
Try this to generate your data validation list copied down:
=IFERROR(INDEX($A$1:$A$500,AGGREGATE(15,6,ROW($2:$500)/($F$2:$F$500="Live"),ROW(1:1))),"")
You can put this in a later column (say column Z) and hide it. Just use it for the reference in the data validation.
Last edited by AliGW; 08-13-2018 at 10:37 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks