Apache OpenOffice Community Forum

Hey Everyone,

I am trying to make a page in my daily sales report show how many of each item was sold. I can do it in Google sheets but I can't get the formula to work in calc. I need a formula not a filter.

Google Formula = "=UNIQUE(Sales!N2:N1608)" then "=sumifs(Sales!$E$2:$E$1608,Sales!$N$2:$N$1608,A2)"

Calc does not recognize the "UNIQUE".

While I think I understand what you're trying to do, my lack of knowledge regarding the UNIQUE function in Google may mean that my understanding is incorrect.
Can you tell us where in the Google spreadsheet the UNIQUE function is placed? If it's A2 (as I suspect), then you might want to reconsider using Calc's SUMIFS and look at SUMPRODUCT.

Here is the Spreadsheet: I used CONCATENATE on the Sales sheet to make a helper column for the UNIQUE formula in A2 of the Most Sold sheet.

Here is the Google Sheets Link to see that it works on Google.... but will not convert to Office Calc:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

I added the UNIQUE function as a new macro ...

lader wrote: ↑Tue Feb 20, 2024 6:36 pm I added the UNIQUE function as a new macro ...

I am new to this. I opened your file and everything works fine. I do not know how to transfer the macro into my existing spreadsheet to make it work.

The attachment has no formula. Calc Guide Chapter 8 - Using a Pivot Table

Villeroy wrote: ↑Tue Feb 20, 2024 10:11 pm The attachment has no formula. Calc Guide Chapter 8 - Using a Pivot Table

Not looking for a Pivot report... Looking for a formula that works like "Unique" in excel (google sheets). Need it to run automatically.