Combination

Hi, My name Hisham from Malaysia.
I need a support from all of you how to create a formula to combine all data from 1 row ?
Here I attach an attachment.
Sorry, my data is under Malay language.



to.png

Hi Hisham, want to ask you what the logic behind it? Why C twice, A once and 3 twice?

regards

Hi Azumi,

C twice because the result for student get in exam is a below 59% and will display : C
A mean ; student must archive 80% and above
B mean ; student archive 79% - 60%
C mean ; student archive 59% - 40%
D mean ; student archive 39% - 20%
E mean ; student archive <20%

You can formulate that using COUNTIFs and the &.

Something like...

Formula:

= COUNTIF(A3:J3,"A") & "A," & COUNTIF(A3:J3,"B") & "B, and " & COUNTIF(A3:J3,"C") & "C" 

Hi all,

Here I attach with a details.
I already follow a formula but still not changing at "KEPUTUSAN".

Please refer attachment.

Thank you with all of you GREAT SUPPORT !

Hi Quekbc...

I already follow your formula...
Can you check first ?
Maybe I missing some text ?

= COUNTIF(E8:M8,"A") & "A," & COUNTIF(E8:M8,"B") & "B," & COUNTIF(E8:M8,"C") & "C," & COUNTIF(E8:M8,"D") & "D, and " & COUNTIF(E8:M8,"E") & "E"

Hi Crooza,

Can you attach your sample here ?
I'm still error....

Hi Crooza,

Can you attach your sample here ?
I'm still error....

Hi Hishamullah, I think it'll be better for you to attach a small sample of your file here. The formula should and does work.
But it looks like there might be something on your file that we cannot account for without us seeing it.

Hi Quekbc,

Here I attach my file.
Can you help me ?
Thanks a lot with your support !

Hi Hishamullah, the formula does work, to a degree. I see what you mean now. You don't want the 0s to be shown. For that, I've resorted to something more complicated.

Formula:

=IF(COUNTIF(E9:M9,"A")=0,"",COUNTIF(E9:M9,"A") & "A" & IF(COUNTIF(E9:M9,">A")=1, ", & ", IF(COUNTIF(E9:M9,">A")>1,", ", "")))

&IF(COUNTIF(E9:M9,"B")=0,"",COUNTIF(E9:M9,"B") & "B" & IF(COUNTIF(E9:M9,">B")=1, ", & ", IF(COUNTIF(E9:M9,">B")>1,", ", "")))

&IF(COUNTIF(E9:M9,"C")=0,"",COUNTIF(E9:M9,"C") & "C" & IF(COUNTIF(E9:M9,">C")=1, ", & ", IF(COUNTIF(E9:M9,">C")>1,", ", "")))

&IF(COUNTIF(E9:M9,"D")=0,"",COUNTIF(E9:M9,"D") & "D" & IF(COUNTIF(E9:M9,">D")=1, ", & ", IF(COUNTIF(E9:M9,">D")>1,", ", "")))

&IF(COUNTIF(E9:M9,"E")=0,"",COUNTIF(E9:M9,"E") & "E")

Please see attached.

Hi Quekbc,

Good morning !

Wow !!... Thanks a lot with your support.... :-)
Now, the formula is does work to me.
Yes, I want just to display the result only such as : How many "A", "B", "C", "D" or "E"...
This is for our school for Result in UPSR (Ujian Penilaian Sekolah Rendah ; Primary School Trial).

Thanks a lot with your support !!