Search box in Excel│create a search box in excel with condition formatting│Excel search box in HINDI

[@biprojitpoddar2333]

Very nice description. Very good .

[@imransumdani3760]

Nice topic n good class
IMRAN SUMDANI from Pakistan

[@ankhabanschatar5443]

REALLY VERY GOOD BRO,PERFECT FOR MY WORK.THANK YOU SO MUCH.KEEP CONTINUE MAKING THIS VIDEOS

[@ComTutor]

thanks.

[@anilkumarsingh4560]

Super Hit video sir

[@ComTutor]

thanks.

[@manojparmar7410]

very usefull thanks

[@ComTutor]

Thanks bro ☺️

[@santosh3919]

very very nice sir...isse pehle bhi ek vid me is topic ka vid dekhe par samjh nahi aaya...aapke vid me bahut hi achche se samjh aaya...aap vif me arror mark dekar jo sikhaye, usse sikhna asan ho gaya...aap isi tarah excel learn vid banaye...thank you lot...

[@ComTutor]

thanks bro. keep learning with us.

[@santosh3919]

sir aapka mail id milega?? ek question hai ?

[@poulomidevroy6265]

Very useful... i love all your videos. Thanks a lot sir.

[@ComTutor]

thank you once again.

[@sushilbalakrishnan]

thank a lot, i viewed quite a few vedios, I found your easy to understand .

[@ComTutor]

thanks so please subscribe to more lessons.

[@navneetthakral982]

Awesome ,very useful

[@habeebmohammad8237]

good video good use of grafic please keep it up
thousends of people will be benefit from your video
may God bless you

[@ComTutor]

thanks for comment and appreciating me.
keep watching and learning with me.

[@Testing_QualityAnalyst_Channel]

Very useful video

[@ComTutor]

thanks.

[@AzizurRahman-hj3mm]

Awesome bro,!!!, ... Thanx 4 sharing..

[@ComTutor]

thanks

[@kunalkumar-ij9gd]

most powerful video

[@ComTutor]

thanks kunal.
please watch our more video in our playlist section.

[@mi-tra3907]

sir ese hi interesting vedios upload kartey rahiye. thanks.......T.K.

[@ComTutor]

thanks.

[@Mitali_panchal]

Really usefull thank u

[@sikandarbhojani23]

Really very nice video for excel learning

[@ComTutor]

thanks.

[@sandeepgoud7595]

Thank you sir .... I'm gonna use this ..... it's so helpful for me..

[@ComTutor]

thanks. for comment.

[@anujrao6531]

Wow! Amazing trick

[@ComTutor]

thanks.

[@krishnagroupgzp2641]

Sir maine ap se hi sikha or search box banaya hai...
Jisme maine only 1st, and 2nd, cell ki value ko hi liya hai
50000 people ko search karne me asani hai.
(krishna group gzp)😊my channel

[@fasttrackcomputer8839]

Thank you very much

[@maira36]

bhut clear process se aapne samjaya hai i like video sir thoda photo id ke sath form banana chahte hai app thoda video banaye

[@ComTutor]

thanks for the comment Rehan, aap please apna concern mail mei likh ke do. aur aap konsa form banana chahte ho uski details ki sheet attache ker dena.
Email : [e-mail]

[@jyotiupadhyay6492]

Very good
Easy to understand
I want to ask is it possible to display only search results row ???

[@ComTutor]

no logically not. but once you done your search through search box, then apply filter and choose color filter which is color. then automatically colored row will come on top of your sheet.

[@kishnatanti3653]

very nice video

[@ComTutor]

your welcome kishna

[@mobinpawasker5799]

Very good. Great tutorial. How to filter the highlighted rows

[@ComTutor]

thanks.

[@nitinraj4865]

Sir this video is more interesting & more useful for us but sir please make a video on how to apply hyperlink in more file.

[@ComTutor]

okay i'll teach hyperlink soon.

[@abhijitdas7198]

Thanks sir.

[@markarvin7725]

This is nothing but perfection at its best. Just what I have been looking for. Thank you!

[@komaltank6421]

Thanks very nyc nice way I will try

[@ComTutor]

okay,

[@ComTutor]

okay,

[@chandra2982]

Sir this video is v good but I required item will be colour though conditional formatting & data automatically filter. Though searchable box. Please help.

[@SIMRANKAUR-eg7nc]

Better record a macro for filtering by colour and after putting the search string apply thay macro button.

[@SIMRANKAUR-eg7nc]

