ian

  1. I

    Count if /Count ifs help

    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...
  2. I

    Help required using vlookup

    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
  3. H

    transpose data query

    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...
  4. N

    Return Value based on two variables and number range

    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...
  5. R

    Pivot trouble

    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...

Some videos you may like

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top