I have 3 subjects
MATH - Start with 9
SCIENCE - Start with 11
ENGLISH - Start with 5
on formula when the value is math it will start the counting into 9. I upload image for the expected result. Thank you so much in advance.
Expected Result.PNG
I have 3 subjects
MATH - Start with 9
SCIENCE - Start with 11
ENGLISH - Start with 5
on formula when the value is math it will start the counting into 9. I upload image for the expected result. Thank you so much in advance.
Expected Result.PNG
Last edited by jasond1992; 05-10-2021 at 10:52 AM.
How aboutFormula:Please Login or Register to view this content.
Create "LOOKUP" table as in E2:F4
MATH 9
SCIENCE 11
ENGLISH 5
in B2
=IF(COUNTIF($A$2:$A2,$A2)=1,VLOOKUP($A2,$E$2:$F$4,2,FALSE),$B1+1)
OR
=IF(COUNTIF($A$2:$A2,$A2)=1,LOOKUP($A2,{"ENGLISH","MATH","SCIENCE"},{5,9,11}),$B1+1)
Last edited by JohnTopley; 05-10-2021 at 10:56 AM.
Thank you so much po for the 2 Suggestions. It works.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks