Thread: dynamic data list

Hi All,

I am new to the forum and not sure if anybody is able to help me with this.

I have data in column A and wanted to create a dynamic list that includes latest unique 12 numbers in x number of cells starting at A1 and rolling down to end of the column A.. The oldest unique number will be removed from list.

for example, there are 12 unique numbers (1-12) in the list Q between A1 and A20, then rolling down to A21, if the number in A21 is unique (let say 13), then it will be added to the list Q (2-13), the first unique number 1 will be removed from the list

what function should I use? any tips

thank you for the help in advance!

Stock

Have it so your first entry is in A2, so that in B2 you can enter formula:

=IF(COUNTIF(A$2:A2,A2)=1,COUNT(B$1:B1)+1,"")

copied down. This is to identify the unique values.

Then in results column:

=IF(ROWS($A$1:$A1)>MAX(B:B),"",INDEX(A:A,MATCH(LARGE(B:B,ROWS($A$1:$A1)),B:B)))

copied down 12 rows.

Hi NVBC,

thanks for the reply.. I see it now.. never mind
thanks again

Stock