-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
awhile
-
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)...- KDS14589
- Thread
- awhile formula info match matches
- Replies: 5
- Forum: Excel Questions
-
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...- alexcr
- Thread
- arrow awhile color keys takes
- Replies: 2
- Forum: Excel Questions
-
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...- jwehrly2000
- Thread
- array awhile fiddled formula returned
- Replies: 4
- Forum: Excel Questions
