 # 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

I want to use countif based on a cell reference, but ALSO count if the range contains the criteria in parts of the cells.
Solved by C. E. in 26 mins
I'm trying to analyze this data-set to show any correlation between an ETF's (of which there are 70) performance and the unit (PD) generated from a different algorithm, if one exists, over 15 periods. PDs range from "-1859" to "2121" in this data set. The return listed next to each period's ETF is the return for the proceeding period, so P1 Jan 11 return would be used to test P0 Jan 2. My hypothesis is that in general the higher the PD output the higher statistical likelihood that the following period will have a higher return. My goal is to identify the likelihood of a positive next period return based on the level of PD.
Solved by S. B. in 28 mins
I have checked everything, I cannot see why some of these lines are not conforming to the date range in the formula? can anyone else help?
Solved by Z. B. in 14 mins
Hi, I have two formula's I need help to build. Both of these are to give the count of each "namekey = 1" in column C on the style status tab. 1. TAB "Open to Buy" - Column D = The count of "name keys" [each namekey = 1] from column C - but only count -TAB Style Status - the "name keys" that have a qty in column U - W/H Qty and total count into each corrosponding categories, such as 01VES etc using the column D - style status tab & column A - open to buy tab. 2. Open to Buy TAB - Column O = By Categories 01VES as above - Count of "Namekeys" [namekey = 1 style] in Style Status Tab - column C but only if style status TAB - column Q date is in the date range of Open to buy TAB - K4 to K5 thanks
Solved by I. H. in 29 mins
I need help with a simple do loop that will let me copy a range distribution data along with the item. This will copy to the same spreadsheet in a format that can be used.
Solved by G. W. in 27 mins
I have a list of numbers with a scoring of 1-5 and i want to form a formula that takes the highest mode in the range of numbers, but if the range of numbers includes the score of 4 or 5, takes the highest number of that 4 or 5 instead.
Solved by T. L. in 18 mins
Just want to automatically list out unique account number from selected range
Solved by V. F. in 26 mins
Hello, I am trying to do an excel IF formula - whereby if my answer falls within a certain range then the following answer will be pushed out... but I am missing something. =IF(C13>F13="High"),(C13<F15="Low"), (F13>C13<F15="Equilibrium")
Solved by A. H. in 11 mins
I have the following code which converts a text link into a clickable link. It then display 'URL' instead of the whole web address. However some of the rows never contain a URL and therefore are blank but my code still puts the word URL for the null records. What do I need to change in my code in order to ignore the null cells? 'Make URL clickable Dim Cell As Range Dim CheckRange As Range On Error Resume Next Set CheckRange = Sheets("Quote").Range("B2") Set CheckRange = Range(CheckRange, Cells(ActiveSheet.Rows.Count, _ CheckRange.Column).End(xlUp)) For Each Cell In CheckRange.Cells Cell.Parent.Hyperlinks.Add Anchor:=Cell, Address:= _ Cell.Value, TextToDisplay:="URL" Next Cell
Solved by S. A. in 25 mins
Please can you help me. I would like to format the background of the cells in Column L if the value in another cell on the same row (column C) is blank. I have this code which formats the cells in Column C which is the cell that I am checking to see if it is blank, but how do I change it so that it formats column C instead? On Error Resume Next Set CheckRange = Sheets("Quote").Range("C2") Set CheckRange = Range(CheckRange, Cells(ActiveSheet.Rows.Count, _ CheckRange.Column).End(xlUp)) For Each Cell In CheckRange.Cells If Cell.Value <> "" Then Cell.Interior.ColorIndex = 0 End If Next Cell On Error GoTo 0
Solved by I. E. in 23 mins