without researching, myself, i need to add a column with a formula that returns "home" for a null entry in a cell, and "Away" for an entry of "(at symbol)" or "N"
if that makes sense
pretty sure its going to be an if/then statement, but not sure of syntax
Judging by the number of views of your post, and the lack of response, it's looking like you're going to need to do a little research yourself after all.
Generally speaking, the volunteers on this forum, if not all of them, like people to have made some effort before seeking help.
To point you in the right direction, you are right in assuming you will need an IF function, probably a nested IF using OR for the second condition options.
Google Excel If Function and Excel Or Function.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks