My dataset comes from a Google formular.
I will have 2 different entries with the same names.
The data input in the different columns will increase.
What I want to do now is automatically subtract the data from the same columns between the 2 rows with the same names in column A.
I only could get the sum function to work like that, but I need the minus function.
=query(A:B, "select A, sum(B) group by A")
This one works for the sum, but I need to subtract the first entry from the 2nd one.
I would really appreciate some help.
The query function is needed, because that's not the only thing I want to do.