Hello,

Thanks in advance for the help. I have a worksheet that lists account names
in column A. In column B I have sales from January, column C is sales from
February, Column D is data from March€¦ all the way through to December.

I need help calculating variances on the months that double.

For example:
Jan $10
Feb $15 (no variance calculated)
March $15 (no variance calculated)
April $20 (the variance here would be $10 because April doubled January)
May $40 (the variance here would be $20 because May doubled April)
June $45 (no variance calculated)
July $10 (no variance calculated)
Aug $75 (no variance calculated €“ did not double high month)
Sep $135 (the variance here is $95, because it doubled May)
Oct $150 (no variance calculated)
Nov $250 (no variance calculated)
Dec $270 (the variance here is $135, because it doubled September)

I know this is complex but as I watch the board Im confident that someone
can help me.

Thanks
Jim