[Solved] Sort four columns, match same data?

Discuss the spreadsheet application
Post Reply
MaCro
Posts: 2
Joined: Tue Jan 07, 2020 4:01 pm

[Solved] Sort four columns, match same data?

Post by MaCro »

I need to compare sales in Q1 and Q2,

In one table I have buyer name and sales number,

In second table i have buyer name and sales number AND new buyers in Q2, so my sorting fails.

I have uploaded two sheets, example and solution, for you to better understand what I need.

What kind of sorting, matching for formula do I need to accomplish this?

Tnx
Attachments
solution.ods
(10.1 KiB) Downloaded 80 times
example.ods
(10.23 KiB) Downloaded 84 times
Last edited by MrProgrammer on Sun Jan 12, 2020 5:34 am, edited 1 time in total.
Reason: Tagges ✓ [Solved]
OpenOffice 4.1.1
Windows 7
Top
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Sort four columns, match same data?

Post by Villeroy »

Pivot_t100659.ods
(18.51 KiB) Downloaded 80 times
Nother example with more details and bigger data set: download/file.php?id=18838
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
Top
MaCro
Posts: 2
Joined: Tue Jan 07, 2020 4:01 pm

Re: [Solved] Sort four columns, match same data?

Post by MaCro »

Solved!

Worked great for my case!

Thanks!
OpenOffice 4.1.1
Windows 7
Top
Post Reply

Return to “Calc”