Consolidate Multiple Column Cells Into 1 Based on Cell Value in Row
I am working on a telecom cleanup project and have an export of all the telephone numbers at each site. I'm wanting to take the telephone numbers in each cell and combine them into 1 based on the branch number. The closest thing I could figure out was to run a collect function based on the branch number but am getting an incorrect argument error. Anyone know a formula that would work for this?
=INDEX(COLLECT(WTN:WTN, [Branch Number]:[Branch Number] = "FL24"))
Help Article Resources
Check out the Formula Handbook template!