Dynamic Table Update by column value

[Shayanan]

Column A is return of formula. Column B is Alphabetically sort number of Column A.
I need a Dynamic table that in Table Column1, put sort numbers from 1 to how much is that from column B. and if Column b Updated, it update too.

Options-2021-v11.xlsm
	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2											Column B	Column A
3											16	Apple Inc.
4			Column3	Column2	Column 1						20	Atlas Air Worldwi...
5				Aaron's, Inc.	1						12	Allianceberstein ...
6				ABB Ltd	2						17	Applied Optoelect...
7				AbbVie Inc.	3						19	Artius Acquisitio...
8				AbCellera Biologi...	4						18	Ares Acquisition ...
9				ABG Acquisition C...	5						9	Agilent Technolog...
10				ABIOMED, Inc.	6						0
11				ABM Industries In...	7						11	Alcoa Inc.
12				Advance Auto Part...	8						13	American Airlines...
13				Agilent Technolog...	9						1	Aaron's, Inc.
14				Alcoa Inc.	11						0
15				Allianceberstein ...	12						8	Advance Auto Part...
16				American Airlines...	13						0
17				Ameris Bancorp	14						2	ABB Ltd
18				AmerisourceBergen...	15						0
19				Apple Inc.	16						0
20				Applied Optoelect...	17						0
21				Ares Acquisition ...	18						3	AbbVie Inc.
22				Artius Acquisitio...	19						15	AmerisourceBergen...
23				Atlas Air Worldwi...	20						14	Ameris Bancorp
24											4	AbCellera Biologi...
25											0
26											5	ABG Acquisition C...
27											7	ABM Industries In...
28											0
29											0
30											6	ABIOMED, Inc.
31											0
32											0
33											0
34											10	Airbnb, Inc.
35
Sheet8

Cell Formulas
Range	Formula
S3:S34	S3	=COUNTIF($T$3:$T$2000,"<="&T3)

 

[mohadin]

O5=IFERROR(INDEX($S$3:$S$34,MATCH($N5,$T$3:$T$2000,0)),"")

 

[maabadi]

Try this:

Book1
	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2											Column B	Column A
3											16	Apple Inc.
4			Column3	Column2	Column 1						20	Atlas Air Worldwi...
5				Aaron's, Inc.	1						12	Allianceberstein ...
6				ABB Ltd	2						17	Applied Optoelect...
7				AbbVie Inc.	3						19	Artius Acquisitio...
8				AbCellera Biologi...	4						18	Ares Acquisition ...
9				ABG Acquisition C...	5						9	Agilent Technolog...
10				ABIOMED, Inc.	6						0
11				ABM Industries In...	7						11	Alcoa Inc.
12				Advance Auto Part...	8						13	American Airlines...
13				Agilent Technolog...	9						1	Aaron's, Inc.
14				Airbnb, Inc.	10						0
15				Alcoa Inc.	11						8	Advance Auto Part...
16				Allianceberstein ...	12						0
17				American Airlines...	13						2	ABB Ltd
18				Ameris Bancorp	14						0
19				AmerisourceBergen...	15						0
20				Apple Inc.	16						0
21				Applied Optoelect...	17						3	AbbVie Inc.
22				Ares Acquisition ...	18						15	AmerisourceBergen...
23				Artius Acquisitio...	19						14	Ameris Bancorp
24											4	AbCellera Biologi...
25											0
26											5	ABG Acquisition C...
27											7	ABM Industries In...
28											0
29											0
30											6	ABIOMED, Inc.
31											0
32											0
33											0
34											10	Airbnb, Inc.
35
Sheet3

Cell Formulas
Range	Formula
L5:L23	L5	=VLOOKUP(M5,$S$3:$T$2000,2,FALSE)
M5	M5	=MINIFS($S$3:$S$2000,$S$3:$S$2000,">" & 0)
M6:M23	M6	=MINIFS($S$3:$S$2000,$S$3:$S$2000,">" & M5)
S3:S34	S3	=COUNTIF($T$3:$T$2000,"<="&T3)

 

[Fluff]

Another option

+Fluff 1.xlsm
	I	J	K	L	M	N	O	P	Q	R	S	T
1
2											Column B	Column A
3											16	Apple Inc.
4			Column3	Column2	Column 1						20	Atlas Air Worldwi...
5				Aaron's, Inc.	1						12	Allianceberstein ...
6				123	1						17	Applied Optoelect...
7				ABB Ltd	2						19	Artius Acquisitio...
8				AbbVie Inc.	3						18	Ares Acquisition ...
9				AbCellera Biologi...	4						9	Agilent Technolog...
10				ABG Acquisition C...	5						0
11				ABIOMED, Inc.	6						11	Alcoa Inc.
12				ABM Industries In...	7						13	American Airlines...
13				Advance Auto Part...	8						1	Aaron's, Inc.
14				Agilent Technolog...	9						0
15				Airbnb, Inc.	10						8	Advance Auto Part...
16				Alcoa Inc.	11						0
17				Allianceberstein ...	12						2	ABB Ltd
18				American Airlines...	13						0
19				Ameris Bancorp	14						0
20				AmerisourceBergen...	15						0
21				Apple Inc.	16						3	AbbVie Inc.
22				Applied Optoelect...	17						15	AmerisourceBergen...
23				Ares Acquisition ...	18						14	Ameris Bancorp
24											4	AbCellera Biologi...
25											0
26											5	ABG Acquisition C...
27											7	ABM Industries In...
28											0
29											0
30											6	ABIOMED, Inc.
31											0
32											1	123
33											0
34											10	Airbnb, Inc.
Master

Cell Formulas
Range	Formula
L5:L23	L5	=INDEX($T$3:$T$2000,AGGREGATE(15,6,(ROW($T$3:$T$2000)-ROW($T$3)+1)/($S$3:$S$2000=M5),COUNTIFS(M$5:M5,M5)))
M5:M23	M5	=AGGREGATE(15,6,$S$3:$S$2000/($S$3:$S$2000>0),ROWS(M$5:M5))
S3:S34	S3	=COUNTIF($T$3:$T$2000,"<="&T3)