Excel formula suitable for this project

[badang_laut]

[TABLE="width: 1256"]
<tbody>[TR]
[TD]NAMES[/TD]
[TD]ID[/TD]
[TD]DAYS[/TD]
[TD]TYPE[/TD]
[TD]REPORT 1[/TD]
[TD]REPORT 2[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]ABU (PANEL-2, SWASTA-4, TOTAL-5)[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[/TR]
[TR]
[TD]Ali[/TD]
[TD]125027[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]ALI (PANEL-1)[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mamat[/TD]
[TD]035579[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mamat[/TD]
[TD]035579[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mamat[/TD]
[TD]035579[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tariq[/TD]
[TD]086375[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Devi[/TD]
[TD]075404[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jaafar[/TD]
[TD]016286[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Wahid[/TD]
[TD]015743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamid[/TD]
[TD]035095[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamid[/TD]
[TD]035095[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamid[/TD]
[TD]035095[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rahim[/TD]
[TD]035119[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Kassim[/TD]
[TD]025542[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]075286[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]075286[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Insurans[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]115181[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]3[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hello,

I am asking for help on this project.

Need to do report 1 and 2.

eg. Abu, ID 085292

RESULT 1 = ABU (PANEL-2, SWASTA-4, TOTAL-5)

RESULT 2 = 6

What is the best formula for me to get result as above?

Thanks in advance for the help.

 

[Special-K99]

1. How do you get ABU PANEL -2 ?
And how do you get a TOTAL of 5 from PANEL-2 and SWASTA-4 ?

ABU PANEL is only 1, in whcih case the TOTAL is correct.

Have you read the figures wrong and included Ali's entry ?


2. Are you only searching for the last word in the 4th column?
Are you only searching for PANEL and SWASTA and KERAJAAN and INSURAS
Or are there other words to search for that are not listed here?

3. Does the report have to be in that format or can it be pretty much any format as long as the figures are correct?

 

[badang_laut]

1. How do you get ABU PANEL -2 ?
And how do you get a TOTAL of 5 from PANEL-2 and SWASTA-4 ?

ABU PANEL is only 1, in whcih case the TOTAL is correct.

Have you read the figures wrong and included Ali's entry ?


2. Are you only searching for the last word in the 4th column?
Are you only searching for PANEL and SWASTA and KERAJAAN and INSURAS
Or are there other words to search for that are not listed here?

3. Does the report have to be in that format or can it be pretty much any format as long as the figures are correct?

1. Sorry, the TOTAL is 6 not 5 (PANEL : 2 DAYS + SWASTA : 4 DAYS) for NAMES : ABU)

For NAMES : ALI only 1 names and only got PANEL : 1 DAYS)


2. First i want searching for NAMES (1st column) after thats TYPE (4th column)

3. Report as long i get how much TYPE and TOTAL for each NAMES.

Thanks in advance

 

[Special-K99]

We'll try this one again

2. Are you only searching for PANEL and SWASTA and KERAJAAN and INSURAS
Or are there other words to search for that are not listed here?

If you have a set list of words to search for Pivot Table would be the way to go

 

[badang_laut]

We'll try this one again

2. Are you only searching for PANEL and SWASTA and KERAJAAN and INSURAS
Or are there other words to search for that are not listed here?

If you have a set list of words to search for Pivot Table would be the way to go

Yes only searching for PANEL, SWASTA, KERAJAAN and INSURANS...

So what i do is using Pivot Table only rite?

 

[Special-K99]

Pivot Table is one option.
I'm not an expert on Pivot Table

You should be able to count the number of TYPES by NAME easy.
You might be able to create a new calculated field to search the TYPE for each word PANEL SWASTA KERAJAAN INSURANS and split the report further by sorting on that field (am not sure this is possible you'll have to play around with Pivot Table to see what you can produce).

Or create a Helper column

in E2
=IF(ISNUMBER(SEARCH("PANEL",D2)),"PANEL",IF(ISNUMBER(SEARCH("SWASTA",D2)),"SWASTA",IF(ISNUMBER(SEARCH("KERAJAAN",D2)),"KERAJAAN",IF(ISNUMBER(SEARCH("INSURANS",D2)),"INSURANS","NONE FOUND"))))
and copy down

Then do a Pivot Table counting by NAME by TYPE by Column E

 

[badang_laut]

https://www.excel-university.com/return-the-sum-of-two-or-more-columns-with-vlookup/

Can i use this formula?

=SUMPRODUCT(VLOOKUP(C6,B12:F18,{3,4,5},0))

 

[badang_laut]

Pivot Table is one option.
I'm not an expert on Pivot Table

You should be able to count the number of TYPES by NAME easy.
You might be able to create a new calculated field to search the TYPE for each word PANEL SWASTA KERAJAAN INSURANS and split the report further by sorting on that field (am not sure this is possible you'll have to play around with Pivot Table to see what you can produce).

Or create a Helper column

in E2
=IF(ISNUMBER(SEARCH("PANEL",D2)),"PANEL",IF(ISNUMBER(SEARCH("SWASTA",D2)),"SWASTA",IF(ISNUMBER(SEARCH("KERAJAAN",D2)),"KERAJAAN",IF(ISNUMBER(SEARCH("INSURANS",D2)),"INSURANS","NONE FOUND"))))
and copy down

Then do a Pivot Table counting by NAME by TYPE by Column E

I have try your formula but did not get the RESULT i want.

 

[badang_laut]

I get like this

https://imageshack.com/a/img924/7764/xI7RW9.png

 

[badang_laut]

[TABLE="width: 1513"]
<colgroup><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]NAMES[/TD]
[TD]ID[/TD]
[TD]DAYS[/TD]
[TD]TYPE 1[/TD]
[TD]TYPE 2[/TD]
[TD]REPORT 1[/TD]
[TD]REPORT 2[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD]ABU (PANEL-2, SWASTA-4, TOTAL-6)[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[TD]SWASTA[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[TD]SWASTA[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[TD]SWASTA[/TD]
[/TR]
[TR]
[TD]Abu[/TD]
[TD]085292[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[TD]SWASTA[/TD]
[/TR]
[TR]
[TD]Ali[/TD]
[TD]125027[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD]ALI (PANEL-1)[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD]SULAIMAN (PANEL-5, TOTAL-5)[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[/TR]
[TR]
[TD]Sulaiman[/TD]
[TD]085743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[/TR]
[TR]
[TD]Mamat[/TD]
[TD]035579[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD]MAMAT (PANEL-3, TOTAL-3)[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Mamat[/TD]
[TD]035579[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[/TR]
[TR]
[TD]Mamat[/TD]
[TD]035579[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[/TR]
[TR]
[TD]Tariq[/TD]
[TD]086375[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Devi[/TD]
[TD]075404[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Jaafar[/TD]
[TD]016286[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD]KERAJAAN[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Wahid[/TD]
[TD]015743[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Hamid[/TD]
[TD]035095[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Hamid[/TD]
[TD]035095[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Hamid[/TD]
[TD]035095[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Rahim[/TD]
[TD]035119[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD]KERAJAAN[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Kassim[/TD]
[TD]025542[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]075286[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Swasta[/TD]
[TD]SWASTA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Eric[/TD]
[TD]075286[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Insurans[/TD]
[TD]INSURANS[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]115181[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD]KERAJAAN[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]3[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD]KERAJAAN[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD]KERAJAAN[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD]KERAJAAN[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Kerajaan[/TD]
[TD]KERAJAAN[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]2[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Arumalai[/TD]
[TD]085192[/TD]
[TD]1[/TD]
[TD]Cuti Sakit Panel[/TD]
[TD]PANEL[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]