A formula cannot move data. You need a macro to move data

--
Don Guillett
SalesAid Software

"static69" wrote in message
...

I am using 3 columns of data. The first is my original list. the second
contains this

=IF(COUNTIF(Bullets!$A$1:$K$310,A1)=1,"",ROW())

the third contains this


=IF(ROW(A1:A85)-ROW(A1)+1COUNT(B1:B85),"",INDEX(A:A,SMALL(B1:B85, ROW(INDIRE
CT("1:"&ROWS(A1:A85))))))

The third column is the list that I use to fill in cells on a sheet
called Bullets.

www.contextures.com is where the formula came from, and the second
formula is inputted as an array. However, when i go to the sheet
called Bullets, the items do not come off of the list. What have I
done wrong with the code or what am I doing wrong with the validated
lists?


--
static69
------------------------------------------------------------------------
static69's Profile:
http://www.excelforum.com/member.php...o&userid=11075
View this thread: http://www.excelforum.com/showthread...hreadid=345855