This video is beautifully explained. However If u want to understand of logic behind setting the column reference to absolute or relative to highlight the row or column watch this highly interactive video.
ruclips.net/video/Gp3b8y_pO8I/видео.html

[@chetanchauhan5823]

GOOD JOB SIR

[@ComTutor]

thanks,
please subscribe with bell icon to get latest videos from this.

[@theultimatecabinet]

Subscribed 👍👍👍👍

[@ComTutor]

thanks.

[@RahulKumar-ly6ly]

Thanks sir

[@junaidshaikh4880]

Thank you very much for making such a wonderful & educational video. Its will be very helpful to me but my problem is that k I have to alter my data frequently and it increase daily, so please let me know that how can I apply the mentioned formula in my excel sheet where I have to fill the new cells daily in columns & rows. Thanks again.

[@ComTutor]

take all column in search box where you will put data on daily basis.
and create formula only one time then this will work on all data.

[@Abhi_Thefitbanker]

Thanks sir... Mai aapki sari video dekhta hoon.. ye video mujhe bahot achhi lagi.. nayi chhij sikhne ko mila.. Sir, search ki hui row highlight to ho ja rahi h kya isse filtter ki ja sakti h.? Any idea plz share.. Thanks...

[@ComTutor]

ji haan jab aapki row highlight ho jati hai phir uss par filter lagao, and filter open karke usme filter by color choose kar lo. aur green color choose karke enterr kar do. ho jayega filter.

[@SANJAYGAUR81]

Badiya hai

[@ComTutor]

thanks.

[@rayappanyadav5831]

Best

[@ComTutor]

thanks.

[@zikrifadilah07]

Thanks bro, im in Indonesia

[@ComTutor]

thanks and your welcome, from India.

[@aliasgerburhanpurwala5850]

sar bhat accha hi me aj hi tare karta hu

[@ComTutor]

okay please, try...

[@harpalrana2832]

very mast

[@SufiyanShaikh007]

Thanks

[@alokbhatt4053]

thanks sir i like it

[@ComTutor]

your welcome.

[@ramdeepkumar7616]

Excellent

[@ComTutor]

thanks

[@mohammedsaqib8483]

This look cool but its only highlighting the cell. Can we create search box in such a way that it gives result by filtering the data without using developer option ?
Thanks

[@ComTutor]

ohh thanks for the comment i'll check for your query.

[@nayacterajeev]

Nice

[@ComTutor]

thanks

[@ppperiwal]

Good sir
Agar search alag alag krna ho wo bhi ek sheet me.
Im am working in my stock sheet.
This is one sheet.
Row - ABCD (is stock in)
Row- EFGH ( STOCK OUT)

[@South_Hindhi_Dubbed_Movies2024]

Nice work sir ji

[@ComTutor]

thanks.

[@acharyabasanta]

very nice

[@ComTutor]

your welcome

[@anandtech2291]

Thank you so much sir..
I have a query..
Can we filter the highlighted cell in order to take a printout, with help of same search box..

[@ComTutor]

yes when your search box completed, search your value in the search box, then your value will be highlighted after that apply the filter by text color in cell. all the highlighted value will appear on top then select them and print.

[@chandra2982]

Please give the solution without highlighted colour selected automatically filter in excel sheet it is possible or not

[@hiteshkumarkantilalpatel1261]

Hello.. i have given Hyperlink to my sheet... But when I hide any particular sheet... And then we click any data.it doesn't work..Because destinated sheet is hidden... So what to do

[@ComTutor]

so remove the hyperlink from sheet because without hyperlink this sheet will give you error everytime.

[@RajeshKumar-kg2vr]

Sir I like your video. Kya search box farmule me aisa ho sakta hai ki jise search kiya jaye sirf wohi screen pe show hojaye aur baki document hide ho jaye. Agar ha to aisi video bhi banao kyon ki aapke samjhane ka tarika bahut hi achha hai, thanku sir

[@ComTutor]

thank you Rajesh mera video dekhne ke liye
and apne jaise bataya waise excel mei to possible nahi hai but mai ek baar try kar ke dekhunga aur ho paya phir apko dobaara comment karunga.
thanks yaar for the comment.

[@govindparmar1937]

VERRY NICE

[@ComTutor]

thanks

[@shaukatsamad2510]

Great, I can say excellent, would u pls tell how long it take to become proficient... the apply formula in a exact place. pls advise... thnx

[@ComTutor]

it depends on your data range as well.

[@manishshukla7470]

THANKS

[@singhalmonica]

