Get instant live Excel expert help to learn how to use Search function in Excel?

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I work at a food production factory. I have a spreadsheet with multiple worksheets. Each worksheet represents a separate line in the factory. It is used to enter data when changes are made to a line. In each sheet, a person enters the data: Date, Time, Change, By Whom. Is there a way to set up a sheet for 'Latest Changes' that search through all sheets for the latest date & time, and display the latest 10? I have tried various things from googling, but have not found a working solution.
Solved by D. F. in 27 mins
I am trying to search a data validated cell for keywords and based on the keywords, return a value to another cell
Solved by I. Q. in 20 mins
Making a dynamic gantt chart using conditional formatting, IF statements, WEEKDAY function, drop down menus, etc. 1. COMBINE THESE FORMULA INTO A SINGLE NESTED IF STATEMENT. SO FAR I HAVE RUN INTO CIRCULAR CELL REFERENCE ISSUES SO I AM NOT SURE IT THIS IS POSSIBLE OR IF WE NEED TO FIND ANOTHER WAY. If (Start Date=Row Date, when true, fill in a value of 1, if false, no value. IF(E10=K9:DI9, 1,””) Search the row and insert a 1 on the correct starting date. This formula is correct. If(sum of K10:DI10<D10,1,””) Insert a 1 value until the total number of days is reached. This formula allows us to add in travel days for clients quickly by replacing a 1 value with an x. The formula automatically inserts a 1 value at the end of the plan for each “x” input. Does not count values of “” or x. This formula is correct. If Delivery Date=5, insert an “x” for WEEKDAY value of 7 and 1 (Do not make food on Friday and Saturday) If Delivery Date=6, insert an “x” for WEEKDAY value of 7 (Do not make food on Friday) If Delivery Date=7, no action required (Deliver meals 7 days per week) This formula needs to be written. Conditional formatting for table: 1 value = green font, green background, complete x value = grey font, grey background, This conditional formatting is set. 2. DYNAMIC END DATE Use a formula to look up the last value of 1 in the row K10:DI10 and return the date from K9:DI9. This value will be shown in cell F10 In cell F10, =find the final 1 value in row K10:DI10 and return value from K9:DI9. This allows us to automatically update the end of plan to inform clients when their renewal is due. This formula needs to be written. 3. SET THE PROJECT START AND END DATE IN CELLS C5 AND C6 TO AUTO FILL THE CALENDAR DATES.
Solved by S. Q. in 23 mins
In an Excel spreadsheet, I have a column containing a username and a column containing a type of search. For each unique username, I want to randomly select 5% of the rows that have search type "A", and 5% of the rows that have search type "B", for each username. I will need to do this multiple times for a worksheet, and the total number of rows will not always be the same. I am rather an amateur. Any direction and/or assistance would be greatly appreciated. Thank You!
Solved by G. W. in 25 mins
In an Excel spreadsheet, I have a column containing a username and a column containing a type of search. For each unique username, I want to randomly select 5% of the rows that have search type "A", and 5% of the rows that have search type "B", for each username. I will need to do this multiple times for a worksheet, and the total number of rows will not always be the same. I am rather an amateur. Any direction and/or assistance would be greatly appreciated. Thank You!
Solved by G. W. in 24 mins
So I need to group a cluster of words to be removed from excel. I was doing search and replace individually and this took quite a time. Sometimes new words will be added so I'll have to have some formula or vba where i can modify it later.. But current words that need to be removed area ebay , paypal, free , neutral, negative, feedback, free, phone, call, froo, auctiva, and more words as i find new ones
Solved by G. L. in 30 mins
So I need to group a cluster of words to be removed from excel. I was doing search and replace individually and this took quite a time. Sometimes new words will be added so I'll have to have some formula or vba where i can modify it later.. But current words that need to be removed are ebay , paypal, free , neutral, negative, feedback, free, phone, call, froo, auctiva, and more words as i find new ones
Solved by K. Q. in 28 mins
Looking for formula or vba in removing certain words in my excel files. Certain words for example ebay, paypal, free, shipping, neutral, feedback, positive, froo, call, auctiva, turbo lister, listing, buy it now, auction, Have been using search and replace individually and is time consuming. And would be nice to have a group of words to just delete using some sort of macro, formula, vba... Also able to modify these so i can add additional or remove words in future?
Solved by I. D. in 17 mins
I am having some troubles with a calculation. Right now the formula only matches when A1 matches the word exactly. I would like it to search for any of the 18 possible words to match to. Please help
Solved by F. Y. in 20 mins
Database tab Unique IDs col 'V' needs to search for unique ids in col c all the way down to row 10000 Dwell Time Row 2 to 102 Col W to BD needs to calculate all the times from P for each unique zone found in G all the way to row 10000
Solved by S. J. in 23 mins