News for hackers. Stuff that matters.

A comment on XLOOKUP for Excel.

Re:XLOOKUP for Excel by eyeball on Saturday August 31, 2019 @11:07AM (#20846692)
Now give me count distinct in pivot tables, and limit rows in a book only by the ram in my machine.
[ Parent | on HN ]
Re:XLOOKUP for Excel by kvna on Saturday August 31, 2019 @12:04PM (#20847112)
If you add your table to the data model you can do count distinct with a pivot table
[ Parent | on HN ]