I have imported my cell phone records into excel and want to distinguish percentage of business phone calls for tax purposes.
Is there a way to write a formula based on recognition of a name or number in one column to leave a notation in another column, to be counted in COUNTA and be recorded in my percentage calculation?
ex. names/numbers would be in COLUMN E and I want a "-" left in COLUMN N to indicate it's a business call.
(I have a COUNTA formula set up in Column N as of now and have been manually marking each call).
Thank you!!!
Is there a way to write a formula based on recognition of a name or number in one column to leave a notation in another column, to be counted in COUNTA and be recorded in my percentage calculation?
ex. names/numbers would be in COLUMN E and I want a "-" left in COLUMN N to indicate it's a business call.
(I have a COUNTA formula set up in Column N as of now and have been manually marking each call).
Thank you!!!