static69 wrote:
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(INDIRECT("1:"&ROWS(A1:A85))))))
The reference to the Bullets sheet should be a column of the same size
as the one referred to in the second equation (A1:A85).
If you are following the format of Contextures, the first equation
should read:
=if(countif(Bullets!B1:B85,A1)=1,"",row())
|