Find Minimum number

Rock5150

Board Regular
Joined
Nov 16, 2012
Messages
92
Office Version
  1. 365
Platform
  1. Windows
I have the attached spreadsheet where i would like to list the minimum number and its corresponding pair person starting with the vertical down name first, then the horizontal axis name second and the value third so for example somewhere below the data i would list in order from least to most (value) John Doe Jane Doe 131 in column A thru C. I expect my spreadsheet to have lots of rows and columns and instead of scanning each cell i would like it all listed below. This is building off a spreadsheet this forum helped me build earlier this year which is fantastic. I am having to spend time scanning each cell to find the minimum number and going forward i just want the values listed below as another data point

Archuleta MichaelBolden AnthonyBrister AntonioCarter MelvinDavis Harold
Archuleta Michael#N/A143129136140
Bolden Anthony121#N/A134135162
Brister Antonio120119#N/A172142
Carter Melvin154153161#N/A188
Davis Harold131157136153#N/A
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
How about
+Fluff 1.xlsm
ABCDEFGHIJKL
1Archuleta MichaelBolden AnthonyBrister AntonioCarter MelvinDavis Harold
2Archuleta Michael#N/A143129136140Brister AntonioBolden Anthony119
3Bolden Anthony121#N/A134135162Brister AntonioArchuleta Michael120
4Brister Antonio120119#N/A172142Bolden AnthonyArchuleta Michael121
5Carter Melvin154153161#N/A188Archuleta MichaelBrister Antonio129
6Davis Harold131157136153#N/ADavis HaroldArchuleta Michael131
7Bolden AnthonyBrister Antonio134
8Bolden AnthonyCarter Melvin135
9Davis HaroldBrister Antonio136
10Archuleta MichaelCarter Melvin136
11Archuleta MichaelDavis Harold140
12Brister AntonioDavis Harold142
13Archuleta MichaelBolden Anthony143
14Carter MelvinBolden Anthony153
15Davis HaroldCarter Melvin153
16Carter MelvinArchuleta Michael154
17Davis HaroldBolden Anthony157
18Carter MelvinBrister Antonio161
19Bolden AnthonyDavis Harold162
20Brister AntonioCarter Melvin172
21Carter MelvinDavis Harold188
Main
Cell Formulas
RangeFormula
J2:L21J2=LET(Rng,B2:F6,r,ROWS(Rng),s,SEQUENCE(r*COLUMNS(Rng),,0),c,CHOOSE({1,2,3},INDEX(A2:A6,MOD(s,r)+1),INDEX(B1:F1,INT(s/r)+1),INDEX(Rng,MOD(s,r)+1,INT(s/r)+1)),SORT(FILTER(c,ISNUMBER(INDEX(c,,3))),3))
Dynamic array formulas.
 
Upvote 0
Solution

Forum statistics

Threads
1,215,217
Messages
6,123,675
Members
449,116
Latest member
HypnoFant

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top