ian

Hi Guys I have the below data , i am trying to do a formula that would count the number of "open" status the Manager "roy" has. i tried a countifs but could get it right can any one provide any help? <tbody> A B C D 1 name manager id status 2 james roy 1 open 3 jack roy 1 closed 4...

Hi I am using a vlookup formula but instead of displaying the result say "ABB" I'd like to return "ABBREVIATION" instead? Is it possible or do I need a different formula, index,match? Thanks Ian

i have been working on an efficient way to get this excel data to transpose in the way that appears underneath it, at the bottom of the post the way i do involves several steps and its painfully slow, and the data set can be large, and as i need to do it 3 times a week, I'm hoping for a faster...

Hi, I am trying to get a result from two variables. Variable 1 is a name, say Ian. Variable two is a number (number of sales). If Ian hits a number of sales, then a certain commission value will be returned. If Ian hits 999 sales, he gets a different commission to 1000 - there are various...

wasn't sure what to title this. If i have data as such <tbody> Name Score Ian 1 Ian 2 Ian 3 Ian 4 James 1 James 2 James 3 James 4 John 1 </tbody> What I want to see is this <tbody> Name Score 1 Score 2 Score 3 Score 4 Score 5 Ian 1 2 3 4 James 1 2 3 4 5 John 1...