difference between Window and Mac

[Jagat Pavasia]

dear sir, I have formula that working as I want in Windows (Excel 2001),
but at the same file it did not working on my mac excel version 2001.

=IFERROR(INDEX(UNIQUE(SORT(FILTERXML("<p><c>"&TEXTJOIN("</c><c>",1,IF('FULL DETAIL AADAT'!$AL$4:$BJ$4="Date",IF($C$1="",'FULL DETAIL AADAT'!$AL$5:$BJ$500,IF('FULL DETAIL AADAT'!$D$5:$D$500=$C$1,'FULL DETAIL AADAT'!$AL$5:$BJ$500,"")),""))&"</c></p>","//c[.>0]"))),COUNTIF($A$22:A$22,"D*")),"")



help that work in macbook

 

[RoryA]

There is no 2001 Excel in either Windows or Mac, so what are the real versions, and what does "not working" mean exactly? What is happening on the Mac?

 

[Jagat Pavasia]

There is no 2001 Excel in either Windows or Mac, so what are the real versions, and what does "not working" mean exactly? What is happening on the Mac?

 

[RoryA]

And what is the Mac version, and what is happening?

 

[Jagat Pavasia]

dear sir, I have formula that working as I want in Windows (Excel 2021),
but at the same file it did not working on my mac excel version 2021.

=IFERROR(INDEX(UNIQUE(SORT(FILTERXML("<p><c>"&TEXTJOIN("</c><c>",1,IF('FULL DETAIL AADAT'!$AL$4:$BJ$4="Date",IF($C$1="",'FULL DETAIL AADAT'!$AL$5:$BJ$500,IF('FULL DETAIL AADAT'!$D$5:$D$500=$C$1,'FULL DETAIL AADAT'!$AL$5:$BJ$500,"")),""))&"</c></p>","//c[.>0]"))),COUNTIF($A$22:A$22,"D*")),"")



help that work in macbook

 

[Jagat Pavasia]

And what is the Mac version, and what is happening?

my formula is working on windows excel but same time it did not work in macbook excel

 

[RoryA]

Again, what is happening on the Mac? "doesn't work" is not particularly helpful.

 

[Jagat Pavasia]

Again, what is happening on the Mac? "doesn't work" is not particularly helpful.

nothing do in MacBook, where I input this formula.

 

[RoryA]

Ah, FILTERXML will not work on a Mac.

 

[Jagat Pavasia]

Ah, FILTERXML will not work on a Mac.

any option for it?