Formula conversion from Google Sheets to Microsoft Excel-CodePudding

I am using 2 formulas for finding only duplicate values and listing them in another sheet. But when I downloaded the Spreadsheet as Microsoft Excel (xlsx), QUERY formula and Array function dont work on Microsoft Excel.

So I need your help about Microsoft Excel.

This is my formulas using on Google Sheets. How can I do that on Microsoft Excel? I am open to another formulas or solutions.

=INDEX( QUERY( QUERY( {'DATA'!A2:A}, "SELECT Col1, COUNT(Col1) GROUP BY Col1 ORDER BY Count(Col1) DESC"), "WHERE Col2 > 1",0) ,,1)

Test sheet:

If hstack is not available, you can try:

=LET(data,DROP(TOCOL(Data!A:A,1),1),
u,UNIQUE(data),
f,DROP(FREQUENCY(data,u),-1),
CHOOSE({1,2},FILTER(u,f>1),FILTER(f,f>1)))