Importing a CSV File and using a Conditional Statement and Row delete?

  • Thread starter Thread starter Albert Einstein
  • Start date Start date
A

Albert Einstein

Hello Group,
First off, this group is really helpful for us "newbies" attempting
to do some calculations. A big kudo's for your monitoring this group.

Question 1:
I am importing a csv file into excel, and then need to do the
following:
1) If on a row I have values in column A and B, excecute this
calculation.
2. If #1 does not execute, then I should have values in columns C and
D, and calculate this formula.

Question 2:
When I bring that csv file in, I have many blank rows that I would
like to delete quickly.

Any advice?
 
1. Use worksheet formula like this,
=IF(AND(NOT(ISBLANK(A1)),NOT(ISBLANK(B1))), Formula for A & B ,Formula for
C & D)

2. You can use the autofilter to filter for blanks, then delete the
filtered rows, turn off autofilter.


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.
 
Back
Top