Testing for Blank Cells

I'm don't think this works. The possible combinations to copy the complete record as as follows: A1 and C1 combined must not be blank; or A1 and D1 combined must not be blank; or B1 and C1 combined must not be blank; or B1 and D1 combined must not be blank. If one cell of any of the four combinations is blank, then I do not want to copy the record. Thanks!

Shg,

I need to do both. Thanks

What end result do you want?

If there are values in both A1 & C1, etc... do you want a single value placed in cell M10 that references that fact? In otherwords... Do you want M10 to say...
"A1 & C1", or "234A & 4T41", or "2 cells not blank", or what?

And if that's the case, are you addressing each row separately? In otherwords... Will you want to display row 2's results in M11 ?

Or are you just trying to post the table, without the blanks? In otherwords... A1:D7 would become M10:P16, except it is displayed like this...
234A N333 4T41 7657
11C2 321 3T27
L954 989
56D1 297-1
87E3 P199
D992
Z222 3391

Just trying to help...

MSY12,

Thanks for your reply. I have a spreadsheet with approximately 12,000 rows of data. It's being used as a database. If certain cells of data of the same row have data and are not blank, I want to copy the entire row of data to another spreadsheet. I am having difficulty testing the cells of data which maybe numeric or alpha numeric. The possible combinations of cells are as follows:

A1 and C1 combined must not be blank; or
A1 and D1 combined must not be blank; or
B1 and C1 combined must not be blank; or
B1 and D1 combined must not be blank.

Thanks!

Shg,

I'm confused. I re-read your prior reply and realize I may not have replied correctly to you. I am interested in the following only:

A1 and C1 combined must not be blank; or
A1 and D1 combined must not be blank; or
B1 and C1 combined must not be blank; or
B1 and D1 combined must not be blank.

I need to be able to test for these 4 possible combinations. If any one of these combinations is not a blank then I need to copy this entire row of data. My spreadsheet has over 13,000 rows of data with 17 columns/cells per row.

Thanks