Cell Value Comparison IF/THEN Situation
Closed
No Hair Left
-
Jul 22, 2010 at 12:15 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 22, 2010 at 01:38 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 22, 2010 at 01:38 PM
Related:
- Cell Value Comparison IF/THEN Situation
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Jul 22, 2010 at 01:38 PM
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