Mastodawn

Isocat now → @[email protected]Aug 21, 2023

Any #Excel #MicrosoftExcel experts in eyeshot? I have 2 sets of data organised identically; same number of rows and columns and everything. I want to do three things:

1. Generate a new sheet with _two_ entries in each cell, one from each dataset, one atop the other and preferably different colours.

2. Obtain differential data sets by subtracting set B from set A at all cells and generating a new sheet with the results.

3. As (2), but with any negative result set to zero—so if subtracting set B's cell B52 from set A's cell B52 gives -6,319 or something, the new sheet's B52 is 0, but if that subtraction instead gives 12,031 or something, that value goes in the new sheet.

Halp?

Show thread

ExcelAnalytics Aug 21, 2023

@Isocat
2 is simplest. Make a copy of one sheet, then select and copy all data in the other sheet, give back to A1 of the copy sheet and Paste Special subtract.

OR: use a formula. Make a copy of one sheet, in A1 select all cells then enter the formula =Sheet1!A1 - Sheet2!A1 and press ctrl+enter.

1 is messy. You really want Sheet1!A1&char(13)&Sheet2!A1 formulas?
How about interleaving the rows from each sheet so one is seen above the other? There are a couple of ways of doing that.

Show thread

ExcelAnalytics

@Isocat
3 is similar to 2 but formula is
=IF(SHEET1!A1>SHEET2!A1,0, SHEET2!A1-SHEET1!A1)

Or, even simpler, do the same as 2 but select all the #cells and apply a #Numberformat that shows positive as black and negative as red, like accountants do. That may distinguish them enough.