comparing two cells in Excel

subhash

Member
Hi Team,

I have a query, I have a excel sheet with multiple columns each column with names 2010,2011,2012....
Each column shows the respective percentages according to the years, say

2010 2011
91.36 86.7
90.03 93.4
78.9 88.7
98 98.06
87.5 99.04

i want to compare the two column cells , say we had a result of 87.5 in May(2010), then for the next year i.e MAy(2011) it is 99.04
then the bot should say "we increase to 99.04% this month. if it is low then the bot should say "we decreased 86.7% this month"
the result i must send through mail.
please help me to resolve this

Kind regards
 

Sukesh Kumaru

Active Member
Hello,

For this you can do in both ways:
1) Fetch those data to collections and perform operations and compare it (before value < after value like 2010 value is < 2011 then BOT will say increased and specify that year value).
2) Use Data - OLEDB VBO and fire-up a SQL Query for this comparison operation.

Good Luck.
 

subhash

Member
Hello,

For this you can do in both ways:
1) Fetch those data to collections and perform operations and compare it (before value < after value like 2010 value is < 2011 then BOT will say increased and specify that year value).
2) Use Data - OLEDB VBO and fire-up a SQL Query for this comparison operation.

Good Luck.
Thank you Buddy:cool:
 
Top