small array count

  1. D

    Find lowest value with conditions

    Hi all, I am trying to find the way to obtain the minimum value from a range, with some conditions. So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...
  2. C

    INDEX & MATCH with COUNTA

    Hi all I've got a formula which is designed to look at a target value and match all the customers who have that target value. It works perfectly up to a certain point, whereby it returns incorrect values. By this I mean that it returns a match for each customer in the database (when it should...
  3. R

    Make Index and Match Accurate

    I have two sheets , one is for repaired car and another one is for returned car so I am trying to create an index formula that returns the returned car's brand name , Mechanic name and the problem but the information isn't accurate Note: there is only one car per brand name , which means if...
  4. K

    Excel 2013 Hyperlinking index array

    Hello, I am having an issue with Excel. I got an array-index formula on one sheet (SearchSheet) that returns values from another sheet (DataSheet) based on date or name searches-inputs. So if I enter 15/5/2015 it will return all the values from my datasheet, whose dates are the same or the...
  5. GerryZ

    Extract a unique list of items with formula2

    Hi all!! you can se on the top table the data base on the bottom table i need to extract unique names based on the fruit criteria let me know tahnk you in advance!Excel...
  6. R

    Array - Index - iferror formula

    I have a list of football results <tbody> Stoke (cell K8) 0 (cell L8) 1 Aston Villa (cell K9) 1 0 West Brom (cell K10) 2 2 Sunderland (cell K11) 2 2 Stoke (cell K12) 0 1 Tottenham (cell K13) 1 0 Arsenal (cell K14) 2 1 Stoke (cell K15) 1 2 Man Utd (cell...
  7. A

    Index Arrays

    Hi, I am looking to create an index array. the conditions for the array are based on drop down menus. I want to have it that if the drop down menu has * in it, the array should calculate everything rather than a specific value. ={IF(ROWS(I$14:I14)>$H$7,""...
  8. J

    small function, but don't count blanks

    My data A1:a8 00 02 04 56 99 I am trying to make a small( function work that will not count blank cells my values in b1:f1 should be b1=00, c1=02, d1=04, e1=56, f1=99

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