How to create a serial number that shown on the results column in the attachment below by using formula? Thank you for advance who can help me
How to create a serial number that shown on the results column in the attachment below by using formula? Thank you for advance who can help me
Cell E2 formula , drag down
HTML Code:
Last edited by wk9128; 08-02-2021 at 10:03 PM.
Cell E2: =B2&D2&RANK($C$2:$C$7,C2)+COUNTIFS($B$2:$B$7,B2,$D$2:$D$7,D2,$C$2:$C$7,"<"&C2), copy down.
Thank you everyone
You're Welcome. Thank You for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks