J
Jman
1st. I want to be able to know what day a client comes to see me the most and
2nd.. i want that client to automatically be trasfered to a different sheet
under "mon, tues, wed, fri, sat, column, depending what's the most frequent
day the client comes in. If the client come a total of 4 times ,,, 2 days
wed, 2 days thur. That clinent does not need to be transfered over.. only
when he/she comes in another wed, then the client can be trasfered under Wed
column.
Here is my set up .
(On sheet 1)
Clients Names
Column A1 to A 2000
Client Dates
Column B1 to B 2000
8/22/2008
---------------------------------------------------------------------------
(On sheet 2)
Column Names (A to F ) I have ( mon, tue, wed, thurs, fri, sat.)
This is where i need the clients to be automatically transfered accordingly
to the most frequent day they came in.
-------------------------------------------------------------------------------
Here is an example (all these days happen to be tuesday) therefore since
this client prefers only to come on tuesday he should be automatically
transfered to sheet 2 under the "tuesday" column. And so on for every
client that under that column
John Smith 8-22-08
John Smith 8-1-08
John Smith 8-29-08
2nd.. i want that client to automatically be trasfered to a different sheet
under "mon, tues, wed, fri, sat, column, depending what's the most frequent
day the client comes in. If the client come a total of 4 times ,,, 2 days
wed, 2 days thur. That clinent does not need to be transfered over.. only
when he/she comes in another wed, then the client can be trasfered under Wed
column.
Here is my set up .
(On sheet 1)
Clients Names
Column A1 to A 2000
Client Dates
Column B1 to B 2000
8/22/2008
---------------------------------------------------------------------------
(On sheet 2)
Column Names (A to F ) I have ( mon, tue, wed, thurs, fri, sat.)
This is where i need the clients to be automatically transfered accordingly
to the most frequent day they came in.
-------------------------------------------------------------------------------
Here is an example (all these days happen to be tuesday) therefore since
this client prefers only to come on tuesday he should be automatically
transfered to sheet 2 under the "tuesday" column. And so on for every
client that under that column
John Smith 8-22-08
John Smith 8-1-08
John Smith 8-29-08