Delete cells with 0 as the tenth digit
Gentlemen, I was working with pointerman on another issue regarding this same
dataset, and I believe what he meant to say is that each on of those line is
in one cell. That's a total of 4 cells.
So if those lines were in cells A1:A4 and this formula was in B1:
=IF(MID(A1,10,1)="0",1,A1)
....and copied down, the first two would return their original value and the
second two would return a 1.
His original formula appear to be working in its original form, at least it
does on the sample data he has provided.
If he REALLY wants the ones without SHIP or PKG flag (has a 0 instead) to
"disappear", I would simply make this following correction to his formula:
=IF(MID(A1,10,1)="0","",A1)
--
"Actually, I *am* a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
|