awhile

  1. K

    old index match formula not doing what's needed

    I just found out an array index/match I wrote awhile back isn't doing what I needed. the formula is =IFERROR(INDEX(General.Lists!AV13:AV338, SMALL(IF(COUNTIF($CC$14,General.Lists!AN13:AN338)*COUNTIF($CC$15,General.Lists!S13:S338)*COUNTIF($CC$16,General.Lists!Z13:Z338)...
  2. A

    Is there a way to more quickly navigate the Fill Color and Font Color pickers using the keyboard, besides using the arrow keys, which takes awhile?

    Is there a way to more quickly navigate the Fill Color and Font Color pickers using the keyboard, besides using the arrow keys, which takes awhile? For example, it would be great to be able to jump from one end of the picker to another, both up/down and left/right. In case it's helpful, I'm...
  3. J

    Array Formula for 2nd occurrence

    Hello, I have the following formula: =IFERROR(INDEX(Matrix!A4:A98,MATCH("DNA",Matrix!F4:F98,0)),"") This formula works perfectly and searches the array for DNA and returns the appropriate cell value. However I need a separate formula to search for 2nd,occurrence and not return the value that...

Watch MrExcel Video

This Week's Hot Topics

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
Top