Remove blank n dupilicate record

  • Thread starter Thread starter cgx79
  • Start date Start date
C

cgx79

Col A B C
--------------------------
111 111 111
222 222 222
333 333 333
aaa 444
sss 555
444 444
555 555
333 333

Hi,

Col A is origina record, i only want number so after sorting usin
function it will auto hv Col B but for row 4 to 5 it is blank becaus
of the aaa n sss. I want my final output to be Col C. Blank are remov
n dupilcate record r not shown...

Can this be done without using marco..
 
You've already asked this question!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top