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

Hi, I have two a range of ascending numbers from 1 to 70 in a column from d2:d71 and in column E a corresponding currency Value running from E2:E71 for example D55 = 54 and the value in E55 is £15.00 what I would like to do is type the sales achieved number a number in B1, for example if this number is 54 I want the formula to return the £15.00 in K54 in cell B2. could you please help
Solved by O. U. in 19 mins
I am trying to return only non black values in a range.
Solved by E. F. in 21 mins
I'm trying to do an if statement that looks up a range and returns a value
Solved by T. H. in 29 mins
I used you guys yesterday and they gave me a solution that I can not get to work for me. I want to take a range and take all non blank values in it and list them in another range.
Solved by X. H. in 25 mins
talked to 2 experts. First one i can not get the solution to work and the time expired on the second one. I need to take a range and list all non blank values init into another range
Solved by B. D. in 24 mins
I have had 3 experts help me and havnt gotten a working solution yet for my issue. I am trying to move all the values that are not blank in a range and list them in another range with no blank cell.
Solved by T. U. in 15 mins
I have a folder where new files are dumped everyday. I want to know the names of files present in the folder at the end of the day and each file's 'last modified by'/'last author'. I have a VB code which gives me just the file names but not the last modified by information. Can someone help with this? Here is the code Sub ListAllFile() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim objFileItem As Object Dim ws As Worksheet Dim lm As String Set objFSO = CreateObject("Scripting.FileSystemObject") Set ws = Worksheets.Add 'Get the folder object associated with the directory Set objFolder = objFSO.GetFolder("C:\Users\msinha\Desktop\Project DNA\New") ws.Cells(1, 1).Value = "FILE NAME " & objFolder.Name & "are:" r = Range("A65536").End(xlUp).Row + 1 'Loop through the Files collection For Each objFile In objFolder.Files ws.Cells(ws.UsedRange.Rows.Count + 1, 1).Value = objFile.Name Next 'Clean up! Set objFolder = Nothing Set objFile = Nothing Set objFSO = Nothing End Sub
Solved by A. A. in 19 mins
I have a spreadsheet where there are tabs for each of my agents metrics. I want to create a vba that will pull from each tab and copy a specific range and then paste it into an outlook email addressed to that specific agent. Any thoughts?
Solved by Z. U. in 13 mins
Select the Cells B9, B15, B21, B23 and assign appropriate range names and Click B25 and use the newly created range names to create a formula to calculate the total house cost.
Solved by I. S. in 28 mins
Enter values in D6:D15 from 1800 to 3600, step of 200; apply Blue font color and Comma style with zero decimal places In range D5:F15, create a one-variable data table with B7 as Column input cell
Solved by A. D. in 25 mins