Text search / retrival functions
Posted by Tim on November 01, 2001 8:10 AM
I have some statistical samples that consist of a column of (non-unique) text references and a column of numbers. What I would like to do is produce a summary at the top of the sheet of a single line for each text reference - preferably without re-ordering the data (sorry - obscure reasons for that). So say the raw data looks like:
and I want a summary like
abc123 5.7 (total of all the abc123 rows)
in real life I have just a little more data than that !
Any help much appreciated - I've tried combinations of array formulas and Min/Max type functions but don't seem to get anywhere as the references are text rather than numbers.