Suri's site.
I love Palestine
Sunday, 14 June 2026
FIFA 2026
Friday, 17 April 2026
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:
- Select Column A
- Go to Home → Conditional Formatting → New Rule
- Choose Use a formula
-
Enter:
=A1<>B1 - 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 👍
Friday, 27 March 2026
Chinese Chicken Patty
Credit to foodiechina888 fb
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.
Tuesday, 24 March 2026
Pulangnya 7 Sekawan
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 🤭🤭❤️🐶🦮🐕🦺🐕🐩🐾🐶








