Looking for formula. Please see attached. Any ideas?
T Tarheel8181 New Member Jan 28, 2015 #1 Looking for formula. Please see attached. Any ideas? Attachments Excel Question 1.xlsx 10 KB · Views: 3
Luke M Excel Ninja Staff member Jan 28, 2015 #2 Check out the array formula in attached. Attachments Excel Answer.xlsx 9.7 KB · Views: 4
John Jairo V Well-Known Member Jan 28, 2015 #3 Hi @Tarheel8181 and @Luke M. Another option here. Blessings! Attachments Excel Answer 2.xlsx 10.6 KB · Views: 1