multiple criteria search

I have a table as below. The goal is to extract only first two shop i.d.s from each country having the status either "Active" or "Completed" or "Discontinued". If there are no shops in the country with that status do not extract. If only one than extract only one. Finally the answer should be in...

https://docs.google.com/spreadsheets/d/16usEk9KrUYyuaZImKxybGZaiLzWUzk-qegXXrN5r7rc/edit?usp=sharing <bdo...

I am trying to return a value when searching multiple criteria including a date range. For example- Column A= Time of Error Column B= Description of Error Column C= Would like Return of Error Message 500 only during a certain time. A1 05/10/2016 12:00 B1- Customer Receives Error 500...

Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...

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

Dear All, I am trying to count the number of specific words contained in a specific cell. If my data were static, and the list of keywords was short, there are many solutions such as using multiple instances of the length function as proposed by @shg here. @njimack has proposed a very easy and...