I am running SQL reports to bring up clients that stop using my servic
after 1 month. 600 come up. I then contact them all and then usuall
45% come back. I have no way of finding which of my 600 make up tha
45%. All this is being tracked in excel. This would be of use i
determing the value of this excercise.

example with 10 accounts:

109
103
296
968
124
612
650
972
344
535

4 come back

103
296
968
972

what function filters out the ones that came back. Remeber this i
being run on 600+ accounts.

I love this forum,

luk

--
Message posted from http://www.ExcelForum.com

Guessing here since you give little to go on, but perhaps

http://cpearson.com/excel/duplicat.htm

can be useful.

In article <(E-Mail Removed)>,
moneyline <<(E-Mail Removed)>> wrote:

> I am running SQL reports to bring up clients that stop using my service
> after 1 month. 600 come up. I then contact them all and then usually
> 45% come back. I have no way of finding which of my 600 make up that
> 45%. All this is being tracked in excel. This would be of use in
> determing the value of this excercise.
>
> example with 10 accounts:
>
> 109
> 103
> 296
> 968
> 124
> 612
> 650
> 972
> 344
> 535
>
> 4 come back
>
> 103
> 296
> 968
> 972
>
> what function filters out the ones that came back. Remeber this is
> being run on 600+ accounts.

that was a great article. Everything I could want

--
Message posted from http://www.ExcelForum.com