As per the title, I have a sheet with book titles and the sales. I want to consolidate the data such that it shows me a list of the books and the DIFFERENCE between their sales numbers instead of calculating the sum. My sheet is a small sample. Actual sheet has 5000+ rows of data, though the book titles should only appear twice at most (sometimes once if it is a new book to the list).
Thanks!
Bookmarks