nice, if we dont know exact word, then also it works... like in place of DELHI, we enter DEL, will it show DELHI as well as another similar word????

[@ComTutor]

yes, of course, it will work on a similar word.

[@djalex4uu]

You're awesome sir

[@ComTutor]

thanks.

[@msb1231]

Very useful, if I want to add alert msg for the name I enter in search cell but, that name is not there on the table then what formula will use and I want to restrict my cell for numeric or text only.

[@ComTutor]

nice i'll teach in future video.

[@anushreeroy7080]

Is search box possible in ms word.

[@clemwolff9541]

i have a long spread sheet. when i search i still have to scroll down to find what was searched. what is the fix for that?

[@SIMRANKAUR-eg7nc]

I don't believe it is feasible without applying VBA. Without VBA, as u might be knowing, we can simply filtered the coloured row/column. After applying this conditional formatting.

[@SIMRANKAUR-eg7nc]

Yes u can when we apply search it returns a number so wrap that in a if function and if a number is returned then perform some operation or else do nothing "".
This video is beautifully explained. However If u want to understand of logic behind setting the column reference to absolute or relative to highlight the row or column watch this highly interactive video.
ruclips.net/video/Gp3b8y_pO8I/видео.html

[@inderuae5436]

Bro i wana ask you one thing... That i took 150employee list.. and whenever am searching 149 employee no. Its highlight that person but its not going automatically on that row... I have to scroll and go... Plz solve this problem also

[@ComTutor]

after search row will be highlighted and then apply filter now open filter down and choose filter by color and choose highlighted color all selected row will come up.

[@pradeeprastogi3777]

Thanks sir. Is there any option to seach only unique value or name. Regards
Pradeep

[@ComTutor]

not this way, you can find unique value by another method.
like condition formatting, or duplicity.

[@rayhanrabby3824]

It will be best if you can also add filtering option. This search can find and mark those rows only but it can't gather all the founded rows together. if the file has more than 1000 rows then it is so tough to scroll down and finding those colorful marking rows.

[@ComTutor]

in more than 1000 rows you can filter by the background color. not scrolling.

[@rubeenasaifi2964]

