• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please help me for excel formula/pivot table for our Dashboard.

S

sampath

Member
Hello,

I have create the employee tracking sheet. In this sheet, I need following requirement for this dashboard.

1. If put category item in A1 cell and put Complexity item in B1 cell, C1 need formula for respective number.

Note : that category, Complexity and numbers are mentioned in attached excel.
 

Attachments

  • Category, Complexity and number.xlsx
    10.2 KB · Views: 1
Hello Ratan Bhushan,

Thanks for your reply, I have attached the sample file with this forum.

In this example. Input area is A & B column. C is Output column(Needed formula column)

For Example, If A2 & B2 is E & C respectively, C2 will come 40.
 

Attachments

  • Examples.xlsx
    8.7 KB · Views: 1
You must log in or register to reply here.
Back
Top