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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Albert Einstein - 30 Jun 2007 12:54 GMT

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?

Reply to this Message

shah shailesh - 30 Jun 2007 14:48 GMT

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.

> Hello Group,
> First off, this group is really helpful for us "newbies" attempting
[quoted text clipped - 13 lines]
>
> Any advice?

Reply to this Message

Rate this thread: