var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Excel Help
I have an Excel sheet that looks like this:
As you can see, some entries have a name, company, and email, while others only have name and company. I would like to know how to delete only those entries that have a name and company, but no email. Is this possible?
Here is a formula and attached Excel example of how to mark rows to delete, where there is no "email:" label. The asterisk symbol * means
AND, the plus symbol + means OR.
Then you delete all rows with "DEL" displayed.
The formula reads: if column A cell is "Company:" and the next cell is blank, or if column A cell is "Name:" and 3rd cell down is blank, then display "DEL", otherwise display nothing.
Thank you very much. That was a huge help!!!