LinkBack URL
About LinkBacks
Grades A~D Must from left to right in order
There are Total 6 subjects , they are mathematics,geography,history,English,Chemistry,biological
Grades A~D Must from left to right in order
There are Total 6 subjects , they are mathematics,geography,history,English,Chemistry,biological
Last edited by rayhen; 09-12-2020 at 11:12 AM.
=if(countif(b2:g2,"a")=0,"",countif(b2:g2,"a")&"a")&if(countif(b2:g2,"b")=0,"",(countif(b2:g2,"b")&"b")&if(countif(b2:g2,"c")=0,"",countif(b2:g2,"c")&"c")&if(countif(b2:g2,"d")=0,"",countif(b2:g2,"d")&"d"))
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
First of all thank you alansidman , I just tested the formula you provided and found that I4 did not give an answer, and there was a blank, Everything else works
Cannot determine the issue. If I change one C to a B or A, then it works. All C's or All D's does not work. Will ask others to intercede and see if they can offer some assistance.
Okay, thank you for your kind help
In I2 and down:
Please Login or Register to view this content.
There was a stray ( in Alan's formula, it should be
=IF(COUNTIF(B2:G2,"a")=0,"",COUNTIF(B2:G2,"a")&"a")&IF(COUNTIF(B2:G2,"b")=0,"",COUNTIF(B2:G2,"b")&"b")&IF(COUNTIF(B2:G2,"c")=0,"",COUNTIF(B2:G2,"c")&"c")&IF(COUNTIF(B2:G2,"d")=0,"",COUNTIF(B2:G2,"d")&"d")
Hi,Originally Posted by alansidman
there was a problem with the parentheses....
=IF(COUNTIF(B2:G2,"a")=0,"",COUNTIF(B2:G2,"a")&"a")&IF(COUNTIF(B2:G2,"b")=0,"",COUNTIF(B2:G2,"b")&"b")&IF(COUNTIF(B2:G2,"c")=0,"",COUNTIF(B2:G2,"c")&"c")&IF(COUNTIF(B2:G2,"d")=0,"",COUNTIF(B2:G2,"d")&"d")
Great, I can already do it, thank you belinda200 and Fluff13 both for your kind help
Glad we could help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks