Question: Is there any formula or VBA function to get the next value for each duplicate entry from Table-1 like in Table-2 for name "Saood" 2nd time value should be occured 51 and 3rd time should be 91 accordingly in table-2. Im using below formula in Column I , but it is not working properly...
