Excel help

Soldato
Joined
29 Jul 2004
Posts
6,657
Location
Esher
Hi Everybody,

I have a table with months on the top and location codes on the left.

I need to set a formula up so it'll check the values in the columns.

Location Apr-11 May-11 Jun-11 Jul-11 Check
0001 100 110 120 120
0002 200 210 220 230

Ok so at the end of this month I will be pasting in values for the July column, I need to set up a formula in the Check column that will compare the Previous month column value with the current month value. And if they are the same I need to have the word "Check" appear.

So every month I don't want to be changing the formula manually, I want the date to automatically update (with the Windows system) and perform the next check.


E.g on the 31st October, the formula should compare the value in the September column with the value in the October column. And if they are the same then I want the word Check to appear


I hope that makes sense to everyone!

Ahhh the columns aren't lining up :(
 
I can't correlate what you've said about the system date with what you've said about the months along the top, in that why do you even need to bother with the actual date if you're looking at the entire month's value?

Anyway this is how I'll start things off based on what you've said:

lKwRQ.jpg
 
Back
Top Bottom