Excel排名与SQL排名

我有以下困境。

我需要rank在Excel中进行数据处理，就像在SQL中对数据进行排名一样，如下所示：

declare @table table
(id int identity primary key , batchid int)

insert into @table (batchid) select 10
insert into @table (batchid) select 35
insert into @table (batchid) select 35
insert into @table (batchid) select 35
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 11
insert into @table (batchid) select 4
insert into @table (batchid) select 10
insert into @table (batchid) select 11
insert into @table (batchid) select 4
insert into @table (batchid) select 21
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 4
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 21
insert into @table (batchid) select 11
insert into @table (batchid) select 21
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 21

select
batchid
,   rank() over (partition by batchid order by id)  [RANK]
from    @table

我看了很多的YouTube视频，以及如何的教程rank在Excel中，但我没有看到选项，partition by即rank如在上面的代码中可以看出。

请参阅上述脚本的以下结果：

我可以在Excel中使用什么公式来获得相同的结果？