Index-vlookup?

[JTL9161]

I will just use a simple data to describe what I trying to do.

Column A has letters down A-Z (row 1-26)
Column B through U has numbers 1-20 across

I have used conditional formatting to find the lowest number in each column so I have 20 of the lowest numbers highlighted. Sometimes there are 2 or more of the same lowest number in a column,

What I trying to duplicate is the letter (name) in column A that coincides with the lowest number in each column.
Meaning if in column B the lowest number is a 5 and that is in row 7 and in row 16 I need to formula to show me that G and P had the lowest numbers in column B. For column C say the lowest of the 26 numbers is a 10 in row 18 then I need the formula to return a R.

So eventually I want a list of letters that all were the lowest number in each column. If every column had 1 lowest number I would get 20 letters (names) saying these were the lowest numbers.


Hope I explained this correctly for everyone to understand.
Thanks in advance for you help.

James

 

[AhoyNC]

Here are a couple formula ways depending on which ver. of Excel you have.
Both are array formulas that must be entered with CTRL-SHIFT-ENTER.

If you have Excel 2016 you can use the TEXTJOIN function. Drag this formula across columns.If you don't have the TEXTJOIN function then the formula in B12. Drag this formula down and across as needed. It will put the letters into separate cells.

Excel Workbook
	A	B	C	D
1	A	2	12	6
2	B	6	12	10
3	C	11	8	12
4	D	11	8	4
5	E	5	11	4
6	F	2	11	6
7	G	5	5	9
8	H	11	12	4
9	I	11	12	10
10		A, F	G	D, E, H
11
12		A	G	D
13		F		E
14				H
Sheet

 

[JTL9161]

Thanks. Looks like what I was looking for. I will give it a try.