Need help with a formula. Here’s what I’d like to do… imagine in one cell, comma separated values. Like..
The next cell has say something like
I want one column of an excel sheet to add the numbers, and another column to count the +s. So – two values in one cell. So, the column would read 9 (adding the numbers), and 1 (indicating number of pluses). This would be super simple to just separate those two csv things into two cells, but that’s not how my data is.
By: Daniel Cook