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!”
Here are some problems that our users have asked and received explanations on
I need the formula to check criteria in column A then column Q for range Q2 to Q200 and return with count
Solved by S. J. in 24 mins
Anyone able to help with something I'm struggling with on an Excel spreadsheet please? I'm trying to work out how to create a formula for the following;
Monthly sales value for a particular sales category between a specific date range (in month), I've searched online and can't find anything to help.
Solved by B. H. in 12 mins
Hi, i have to use a IF; ISNUMBER; and i need to apply a 3% discount to the numbers that fit my range but i dont know how
Solved by E. A. in 26 mins
In cell D6, type ML3583. Select the range D5:D14, and then use the Flash Fill button (in the Editing group on the Home tab) to automatically enter codes into the remaining cells in the range. (Hint: You must use the Flash Fill button to properly receive credit for this step.) [Mac Hint: Flash Fill is not available on Excel 2016 for the Mac, so refer to the Final Figures to enter the correct values.]
Solved by C. D. in 12 mins
I have a value in B2. I want it to find the value in the first column of a named range and return all the data from the same row of columns 2,3,4,5 and 6 of the same named range for as many rows the match value is found.
I am currently using:-
=IF(ISERROR(INDEX(WeekProtests,SMALL(IF(WeekProtests=$B$2,ROW(WeekProtests)),ROW(1:1)),2)),"",INDEX(WeekProtests,SMALL(IF(WeekProtests=$B$2,ROW(WeekProtests)),ROW(1:1)),2))
But I am returning duplicate records for some reason
Solved by G. Q. in 11 mins
I need help concatenating a range of cells which contain vlookups and often result in #N/A values
Solved by I. H. in 12 mins
I have a range of cells with data and when they are over 10 the cell colour changes to red. How can i total only the red cells in the spreadsheet. I dont use VBA
Solved by G. E. in 13 mins
Hi there. Please could you help me to turn this formula into an array formula to be used across the range C43:C450
=round(if($C43="",sumif($B44:$B90,$B43,AA44:AA90),SUMIFS(Cashbook!D:D,Cashbook!K:K,B43,Cashbook!L:L,C43, Cashbook!T:T,"")+SUMIFS(Cashbook!H:H,Cashbook!K:K,B43,Cashbook!L:L,C43, Cashbook!T:T,"")),0)
Solved by C. C. in 15 mins
Sub ConcatWithStyles()
Dim X As Long, Cell As Range, Text As String, Position As Long
Range("A3").Value = Space(Evaluate("SUM(LEN(A1:F1))+COLUMNS(A1:F1)-1"))
Position = 1
Application.ScreenUpdating = False
For Each Cell In Range("A1:F1")
With Range("A3")
Characters(Position, Len(Cell.Value)).Text = Cell.Characters(1, Len(Cell.Value)).Text
For X = 1 To Len(Cell.Value)
With .Characters(Position + X - 1, 1).Font
TintAndShade = Cell.Characters(X, 1).Font.TintAndShade
FontStyle = Cell.Characters(X, 1).Font.FontStyle
End With
Next
End With
Position = Position + Len(Cell.Value) + 1
Next
Application.ScreenUpdating = True
End Sub
Solved by G. L. in 20 mins
I have a multiple amount of cells which contain the format of x-x as ranges I would like to use a formula to calculate the range of these numbers
Solved by Z. Y. in 23 mins