centralmike
asked on
EXCEL 2010
I would like to create a if than else function in excel. I I have a large file of 7000 records I would like to set.
Example
if column a1 = "not mapped",
set column b1 = blank
and
set column c1 = blank
else
leave values to current status.
attaching a spreadsheet.
Excell_ifThenelseook1.xlsx
Example
if column a1 = "not mapped",
set column b1 = blank
and
set column c1 = blank
else
leave values to current status.
attaching a spreadsheet.
Excell_ifThenelseook1.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The following function worked great.
Maybe should share 50/50 with Saqib. Comment from OP does not state which answer was used.
1. No VBA. Use columns D and E for the result and hide columns B and C
2. With VBA
Which way do you want to go?