Excel Online - Formula to get the unique rows from multiple sheets

New Contributor

Hi, Good Day.


I need your help.


What formula will I use to get the the unique rows from multiple sheet and compile it to master sheet?


I can't use power query because I have no access to the Office desktops apps. I can only edit the file in excel online.


Thank You So much..






4 Replies
best response confirmed by amarie07 (New Contributor)


You may use references, but better transform your data in structured tables. When

  rA, ROWS(Table1),
  rB, ROWS(Table2),
  c,  SEQUENCE(,COLUMNS(Table1)),
  k,  SEQUENCE(rA+rB),
  UNIQUE(IF(k<=rA, INDEX(Table1,k,c), INDEX(Table2,k-rA,c)))