markpem
05-15-2016, 02:38 AM
Hello
Sorry for the confusing title, I'm not sure how to put it into words. I have done a table hopefully explaining it all. I will need to count a range as every week the date gets added between the current status and the last week's date (Current status will always be the last most furthest column on the spreadsheet)
I need to count the amount of weeks a piece of text has appeared since it last changed. I don't mind if it's done over a forumula or VBA. If it is VBA (which I'm quite happy with) I guess a range would need as the columns are always expanding. It could always be something like Column B to LastUsedColumn or something?
Thankyou
Client
18/04/2015
25/04/2015
02/05/2015
09/05/2015
Current Status
Mr Jones
Considering Options
Considering Options
Considering Options
Considering Options
Considering Options 4w
Mrs Smith
Considering Options
Considering Options
Set Up Purchase
Declined
Declined 1w
Mr Patel
Considering Options
Set Up Purchase
Set Up Purchase
Bought
Bought 1w
Mr Fernandez
Considering Options
Declined
Declined
Declined
Declined 3w
Sorry for the confusing title, I'm not sure how to put it into words. I have done a table hopefully explaining it all. I will need to count a range as every week the date gets added between the current status and the last week's date (Current status will always be the last most furthest column on the spreadsheet)
I need to count the amount of weeks a piece of text has appeared since it last changed. I don't mind if it's done over a forumula or VBA. If it is VBA (which I'm quite happy with) I guess a range would need as the columns are always expanding. It could always be something like Column B to LastUsedColumn or something?
Thankyou
Client
18/04/2015
25/04/2015
02/05/2015
09/05/2015
Current Status
Mr Jones
Considering Options
Considering Options
Considering Options
Considering Options
Considering Options 4w
Mrs Smith
Considering Options
Considering Options
Set Up Purchase
Declined
Declined 1w
Mr Patel
Considering Options
Set Up Purchase
Set Up Purchase
Bought
Bought 1w
Mr Fernandez
Considering Options
Declined
Declined
Declined
Declined 3w