Can removal of certain rows be automated?
Hi,
I will be getting an Excel file with some 1000 rows and 10 columns. The rows that have a value of N1 in column F and a value of N2 or N3 in column H should be removed (predicted outcome: about half the rows will remain). Can that be automated and if so, how?
Please note that I have only basic working knowledge of Excel and none of Macros if applicable, so please explain step by clear step. Thanx in advance.
Hi, I will be getting an Excel file with some 1000 rows and 10 columns. The rows that have a value of N1 in column F and a value of N2 or N3 in column H should be removed (predicted outcome: about half the rows will remain). Can that be automated and if so, how? Please note that I have only basic working knowledge of Excel and none of Macros if applicable, so please explain step by clear step. Thanx in advance. Read More