[Solved] Sort four columns, match same data?

Discuss the spreadsheet application

[Solved] Sort four columns, match same data?

Postby MaCro » Tue Jan 07, 2020 4:14 pm

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 25 times
example.ods
(10.23 KiB) Downloaded 27 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
MaCro
 
Posts: 2
Joined: Tue Jan 07, 2020 4:01 pm

Re: Sort four columns, match same data?

Postby Villeroy » Tue Jan 07, 2020 7:06 pm

Pivot_t100659.ods
(18.51 KiB) Downloaded 23 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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28546
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby MaCro » Tue Jan 28, 2020 4:31 pm

Solved!

Worked great for my case!

Thanks!
OpenOffice 4.1.1
Windows 7
MaCro
 
Posts: 2
Joined: Tue Jan 07, 2020 4:01 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 14 guests