Get instant live Excel expert help to learn how to use Find 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

im trying to find the top ten sales for the month in some sales so i can put a green fill with a dark green text to the top 10 values
Solved by B. A. in 28 mins
Hey! I'm wondering if there is a way to find if there are selected values found together in a specified column
Solved by V. Y. in 24 mins
I have a Userform that is supposed to take the input from a barcode scanner and then search through the previous logged items to find the cell that matches the number that the barcode scanner output. Right now I am having issues getting the userform number to match the list that is present in the whole sheet, I think it has to do with defining the userform value as a string or number, but I cannot figure out how to adjust that. I would also at some point like to make the Userform input automatic, so that as soon as you scan the barcode with the scanner, it will search and log the required information.
Solved by X. H. in 21 mins
Trying to find the Average of race times, but each of the cells shows 1/1/1900 8:58:00 AM but instead of showing the hh:ss:mm.
Solved by I. F. in 21 mins
I'm building a financial model for a business. We have a few different revenue streams, one of which involves selling products on credit, where people pay a downpayment and then the remainder of the price over time. I have different sheets that calculate revenue rec'd per month (based on number of units sold each month, the down payments, plus the monthly revenues for the previous months). But now I need to find a way to calculate the money that's outstanding to be paid (the receivable).
Solved by A. F. in 25 mins
I'm building a financial model for a business. We have a few different revenue streams, one of which involves selling products on credit, where people pay a downpayment and then the remainder of the price over time. I have different sheets that calculate revenue rec'd per month (based on number of units sold each month, the down payments, plus the monthly revenues for the previous months). But now I need to find a way to calculate the money that's outstanding to be paid (the receivable). I'll explain more.
Solved by I. Y. in 18 mins
Question for JFred if available. If not, anyone that can help! I am looking to have the first sheet on this spreadsheet be for a customer service rep to lookup a state and have the applicable information be returned in the cells to to the left - Contact Name, Contact Number and Email Address. All of that data is stored on the second sheet of this file. So I need a drop down list of the states added to sheet one (selection) and then a lookup function to find that state on the second sheet and return the contact name, contact number and contact email address.
Solved by O. J. in 11 mins
Hi I have a long formula with C$7:C$40000 as part of it. How do I do simple find and replace to have for example D$7:D$40000
Solved by V. B. in 19 mins
I need a formula that can take information by recognising two cells together from other sheets. Example below i want one sheet to find total tonnages for various towns under different EWC codes from a number of sheets. Example: Brighton | 17-01-01 | 18 Tonnes not sure if that makes sense?
Solved by K. C. in 21 mins
MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: I need a formula that can take information by recognising two cells together from other sheets. Example below i want one sheet to find total tonnages for various towns under different EWC codes from a number of sheets. Example: Brighton | 17-01-01 | 18 Tonnes not sure if that makes sense?
Solved by T. J. in 14 mins