 # 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!”

## 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

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