BIG Question with text and number values
Posted by Nick on December 03, 2001 3:12 PM
I have a number of excel worksheet that have 7 columns. The first 5 have names in them the 6th has a time value stored in time format and the 7th has a number plus or minus. So the third row would look like this (columns are seperated by commas). Name1, Name2, Name3, Name4, Name5, 5:02, -1. I have about 20 rows of this data and I would like to take each of the combinations and sum the time and number columns. Is their anyway to have Excel look a row and make sure the combination of names is the same and then have it add the sixth column? I know this was probably poorly explained. I can send the file if anyone wants to give this one a shot. It would be a huge help.