when the data is very huge and iF you want to find mathicng values and also identify which cell it is matching use this formula: =IFERROR("B is Present in A" & MATCH(B2, A:A, 0), "B is Absent in A")
Hello can I have the exact formula in this function? The video is very low quality. I can't see clearly the formula you put in conditional formatting.🥲
The only video that helped me resolve this. Thank you!
Welcome 🤗
I was searching so hard for this, Thank You
Super ❤. I used it now
Thanks mate help me a lot. From Indonesia🎉🎉😊
Welcome 😊
Absolutely the video is Awesome thanks ..
Welcome 🤗
Thank you sir. Saved a lot of work.
Welcome plz support us
Your are the best, straight multiple highlights
Thank you
thank you for this video, really helps my reports thousands data, btw, i am operation data supervisor
Welcome 🤗 plz Share this video and help others
Working, Great..Have to follow each and every step closely
Thanks man
Just what I needed. 🎉
Subscribe please ☺
thank u sir
Welcome
Holy shit spent hours trying to find a solution thanks
Welcome
Great video, the only one that helps. what if I have three or more column?
Its work for me thank you 😊
Welcome
Can you make it so the names that do not have a match are blank and if on the same excel page, how do you get them to fall on the same line?
Thanx this vidio
for some reason this is highlighting the unique cells and leaving all duplicate cells un-highlighted... what am i missing or doing wrong?
Great. Working. Now Plz suggest me how to delete them also
Filter them by color then delete them
How can I do the same with numbers?
Thank you sir
Welcome ☺
sir how to highlight numbers of column B with reference of numbers of column A witch are greater than 5.
when the data is very huge and iF you want to find mathicng values and also identify which cell it is matching use this formula: =IFERROR("B is Present in A" & MATCH(B2, A:A, 0), "B is Absent in A")
worthit
Thankyou
Ur most welcome 🤗
Wow thanks, how to delete that coloured cell, only left with right one, with one click or with fast ?
You can use clear format
@@HarryViral i mean i want to delete the number but i want to left with colour cell so i can track which one i delete, can i do it fast too ?
I do the exact same thing but it doesnt work?
Hi! Could someone please help me? I tried to do the same thing, shown in the video with numbers, but simply it doesn't work.
You can watch once more in slow speed
Thanks :*
Welcome
Can u give me tutorial. How To Delete the yellow Cell??
= ke baad kya likha hai kuch dikh ni raha hai
=countif()
Music name please?
I forgot bro u can use one app that gives the whole info about the music
Video not clear
Plz watch latest video with clear video I have made of this
Its not work.
Formula not clear
Nothing is visible and understanble
Thik se dikh nahi raha hai kitna faded hai
Not clear
Faltu
Great
Hello can I have the exact formula in this function? The video is very low quality. I can't see clearly the formula you put in conditional formatting.🥲
Sure. I. Will be making one more high video asap .
Thanks sir
Welcome ☺️