Hello I have been trying to find help on filtering a list and have found this
posting which is great and helps however within my list I want it to look up
two sections as follows:
(IF(ROWS('Data extract table'!BM340:BM340)<=COUNTIF('Data extract
table'!BM$3:BM$56000,1),INDEX('Data extract
table'!BM$3:BM$56000,SMALL(IF('Data extract table'!BM$3:BM$56000=1,(ROW('Data
extract table'!BM$3:BM$56000)-ROW('Data extract table'!BM$3)+1)),ROW('Data
extract table'!BM340))),IF(ROWS('Data extract
table'!BM340:BM340)<=COUNTIF('Data extract
table'!BM$3:BM$56000,2),INDEX('Data extract
table'!BM$3:BM$56000,SMALL(IF('Data extract table'!BM$3:BM$56000=2,(ROW('Data
extract table'!BM$3:BM$56000)-ROW('Data extract table'!BM$3)+1)),ROW('Data
extract table'!BM340))))))


Thanks
Kate