Ranking based on earliest data input

[ExcelNewbie2020]

Experts,

Please see table below;

	Value	Rank
Name 1	10	5
Name 2
Name 3	200	1
Name 4
Name 5
Name 6
Name 7	1000	2
Name 8
Name 9
Name 10	500	3

Is there any excel function that will rank the values based on the first data inputted?
on the above table rank # 1 goes to Name3 because i inputted the value 200 1st, rank #2 is Name7 because i inputted 1000 2nd and so on..

I am looking for a function that once i input a value, the rank/sequence will update automatically. Thank you very much..

 

[ExcelNewbie2020]

This is Example:

TEST.xlsx
	A	B	C	D	E
1	Names	Value	InPut Time	Rank
2	Nam1	10	1/31/2021 16:13	1
3	Nam2
4	Nam3	800	1/31/2021 16:15	5
5	Nam4
6	Nam5
7	Nam6	600	1/31/2021 16:15	4
8	Nam7
9	Nam8	1000	1/31/2021 16:14	3
10	Nam9
11	Nam10	200	1/31/2021 16:13	2
12
Sheet1

Cell Formulas
Range	Formula
C2:C11	C2	=IF(AND(A2<>"",B2<>""),IF(C2="",NOW(),C2),"")
D2:D11	D2	=IFERROR(RANK.AVG(C2,$C$2:$C$11,1),"")

this work as expected thru excel formula.. thank you very much sir..

 

[maabadi]

You're Welcome & Thanks for Feedback.