Forum Discussion
Output numerical order base on another array
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
3 Replies
Andinh0000 Like this:
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.
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.
