T Tarheel8181 New Member Dec 30, 2014 #1 See attached. Looking for formulas that will provide appropriate list. Attachments Excel Question 2.xlsx Excel Question 2.xlsx 10.6 KB · Views: 14
azumi Active Member Dec 31, 2014 #2 Perhaps something like this? Using array formula Attachments Excel Question 2.xlsx Excel Question 2.xlsx 11.6 KB · Views: 11