ranging

Have values in C21-G21 ranging from 0-3. if the value is a 0 or 1, return an 0;if the value is 2 or 3, return an 1. Thanks or any responses.

Hi I need to sort out one thing For example i have four option ("LEFT" "Vacation" "Final Settlement" "Working") on cell ranging from G4:G321 and when i select LEFT OR VACATION the cell i need to show show 0 other wise 30 on cell ranging from J4:J321. I had this formula on the cell ranging...

Hi all, I am having trouble getting the following cleanup code to work: Dim i As Integer For i = 2 To Range("A" & "65536").End(xlUp).Row Step 1 LResult = Len(Range("B" & i).Value) If LResult < 4 Or LResult > 4 Then Range("B" & i).EntireRow.Delete...

Hello everyone, How to find numbers ranging from eg 1 to 10 that do not appear in the selected range? Which formula to write in H2, I2, J2..? <colgroup><col span="11"></colgroup><tbody> A B C D E F G H I J 1 2 9 2 4 4 2 1 3 8 3 5 4 5 5 7 4 6 5 6 6 4 5 4 6 6 2...

I need a macro which could compare the dates between 2 sheets (which contains date in column A and other data like product, customer name etc. ranging from column B:F) I.e sheet 1 and sheet 2 and filter the most recent dates in sheet 1 which are not available in sheet 2 and copy the data...

Need help with a formula. I have 2 columns Column A1:A100 contain duplicate values ranging from 1 through 19 Column B1:B100 contain various values and some duplicate values based on the value in column A. See below. My question is this: 1st I would like to create a formula that calculates...