SOLVED

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..

 

 

 

amarie07_0-1626840404432.png

 

4 Replies
best response confirmed by amarie07 (New Contributor)
Solution

@amarie07 

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

=LET(
  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)))
)