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

Need to find out the particular column values among different columns
Solved by B. B. in 12 mins
So I am trying to create a Vacancy calendar that i can use to compile automatically and distribute the available vacancy week (max 3 employee in vacancy during the same week) Here my idea: B5,H5,O5 etc ... are the Week # the employee must choose. for B6,H6,O6 etc... i used =COUNTIF and take the data from a table where each employee made their choice On the table, the choice 1 is the one that shall be used if there are 3 or less employee that chose it, If there is more than 3 people who chose it, the second choice will instead be used and the 1 choice should be eliminated. I am struggling to find a solution on how the code can determine the priority of employee, cause the older employee will alway have priority over the newer employee.
Solved by E. J. in 30 mins
Need to find and match the few values in columns
Solved by S. L. in 27 mins
I'm doing a VBA Macro. I need to use a cell value date content (which will change with each new report) and subtract 2 days from it in order to find the new value in a Range and then gray it out.
Solved by O. J. in 23 mins
I'm trying to find a way to link my excel workbook to a PowerPoint template.
Solved by E. D. in 11 mins
I want Sheert2 to look at Sheet1 and find the employee name . THEN, on Sheet1, I want Excel to look at a cell below the employee name found on Sheet1 (cell E3 = cell in the next row below A2, 3 rows over) and see if there is a "SPS" label in E3. IF there is a "SPS" label in E3, in the row below A2, I want Excel to pull the Date of Birth from F3 on Sheet1 and input it on Sheet2, cell E2. Otherwise, don't do anything. I don't want to lock the cells because I want to fill the formula down the sheet...
Solved by G. D. in 19 mins
i have one set of inventory reports in one sheet which have client name IP address. i need to identify all the available client name for the given IPs. tried VLOOKUP but i could find only one entry of the client name corresponding to the IP. But i need all the available client name corresponding to the IP.
Solved by F. E. in 15 mins
I am trying to find the right formula to calculate days, hours and minutes between set times. Such as 08/20/17 04:32 to 08/21/17 10:30 would be 1 Day 6 Hours or 30 Hours. Every formula I have tried only gives me hours and won't count days or hours over 24.
Solved by B. F. in 13 mins
i'm trying to find a formula that will look at one cell and determine from the value of the cell where to transfer the contains of another cell
Solved by F. F. in 15 mins
Hi, I have big set of data, generated by different tables, and I like to prepare a formula that reads a cell, find a table that matches to that value, and do excel find value in table which corresponds to a certain row and column!
Solved by V. Y. in 13 mins