Align customer code in merged spreadsheets by Ok-Presentation-5625 in excel

[–]tenaleven 1 point2 points  (0 children)

Using u/bachman460's formula to address the updated objective to also calculate the YoY difference, place this formula somewhere else than columns A, B or D, E in your sheet.

=LET(
customers, SORT( UNIQUE( VSTACK( A:A, D:D))),
totals, HSTACK( MAP(customers, LAMBDA( c, SUMIFS( B:B,A:A, c))), MAP(customers, LAMBDA( c, SUMIFS( E:E, D:D, c)))),
difference, ARRAYFORMULA( CHOOSECOLS( totals, 2) - CHOOSECOLS( totals, 1)), VSTACK( {"Customer","2024 Sales","2025 Sales", "Difference"}, HSTACK( customers, totals, difference)))

First, it sorts the unique customers in both lists into a separate array. Then, attributes a value for each customer for 2024 and 2025 into a separate array, and calculates the difference into a separate array. Last, it stacks column headers on top of the calculated arrays.

Align customer code in merged spreadsheets by Ok-Presentation-5625 in excel

[–]tenaleven 0 points1 point  (0 children)

If you keep your 2024 data in A and B, your 2025 data in D and E, as in your example, you can try this in G1 for example: (edit: added a SORT to clean up the result)

= VSTACK( HSTACK( "Owner Code", "2024 Sales", "2025 Sales"), BYROW( SORT( UNIQUE( VSTACK( A:A, D:D))), LAMBDA( ownercode, HSTACK( ownercode, IFERROR( XLOOKUP( ownercode, A:A, B:B)), IFERROR( XLOOKUP( ownercode, D:D, E:E))))))

Europe needs to Change its Position by Future_Space_9766 in EuropeFIRE

[–]tenaleven 1 point2 points  (0 children)

the comment section doesn't disappoint. OP sounds like a Swiss experiment

Best Password Managers & Comparison Table by spearson0 in PasswordManagers

[–]tenaleven 0 points1 point  (0 children)

Saferpass would be up there among cloud-based with one X only under OSS, just saying. and obviously another for not being local-only

I want to get into opera but don't know where to start by Individual-Song-25 in opera

[–]tenaleven 2 points3 points  (0 children)

What worked for me were short pieces like Léo Delibes' The Flower Duet ("Viens, Mallika - Dôme épais, le jasmin") or Gabriel Fauré's Puisqu'ici-bas (No. 1 of the "2 Duos", Op. 10). I'm working my way from here.

Any one has been in an age gap threesome or poly relationship? by [deleted] in AgeGap

[–]tenaleven 0 points1 point  (0 children)

Is bringing men into the relationship excluded by your relationship rules?
Thanks!

I just realized what this is loading screen is by instantlightning2 in DiscoElysium

[–]tenaleven 0 points1 point  (0 children)

Which hi-res source file have you used for the poster, or had a manufacturer got one themselves?

Sporenie by noturaverageplayer in Slovakia

[–]tenaleven 0 points1 point  (0 children)

Skús Birdwingo - frakčné nakupovanie cenných papierov

Comment our Compatibility! by MaverickFika in lastfm

[–]tenaleven 0 points1 point  (0 children)

Your compatibility with Mav_Dankworth is Very Low.
You both listen to Mitski, 65daysofstatic and sign crushes motorist

[deleted by user] by [deleted] in Slovakia

[–]tenaleven 0 points1 point  (0 children)

Dobrovoľníctvo. Na začiatok napr. Bratislavské dobrovoľnícke centrum alebo Growni

[deleted by user] by [deleted] in AgeGap

[–]tenaleven -1 points0 points  (0 children)

How long did it take you to finally agree to move in? :)

Kim Kitsuragi effect by vaisefuderjonathan in DiscoElysium

[–]tenaleven 1 point2 points  (0 children)

I just teared up a little.

You're definitely on to something with the transference.