nostradamus
Board Regular
- Joined
- Aug 9, 2010
- Messages
- 143
- Office Version
- 365
- Platform
- Windows
Dear Formula Wizs,
I have a big spreadsheet with about 100 rows and close to 300 columns, below is just a subsection of the whole data.
1) So, I would like to for the formula in Cell B19 to reflect the Column that has the most number of data entries from Cols B-K.
2) Col B20 would reflect the Column that has next most number of data that is potentially missing from the First Pick..
3) Col B21 reflects Column with data missing from First and Second Picks.
4) ... etc...
Your help would be much appreciated
I have a big spreadsheet with about 100 rows and close to 300 columns, below is just a subsection of the whole data.
1) So, I would like to for the formula in Cell B19 to reflect the Column that has the most number of data entries from Cols B-K.
2) Col B20 would reflect the Column that has next most number of data that is potentially missing from the First Pick..
3) Col B21 reflects Column with data missing from First and Second Picks.
4) ... etc...
Your help would be much appreciated
excelformula.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | County | Det-1 | Det-2 | Det-3 | Det-4 | Det-5 | Det-6 | Det-7 | Det-8 | Det-9 | Det-10 | |||
2 | Maverick County | 2 | 1 | 3 | 5 | 3 | ||||||||
3 | Jim Hogg County | 1 | 6 | 31 | ||||||||||
4 | Zavala County | 55 | 23 | 8 | 6 | 6 | ||||||||
5 | Dallas County | 2 | 15 | |||||||||||
6 | Liberty County | 3 | 43 | |||||||||||
7 | Callahan County | 8 | 5 | 5 | 3 | |||||||||
8 | Cooke County | 3 | 5 | |||||||||||
9 | Randall County | 3 | 1 | 6 | ||||||||||
10 | Hockley County | 5 | 9 | |||||||||||
11 | Aransas County | 41 | 31 | 1 | 11 | |||||||||
12 | Hardeman County | 6 | 35 | |||||||||||
13 | Brazos County | 2 | 3 | 6 | ||||||||||
14 | Collin County | 21 | 9 | |||||||||||
15 | Bell County | 3 | 11 | 5 | ||||||||||
16 | Fayette County | 2 | 21 | |||||||||||
17 | Atascosa County | 1 | 6 | 11 | ||||||||||
18 | ||||||||||||||
19 | First Pick | Det-8 | ||||||||||||
20 | 2nd Pick (missing info from First Pick) | |||||||||||||
21 | 3rd Pick (missing info from 1st & 2nd Pick) | |||||||||||||
22 | 4th Pick (missing info from 1st & 3rd Pick) | |||||||||||||
23 | 5th Pick (missing info from 1st - 4th Pick) | |||||||||||||
24 | 6th Pick (missing info from 1st -5th Pick) | |||||||||||||
25 | 7th Pick (missing info from 1st - 6th Pick) | |||||||||||||
26 | 8th Pick (missing info from 1st - 7th Pick) | |||||||||||||
27 | ||||||||||||||
Sheet1 |