How to calculate the difference in cell values in Google spreadsheets?

M

M

Merry Cay2019-12-23 14:28:42

Google Apps Script

Merry Cay, 2019-12-23 14:28:42

How to calculate the difference in cell values in Google spreadsheets?

Such situation. I need to calculate the difference of pairs of values, and have the resulting difference for each pair of values displayed separately. Those. in this way, as in the screenshot
, only I have more than 350 such pairs and I will manually get tired of counting all this, I need a way to automate this process. Tell me please

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

N

Noir, 2019-12-23
@PolarBearGG

=arrayformula(a1:A-B1:B)

Similar questions

A

alihang2018-12-14 00:58:40

How to compare two ranges and select the right data? 1Reply

S

SerJik_Z2022-02-18 15:10:36

Automatic deletion of files from all Google Drive folders using Google apps script? 1Reply

M

Mistev2022-03-08 15:12:58

How to paint the border of a merged cell using Google App Script? 1Reply

V

Villert2022-03-09 11:06:56

Google Sheets - how to script a new sheet with a specific name (date)? 1Reply

M

msnn2020-11-22 23:00:25

How can I find rows in a Google spreadsheet that match a condition, get their row numbers, and execute my script for each? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question