non-unique values

  1. C

    Get a result based on conditions in several columns

    Trying to solve this. What I want: Formula in column D saying Yes or No based on following rules: If a cell in Col. B equals "Bob", then look everywhere in Col. A with the same content, for ex "A1", and if in Col C there is "17", then put "Yes" in D on same row as Bob. Otherwise, "No", as...
  2. P

    Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.

    Hi - I'm trying to build an output model similar to the one shown below, please see the following explanations to help answer: Main Issues: (I) When a unique ID has multiple transaction with a selected product code input before meeting the selected threshold amount. (II) Once threshold is met...
  3. H

    A slicer to chosse among multiple filters

    Howdy there, I spent most of my afternoon trying to resolve this problem. I read a lot on the Internet, but much didn't make sense to me. Let me expose you my problem. I have data that look like this : I defined clusters in two formats (because I don't know which format to use !). The trick...
  4. X

    If Statement search range of non-unique values

    Hey Guys, I have a cell range of non-unique values and tickers to the cell on the right. eg: A B 1 1 AAPL 2 1 MSFT 3 1 (you get the rest) 4 1 5 2 6 2 7 2 8 3 9 3 10 4 I want to create a formula that can search column...

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
Back
Top