Hi,
my column headings are dates which run on a weekly basis..... so cell b1 is 4th October, cell c1 is 11th October etc, increasing by 7 days.......
in Column A is the name of the member. so cell a2= person 1; cell a3 = person2 etc
The data ie cells b2....CA20000 (and will be increasing) is full of whole numbers. The data is how many times they logged onto our website.
The problem: is it possible to tell me going through row by row (member by member) when was the last time they logged on? Of course there could be breaks when they have logged on.... for example:
Person1: Week 1= 45; week 2= 90; week 3= 0; week 4=50; week 5=0
Person 2: week 1=2; week 2=0; week 3=0; week 4=0, week 5=0.
So in this example, the last time this person 1 logged in was week 5
And for person 2 would be week 2.
I think its to do with lookup's but it is very complicated, and would appreciate any advice or scripts that can help.
Regards
Jay
my column headings are dates which run on a weekly basis..... so cell b1 is 4th October, cell c1 is 11th October etc, increasing by 7 days.......
in Column A is the name of the member. so cell a2= person 1; cell a3 = person2 etc
The data ie cells b2....CA20000 (and will be increasing) is full of whole numbers. The data is how many times they logged onto our website.
The problem: is it possible to tell me going through row by row (member by member) when was the last time they logged on? Of course there could be breaks when they have logged on.... for example:
Person1: Week 1= 45; week 2= 90; week 3= 0; week 4=50; week 5=0
Person 2: week 1=2; week 2=0; week 3=0; week 4=0, week 5=0.
So in this example, the last time this person 1 logged in was week 5
And for person 2 would be week 2.
I think its to do with lookup's but it is very complicated, and would appreciate any advice or scripts that can help.
Regards
Jay