Cell Value Comparison IF/THEN Situation
Closed
No Hair Left
-
Jul 22, 2010 at 12:15 PM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Cell Value Comparison IF/THEN Situation
- Multiple IF formula in one cell, date comparison ✓ - Forum - Excel
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- It restricts what values are possible for cells that contain numbers, dates, and text ✓ - Forum - Excel
- Macro copy and paste in next blank cell - Guide
- Excel if cell contains date then return value ✓ - Forum - Office Software
1 reply
rizvisa1
Jul 22, 2010 at 01:38 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jul 22, 2010 at 01:38 PM
What do you mean by Active cell. Did you mean active cell or did you meant that If cell value matches the cell value below it, then clear out values of both cells. In this case what if
A1: 12
A2: 12
A3: 12
Now since A1 value matches A2, we remove A1 and A2 value. What abuot A3
A1: 12
A2: 12
A3: 12
Now since A1 value matches A2, we remove A1 and A2 value. What abuot A3