First of all thank you for this video but sir formula is (=search(cell selection, table array ) right even formula is not applying

[@ComTutor]

then send your excel sheet to me on [e-mail] i'll check and correct that.

[@anilvijayvargiya2101]

I have one standard part no for which there are more than one alternate part no. Which formula have to apply to get all alternate part details in single cell or multiple rows/columns

[@ComTutor]

i didn't get your query, just send your excel sheet to [e-mail]
and write your all problems in sheet i'll try to resolve as soon as possible.

[@amitkaushik7645]

Thank u very much sir

[@ComTutor]

thanks

[@amitkaushik7645]

☺☺☺☺☺

[@hashim110pk]

Zabardast sir

[@ComTutor]

thanks

[@rraushan2088]

Hi can you help me I want if value is anywhere in sheet1 and when I put the same value in sheet2 any cell I get that value in front of that....

[@ComTutor]

i think ye ho skta hai we should try it. yha par hme sare excel ke column ko select krna hoga.

[@rraushan2088]

ComTutor sir Ji par karoge kaise kiyu ki agar vlookup lagate hai to koi v column ka no dena padega jo ki ek hi column hoga na ki ek se jyada agar aap ise index se karoge to v usme ek hi column ka option hai.....pls help me agar koi advanced formula ho to sare RUclipsr se puchh liye kitne to samjh hi nahi pa rahe hai aur kitno ne samjh kar ans nahi diya agar aap ko abhi v samjh nahi aaya hoga to pls call me 9899807961 on my no.....sir Ji but pls help me.....

[@hiteshkumarkantilalpatel1261]

But.. Hyperlink is necessary for me... For going from one sheet to another..Example..HOME.

[@ComTutor]

okay i'll teach Hyperlink..

[@excellearners7976]

best

[@ankurkumar-jp2pl]

Hi bro video is very good.but agar hamara data multiple sheets me ho to single search box kaise kaam karega.pz reply

[@ankurkumar-jp2pl]

Ex excelwork book ke single search box kaise banaye.jo mere 8 ya 10 sheets ka data search kar sKe

[@mahendrachowdhary1317]

I applied ur formula but I felt difficulty in finding search vaule (next cell is highlighting instead current cell)

[@SIMRANKAUR-eg7nc]

The problem may be due to difference in the active cell and the one in the formula pasted. Both should he the same.
This video is beautifully explained. However If u want to understand of logic behind setting the column reference to absolute or relative to highlight the row or column watch this highly interactive video.
ruclips.net/video/Gp3b8y_pO8I/видео.html

[@abhijeetraj3530]

How to search cell wise in all data.

[@RakeshSarita]

please advice can we find the last edited cell in the excel

[@ComTutor]

After save it's not possible otherwise you can do it with Ctrl+Z

[@abhijeetraj3530]

How to find same number in in excel sheet

[@Moon2Suns]

After search sirf search content hi show ho baki nahi. Filter jaisa. Wo possible hai. Please bata wo bada helpful rahega

[@ComTutor]

nahi bhai search box hai to search hi karega na. filter ka kaam nahi kar skta.

[@tilaedmunds]

This wont work for me? It is doing the right sort of thing like highlighting different cells after i type something in, but it isnt highlighting the correct cells. Only ones that have nothing to do with what i typed in? Can someone help please?

[@ComTutor]

send your sheet to me on [e-mail] i'll check your sheet and correct your formula accordingly and resend to you.

[@ashirwadpatil6586]

ComTutor i have same issue can I mail u mu file

[@nainanath8593]

Search karne ke baad jo colour fill hota hai wo filling hi rahna chahiye uska formula hai kya kyuki mujhe search karke 550 data register me likhna hai har mahine. Please

[@valiantcolumnar1992]

how about. if you search employee ID: 1001, only 1001 data will show in the list?

[@mahtabalam126]

If possible to also count the product when I m search

[@SIMRANKAUR-eg7nc]

Yeah u can apply a countif function under aggregate function where h can select option of ignoring the hidden row

[@SIMRANKAUR-eg7nc]

Yes u can when we apply search it returns a number so wrap that in a if function and if a number is returned then perform some operation or else do nothing "".
This video is beautifully explained. However If u want to understand of logic behind setting the column reference to absolute or relative to highlight the row or column watch this highly interactive video.
ruclips.net/video/Gp3b8y_pO8I/видео.html

[@mankibaat2186]

Is Formula ok protect kaise kre. Ki formula na badal paye koi. Baki detail list or Add kr sake bas lekin formula koi badal na paye iske liye btayiye

[@amarnathroymaner]

Thank you

[@ComTutor]

thanks

[@Seriously_Busy_in_Patna]

How to create search box if data written on another & different sheets. Like sheets name ---January , February .............December Etc.

[@SanviPatil2019]

Sir mere pass ek excel file hai.. aur alag alag sheet me mera data hai..mujhe ek first wali sheet me ek dashboard banana hai... mere pass 20sheet hai aur usme kuch data hai aur wahase data mujhe dashboard wali sheet me chayhiye Jaha me kuch bhi find karu to wo pura data use sheet se mere dashbord wali sheet me aa jana chayhiye..... Uske liye micro use kar sakte hai, ya search box ya aur kuch hum bana sakte hai...

[@ComTutor]

iske liye aap dashboard wali sheet mei only lookup use kijiye, rest entries aap dusri sheet mei kijiye, isse aap dashboard wali sheet ko upto date rakh payenge.

[@md.saifulislamtuku9303]

Sir,
Place make video missing serial this cell. Not another sheet,row&collum .
thanks

[@DataDears]

F2 press krke aap Arrow key use kr skte h

[@ComTutor]

sure bro.

[@rameshwarlahane3646]

Sir android phone me exel app ko use krke kaise banye serch box please bataye

[@neemadhaker1317]

Sir Sare search items aek sat nhi aa skte kya

[@Jesuslovesyou.7808]

Sir ji... Actually hum ye puchana chahte teh ki Excel main cursor automatic sheet1 se data copy karke computer ki dusri application ya software main paste kaise kar sakta hai 100 times. Kya hum vba use kare ya macros. Maine dekha hai ki vba ya macros inn Main se koi ek hai jiske karan cursor automatic slow kam karta hai. Jis speed par hum chahe vaisa. Aur 100 times sare data automatic cursor ke karan within 1hour kam complete. Kya aisa video bana sakte hai.

[@ComTutor]

sabse pehle video dekhne ke liye dhanyawaad.
aapka concern mujhe samajh aa gaya hai, actually ye VBA se ho jayga.
iss par mai video bhi bna skta hoon. but abhi mere paas VBA ki audience nahi hai
agar aap hi ki tarah aur bhi logo ki demand hoti hai VBA ke liye to mai definately video banaonga.

[@MyTubezx]

its working , but 1 issue is that it selects multiple nrs eg if i search 21, then it also selects all cells which has either 1 or 2, so my selection becomes 21, 12,31,22 etc,,everything which has these nrs are selected..

[@ComTutor]

yah because we have given the same command in formula to search the value.
if you change in the formula then it could be work.

[@moinkhan937]

Agar data more than 100 hota hai to formula kaam to karta hai lakin use dhundhne k liye mouse se scroll karna padta hai lakin f2 se search karne par woh us particular cell par lejata hai to aisa kuch is search ke saath karsakte hain kya ki koi bhi mai data fill karu to woh mujhe usi data pe lejaye bar bar mujhe scroll na katna pade.
Thank yoh

[@ComTutor]

sawaal puchne ke liye dhanyawaad Moin,
dekhiye ye jo search box hai apke result ko ek baar mei dikhaata hai, aur agar aap us cell par jana chahte ho to iska mtlb hai ya to aap usme change karne chahte ho ya nahi karna chahte ho.
agr change nahi karna to thik hai.
but agr change karna hai to aap Replace command use kare.
search se ek baar mei saare result dikhenge, aur ek hi baar mei saare result par jana impossible hai.

[@prafullakumarsahoo1524]

Right question..........

[@kiwiyt1583]

Vlookup try krlo

[@pcmodi123]

सर इसमें ऐसा बताइए ना कि सर्च बॉक्स में जो नंबर टाइप करें सिर्फ वही दिखे बाकी सारा हाइड हो जाए सर्च बॉक्स का जो नंबर हम डिलीट करें तो फिर डाटा पूरा वापस आ जाए

[@ManojVerma-rg4ky]

shandar

[@ComTutor]

thanks.

[@maheshlaxkar7504]

अगर लिस्ट लंबी हो और जो सिंगल रिजल्ट हम सर्च करना चाहे, वो अगर नीचे की तरफ scroll करने से आ रहा हो, तो डायरेक्ट उस पर कैसे जाया जाए, क्योकि मुझे उस row में edit करना है, तब find ऑप्शन से यह कैसे better हो सकता हैं, क्योकि find ऑप्शन लिस्ट कितनी भी लंबी हो, वहाँ कर्सर ले जाता हैं और हम वहाँ edit कर सकते है,

[@johntitor7671]

Not work for me(office 2007 -win 8.1 and office 2016 mac osx).
I do it all right, put the just right same formula(copy/paste the formula for your decription,and edit only the search box row) but when click OK ,i have warning error messare about wrong formula (because have = etc)

[@ComTutor]

check any space in formula or unnecessary value. then apply the formula or send your sheet to me on my mail ID, [e-mail]

[@johntitor7671]

Nothing space in formula or unnecessary value ,all is right ,i try many many time but i don't understand why this happen ,at two office excel.

[@ComTutor]

then send your file to me i'll check.

[@kaleemmuhayuddin4683]

How to search multiple numbers in one search??????????????????????????????????????

[@DEEPAKKUMAR-by4ls]

Very good or excel

[@ComTutor]

thanks for comment..
please watch our more videos in playlist
ruclips.net/video/PWMUqkZl2ZM/видео.html

[@sikandarbhojani23]

Sir you are very good tutor but speak not quickly

[@ComTutor]

okay, i'll try to speak slow. thanks for the suggestion.

[@bishalkarmakar7427]

How to find same name in different titel

[@ComTutor]

apply duplicate data validation.,

[@ifthiqar3422]

How to filter it

[@ComTutor]

color filter.

[@reenabhosale6841]

I tried it but something is going wrong, I mean the items are not getting highlighted

[@ConsulthinkProgrammer]

Try an alternative in Google Sheets:
Membuat Formula Pencarian di Database dengan Keyword Nama dan Tanggal Lahir Menggunakan Google Sheets
ruclips.net/video/XOzRCwyCkdA/видео.html

[@purankahar8069]

Need if and search formula working in a Excel sheet

[@ComTutor]

i have already made a video on if and search formula. please search in channel playlist.

[@purankahar8069]

Need if and search both formula use at a time for getting a text from a paragraph

[@ghanshyamsingla8299]

SEARCH BOX BOTHTYPE USE HO SAKTA HAI KYA JAISE ONE SERCH BOX (SIZE) 2ND SERCH BOX NAME

[@ComTutor]

haan ab search box banate time dhyan rakhna hoga. name wale search box mei only name wale column ko add kare baki nahi isse wo search box only name wale column par ho kaam karega.
issi tarah dusre mei size lo to wo size par kaam karega.