Posted by Sean on October 12, 2000 2:30 AM
I hope someone here can help me. I am new to Excel, and have very little experience in it, also due to time constraints I am unable to find a decent book.
My situation is this.
In column A I have lots of text values
In column B I have numbers (a time) that are related to each individual text.
I need to go through column A and for every different value I need to total their times. Say "Text£" appears in column A 4 times I need to total all 4 times, and then do the same with "Text$" every time it appears.
I then need to compare the values of all the times and return the text which has the highest associated time value.
I realise this is possible if you know what "Text" values can appear, but what if this is not known? Is there and VB code that can be used ?
Any suggestions on here or to my email would be GREATLY appreciated!!