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".
[Solved] Report of product sales
[Solved] Report of product sales
Last edited by MrProgrammer on Wed Feb 28, 2024 6:13 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] UNIQUE function provided by lader -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] UNIQUE function provided by lader -- MrProgrammer, forum moderator
OpenOffice 4.1 on Windows 10
Re: Formula to have list of how many of each product sold
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.
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.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Formula to have list of how many of each product sold
Here is the Spreadsheet:
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 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
OpenOffice 4.1 on Windows 10
Re: Formula to have list of how many of each product sold
I added the UNIQUE function as a new macro ...
- Attachments
-
- February 2024.ods
- (45.18 KiB) Downloaded 46 times
LibreOffice 7.6.6.3 on Ubuntu 22.04.4 LTS
Re: Formula to have list of how many of each product sold
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.
OpenOffice 4.1 on Windows 10
Re: Formula to have list of how many of each product sold
The attachment has no formula. Calc Guide Chapter 8 - Using a Pivot Table
- Attachments
-
- Pivot_Month_Person_Category_Subtotals_AOO.ods
- (45.1 KiB) Downloaded 41 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Formula to have list of how many of each product sold
Not looking for a Pivot report... Looking for a formula that works like "Unique" in excel (google sheets). Need it to run automatically.Villeroy wrote: ↑Tue Feb 20, 2024 10:11 pm The attachment has no formula. Calc Guide Chapter 8 - Using a Pivot Table
OpenOffice 4.1 on Windows 10