jmcquillen
New Member
- Joined
- Jul 9, 2014
- Messages
- 1
I want to take an existing spreadsheet and do the following. If the values of two selected columns are equal take the value of another column for those rows and add those values together..reformat the sheet with a single row of all the values since they will all be equal then and use the added value for the column that was added.
example if the names in column 1 are equal and the date of service in column 6 are equal add the amount due( column 8) for those rows and produce one row with the values of all the other columns.
example if the names in column 1 are equal and the date of service in column 6 are equal add the amount due( column 8) for those rows and produce one row with the values of all the other columns.