Lawrence
10-14-2008, 11:50 AM
I have a formula that looks at the last 4 weeks (AY12) and returns the numbers of red ratings. However, as data gets added, I manually move the range for about 200 rows.
I am looking for a way to have it look up the last column filled in, then count the last 4 weeks from that column, and return the number of red ratings.
Something similar to the formula in cell AT12 (Thank you Bob for that) but looking at 4 columns instead of a single cell to capture the right data as people fill in the weeks, and I can't figure it out.
I am looking for a way to have it look up the last column filled in, then count the last 4 weeks from that column, and return the number of red ratings.
Something similar to the formula in cell AT12 (Thank you Bob for that) but looking at 4 columns instead of a single cell to capture the right data as people fill in the weeks, and I can't figure it out.