multiple text criteria

  1. A

    Search column cells for multiple criteria

    I am trying to search for multiple text fields in column A and once they are all found in one cell, return the value of the next cell in column B. Example: I want to search for 10#, TALL, BOWL, and BLUE in column A and once all of them are found in one cell, return the Product No that is in...
  2. J

    HELP. How to find matching dates in 2 different columns, then count multiple texts within another column totaling in another column

    Long story short for you all : There has been an update in my system at work and the beautiful data tracker that I was given to take over is not able to accurately display information anymore due to word modifications. I'm a newbie to excel too. Logic: <tbody> If column J (full of dates)...
  3. N

    Ranking Text using Multiple Text Criteria

    Hello, I have data that I would like to assign a number (or rank) for each group within a division. Data is not grouped together, and I do not want to sort data. I am seeking the below result, but I cannot figure out what formula to use. Please help! Table starting at A1. <tbody> division...
  4. M

    Weighted average w/ multiple text criteria excel 2010

    hi i'm looking to get a weighted average from a table (in 'database format') for specific rows. i'm working on excel 2010. below might help to convey the idea of what i am trying to achieve, although the actual solution will probably differ considerably...

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