G
galin
Hi,
I have a spreadsheet with two columns. Here is an example:
Toronto Missisauga
Toronto North York
Toronto East York
Here I want the third column to assign 1 in all combinations wher
Toronto is first. Now further down I will have
Missisauga Toronto
Missisauga Brampton
Missisauga Etobikoke
I would like Missisauga - Toronto to remain 1 in hte third column, bu
for the other two a new number to be assigned.
I hope this is clear. The process shouldn't be very complicated. It ca
do it one at the time so I can pick thenumbers to be assigned.
Thank yo
I have a spreadsheet with two columns. Here is an example:
Toronto Missisauga
Toronto North York
Toronto East York
Here I want the third column to assign 1 in all combinations wher
Toronto is first. Now further down I will have
Missisauga Toronto
Missisauga Brampton
Missisauga Etobikoke
I would like Missisauga - Toronto to remain 1 in hte third column, bu
for the other two a new number to be assigned.
I hope this is clear. The process shouldn't be very complicated. It ca
do it one at the time so I can pick thenumbers to be assigned.
Thank yo