no array

  1. L

    MAXIFS Substitute, no Array to be used in an INDEX function

    Hi everyone, I just finished writing a decent TO-DO list that was to be used at the office while working on my home computer. Unfortunately my office doesn't have working MAXIFS functions with their version of Excel... I've looked up a few alternatives but I don't think an array will work...
  2. F

    INDEX MATCH MAX IF Function without the use of an array

    Can someone please help me with the following case: A spreadsheet containing dates and values (multiple times same date is occuring): A(date) B (Silo) C (lab value) 12.03.2018 15 30 12.03.2018...
  3. N

    Vlookup for max value without using an array

    <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> a 2 g 4 q 6 f 7 a 4 t 6 </tbody> From the data set above I would want to vlookup for "a" and return the value 4 instead of 2. I believe this post is a good starting point...
  4. C

    Countif without CSE, unpredictable behavior

    I've stumbled upon a feature of Excel which I do not understand. In the table below I've tried to strip down my issue to its bare essence: X COUNTIF(A1,A3:A4) evaluates to: 0 F9: {1,0} evaluates to: 1 INDEX(COUNTIF(A1,A3:A4),1,1) evaluates to: 1 COUNTIF(A1,A3:A4) evaluates to: 0...

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