Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

retrieving last used Column with data in particular in row

  Asked By: Mahesh    Date: Jul 27    Category: MS Office    Views: 1286
  

hi to all...iam creating every month 3 columns(one is year target and cumtarget and monthly achivmnt....
i calculate april to march and also i consolidate every month consolidation of .

in april
ex:YT=120 CT=10(sum of YT/12)*1 MA=9

in May
YT=120 CT=20(sum of YT/12)*2 MA=10

in june
YT=120 CT=30(sum of YT/12)*3 MA=12

then iam creating year consolidation table same as YT CT MA :
i retrieving MA using sum of every month,bt CT was Increasing every month when i want to recent month of CT value only displayed in consolidation table so plz help me how can i consolidating.
im using excel worksheet

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on retrieving last used Column with data in particular in row Or get search suggestion and latest updates.




Tagged: