Get instant live expert help on I need help with excel if value in range
“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
Is in it possible in excel to identify if there are duplicate value on a range of data?
Solved by X. L. in 28 mins
Can you simplify this formula for vba?
Sub Test()
Dim LastRow As Long
Dim i As Long
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Range("A" & i).Value = "CANCELLED" Then
Range("N" & i).Value = "," & Range("N" & i).Value
Range("O" & i).Value = "," & Range("O" & i).Value
Range("P" & i).Value = "," & Range("P" & i).Value
Range("Q" & i).Value = "," & Range("Q" & i).Value
Range("R" & i).Value = "," & Range("R" & i).Value
End If
Next i
End Sub
And skip if blank.
Solved by M. E. in 16 mins
In Excel if a cell equals a value in a range then the value in another cell otherwise blank
Cell if A3 = 1233 look in C1:C25 range of cells for 1234 then enter the corresponding data from a range of D1:D25 into B3
A3 B3 C1:C25 D1:D25
1233 Jones, Jack 1230 Anderson, Tim
1231 Johnson, Henry
1232 Clinton, Bill
1233 Jones, Jack
Solved by O. C. in 29 mins
i need a formula where cell c3 is looking at the value in d4. if the value in d4 is in the range of .9975 and 1.0025 i want it to enter 1 in c3. if the value in d4 is outside that range i want it to simply enter the value from d4 into c3
Solved by F. J. in 16 mins
Looking for a formula for a named range, such that if ALL of the cells in the range meets ANY of these parameters: ="p", ="pass" or ="pr", then return value "PASS". If not then return value "FAIL".
Solved by T. L. in 22 mins