Morning all,
I’ve been playing with this all night and not got to far, I’m trying to find a way in excel to compare two columns and then if there is a match then add it to a running total.
So for example column a has about 3500 cells, they need to be compared to all the cells in column b (about 80), then if there is a match then add an the contents of column c to a total and display it.
If this was PHP, C, JAVA, etc… then I could do it but I’m having issues with excel, its completely foreign to me and I know when to admit I’m beaten.
And before anyone says it, its not home work (I’m a bit old for that), its the logs from a phone system that I need to analyse.
Cheers,
I’ve been playing with this all night and not got to far, I’m trying to find a way in excel to compare two columns and then if there is a match then add it to a running total.
So for example column a has about 3500 cells, they need to be compared to all the cells in column b (about 80), then if there is a match then add an the contents of column c to a total and display it.
If this was PHP, C, JAVA, etc… then I could do it but I’m having issues with excel, its completely foreign to me and I know when to admit I’m beaten.
And before anyone says it, its not home work (I’m a bit old for that), its the logs from a phone system that I need to analyse.
Cheers,