Thread: Lists
View Single Post
  #3   Report Post  
Ron
 
Posts: n/a
Default

Hi Biff,
Let me know if this is better.

A B C D E F
safeway 2
albertson 3 1
cooper 4 1
ov 5
1
iga 6
7-11 7 1
max 8 1
chevron 9
esso 10


FINAL RESULT
A B C
driver B max
driver C albertson 7-11
driver D cooper
driver E ov


"Biff" wrote:

Hi!

This (usually !) isn't too difficult but I would need to see a better
representation of your table:

A B C D E F
safeway 2
albertson 3 1
cooper 4 1
ov 5 1
iga 6
7-11 7 1
max 8 1
chevron 9
esso 10


Really can't figure that out!

Biff

"Ron" wrote in message
...
We have a situation here as follows;


For example in column A we have customers and column B-E are the four
routes
and
column F will have a vlue be greater than zero if they are taking
particular
item.
We want to summarize horizontally the customers who have a value greater
than zero in column F, by each driver.
So our net result will be a list for each driver that will contain only
the
customers on his route that have a value greater than zero in column F

Example:

A B C D E F
safeway 2
albertson 3 1
cooper 4 1
ov 5 1
iga 6
7-11 7 1
max 8 1
chevron 9
esso 10


FINAL RESULT

driver B max
driver C albertson 7-11
driver D cooper
driver E ov

Basically I would like a seperate horizontal list for each driver which
contains only the customers that are on his route (IE. have a value in the
column for that particular driver) and have a value in column F.