Output numerical order base on another array

[Andinh0000]

Hi everyone, I'm not if this is even possible with excel but I have a columm with that contain Validation data and I need to count up the validation in numerical.

Here's a picture for better understanding: https://imgur.com/a/WZDdlaS

[#2]

@Andinh0000 Like this:

[#3]

@Riny_van_Eekelen 

Oh hey! Thank you for your help but I've made some mistake in the image, I need it to start from 0. So it goes from 0 to Nth order. I tried to make another columm just to reduce the index by 1 but it doesn't solve the final index. 

[#4]

@Andinh0000 The easiest would be to insert a row above the table and enter the number -1 in D1. Hide the row is desired. Only a slight adjustment to the formula is needed.