steps

Hi, I just discover Power Pivot and I'm happier than ever :-) My problem now is that I'm not able to add new data to the model. I've followed steps in this tutorial: https://www.youtube.com/watch?v=yel9PMxvOfc But I lose all the calculated fields I have in my data set: How can I fix this...

I am trying to sum a positive and a negative value to give a positive value i.e <colgroup><col><col span="3"></colgroup><tbody> Positive units Negative Units Total Units UK 3,722 -8,378 12,100 </tbody> Ideally this needs to be done automatically with no further manual steps...

Hi. I'm trying to just create a msgbox if there are any sheets hidden in the workbook. (This is part of a longer series of steps, so I want this prompt as a check.) Thanks.

Hi, I need to return a value in a cell based on 2 pieces of information/criteria being true. I have 3 job roles SrCTM CTM CTA I then have 5 possible values 1,2,3,4 or 5 in a second cell. I need the result in the final cell to be dependent on if (A1= Sr CTM and C2=1,2,3 etc) then it returns...

Hello all, Above is basically what my spreadsheet looks like but with a little more detail, but this is all I think I need to provide for a gist of what I am having a problem with. Basically what I am trying to do is the following: - For each ID number, search column C (status column) for the...

Hey there, guys! I'm struggling with a certain issue a bit. I need to calculate monthly bonuses in Excel in an automated way. Which basically means I need to answer the following question: "If we know minimum and maximum bonus amounts, starting target achievement, and step value, how much the...