Hi Excel Gurus,
Need help how to get expected value (ex. Ross), where entered value = 123.
Logic is when I enter serial value = 123, it will get the name based from highest value (Repeat Serial) which is 5.
Hope you can help me out and thanks in advance.
Need help how to get expected value (ex. Ross), where entered value = 123.
Logic is when I enter serial value = 123, it will get the name based from highest value (Repeat Serial) which is 5.
Hope you can help me out and thanks in advance.