unique results

  1. R

    Duplicated lookup value needing unique return

    I have data that can be duplicated but will need to return specific serial numbers. In one tab i will have the following: <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Name Model Color PO ABC 123 White PO123 ABC 123 White PO123...
    • russborup
    • Thread
    • black duplicate values lookup po789 unique results xyz
    • Replies: 15
    • Forum: Excel Questions
  2. D

    Sumproduct picking off just one result in the lookup table for multiplication

    Hi, I have item numbers in "incremental net price" and in "Pricing" tab. I'm trying to pull the "Net price" from the "pricing tab" and multply the price by my quanity in the "incremental" tab. Problem is that the pricing tab has multiple results and it just so happens that the values are...
    • davodka
    • Thread
    • multiple criteria search sumproduct unique results
    • Replies: 0
    • Forum: Excel Questions

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