I love Palestine

I love Palestine

Sunday, 14 June 2026

FIFA 2026

Cannot entertain myself watching FIFA this year, considering there are more important things ahead. Anyway, I watch it at a glance while voting for my favorite player, the GOAT, Cristiano Ronaldo. Go... go... go... 


Monday, 6 April 2026

How to compare two column data in excell

To compare two columns in Microsoft Excel, here are the most useful methods depending on what you need:


🔹 1. Compare row-by-row (same position)

If Column A and Column B should match row-by-row:

=A1=B1

👉 Result:

  • TRUE → same value
  • FALSE → different

Or clearer:

=IF(A1=B1,"Match","Not Match")

🔹 2. Check if a value exists in the other column

If you want to know whether values in Column A appear anywhere in Column B:

=COUNTIF(B:B, A1)>0

👉 Returns:

  • TRUE → exists in Column B
  • FALSE → not found

🔹 3. Find missing values

To identify values in Column A that are NOT in Column B:

=IF(COUNTIF(B:B,A1)=0,"Missing","")

🔹 4. Highlight differences automatically

Use Conditional Formatting:

  1. Select Column A
  2. Go to Home → Conditional Formatting → New Rule
  3. Choose Use a formula
  4. Enter:

    =A1<>B1
  5. Pick a color

👉 This highlights cells that are different from Column B.


🔹 5. Advanced (Exact matching with lookup)

=IF(ISNA(MATCH(A1,B:B,0)),"Not Found","Found")

💡 Quick tip

  • Use row-by-row comparison → when both columns should align
  • Use COUNTIF / MATCH → when order doesn’t matter

If you want, you can paste your data format (or screenshot), and I’ll give you the exact formula tailored to your sheet 👍

Thursday, 26 March 2026

Selamat Hari Polis 2026

Selamat Hari Polis 2026 kepada keluarga, jurulatih dan rakan-rakan SUKSIS saya. Semoga sihat, selamat, sabar dan amanah dalam menjalankan tugas. 

Tidak dilupakan si Polis yang selalu menjaga kawasan kejiranan dan mengganggu gugat kucing-kucing saya. Dengan baju polisnya dia round-round kawasan rumah dan menjerkah 2 ekor kucing saya. Lain cerita dia tahan saya untuk parking di halaman rumah sendiri. Sangat-sangat over functional police officer. Tidak takut atau gentar kena hon pun. 

Si Polis is not our cat, nor anyone in the neighbourhood.  I think he is from far away but he is a handsome black cat with fluffy fur. Since he is so black and hardly be seen at night so my concerned neighbour buy him a reflective police jacket.  Since he started wearing it, he become the only officer at the block making him the mighty one who set his own rules. Congrats Polis, for your new appointed duty. Be kind okay.


On his guard

I sense dengerous

Baju berikat getah



All the neighbourhood is safe under my watch

Apa tengok-tengok. 


Tuesday, 24 March 2026

Pulangnya 7 Sekawan

 

Kredit kepada PHM fb
 

7 ekor anjing ni diculik dan dibawa jauh dari kampung mereka. Mereka kemudian berjaya meloloskan diri dan bersama-sama berjalan sejauh 17km untuk balik ke kampung asal mereka. Dalam perjalanan tu mereka sentiasa bersama dan menjaga satu sama lain. Hebatnya! Semoga kamu semua gembira bersama, disayangi dan dihargai oleh manusia. I always admire dogs, amazing, adorable,  pintar and indeed man best friend. Compare to the mighty cats 🤭🤭❤️🐶🦮🐕‍🦺🐕🐩🐾🐶

Related Posts Plugin for WordPress, Blogger...