aquayle
11-07-2006, 09:44 AM
Difficult to explain, a picture of the workflow might do it!
Sheet1 contains unsorted info. sheet 2 contains look-up text relating to the numbers.
Sheet 3 should sum up the amount of money in all sector 1 (Companies from sheet2) and add the name as a string.... hmm.
Got it working so far, sorts the data on sheet 1, reads the text from sheet 2.
Now have:
Name ? Sector
abc 123 1
plc 111 1
ghy 333 2
xyz 199 2
how do I add all the ? (2nd column) where column 3 = 1 and then where column 3 =2 (and so on ...might go to 99999)
Ta - Andy
there should be a picture attached...
Sheet1 contains unsorted info. sheet 2 contains look-up text relating to the numbers.
Sheet 3 should sum up the amount of money in all sector 1 (Companies from sheet2) and add the name as a string.... hmm.
Got it working so far, sorts the data on sheet 1, reads the text from sheet 2.
Now have:
Name ? Sector
abc 123 1
plc 111 1
ghy 333 2
xyz 199 2
how do I add all the ? (2nd column) where column 3 = 1 and then where column 3 =2 (and so on ...might go to 99999)
Ta - Andy
there should be a picture attached...