My Spreadsheet looks like below.

A B C

207 MDIM3030 3 TRUE
208 MDIM3030 FALSE
209 MDIM3034 1 TRUE
210 MDIM3034 FALSE
211 MDIM3038 6 FALSE
211 MDIM3039 4 FALSE

I have sorted by Column "A" and done an EXACT on them.

Now I need to know how to, for example on cell, B:207 (3) and move it
to the blank cell below and so on through the Column. There are
hundreds of lines on the column, so I am looking for a quick way of
doing this. Can anyone please help?

Thank you.


--
John1950
------------------------------------------------------------------------
John1950's Profile: http://www.excelforum.com/member.php...o&userid=18671
View this thread: http://www.excelforum.com/showthread...hreadid=470260