Hello My Dear ... Please kindly help me in adjusting this equation and making it work. It is the equation of fetching all the names from the pages starting from page 1 to page 4 without repetition and placing them on the Total page starting from cell B2
Code:
=IFERROR(SMALL(('1'!$B$2:$B$12,'2'!$B$2:$B$38,'3'!$B$2:$B$40,'4'!$B$2:$B$41),1+SUMPRODUCT(COUNTIF(B$1:B1,CHOOSE({1,2,3,4},'1'!$B$2:$B$12,'2'!$B$2:$B$38,'3'!$B$2:$B$40,'4'!$B$2:$B$41)))),"")