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

[amarie07]

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

[#2]

@amarie07 

https://techcommunity.microsoft.com/t5/excel/unique-function-in-data-validation/m-p/2532454

[#3 · Accepted 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)))
)

[#4]

Thank You Sir..

[#5]

@amarie07 , you are welcome