Forum Discussion
Solved
show the 2nd data with same value
Hi, I need to found a way that will look the columns where the number of time appear and show the name of that EFC. most of the time, we can have the same number for different EFC code and I need to ...
Please refer to the attached with a workaround in case you don't have access to the TEXTJOIN function.
Formula always returns the value for first found largest number, i.e. 1C01. To return all of them it's bit another technique with regular formulas, but that better to demonstrate on the sample file. Or, if you are on modern Excel, use FILTER() function.