mattstopel
New Member
- Joined
- Jun 27, 2018
- Messages
- 10
Hi All,
I am having a real frustration at the moment with one of my workbooks.
I have an array formula, nothing too complex that won't return any results.
In my previous version, V5, it works flawlessly, in V6, no good at all. Formula is the exact same between both worksheets. Named arrays are still the same also.
Formula is =IFERROR(INDEX(EntryID,LARGE(IF(Entryunit=$D$6,ROW(EntryID)),ROW(1:1))),"") and entered as CTRL+SHIRT+ENTER.
Any ideas accepted!!
TIA
I am having a real frustration at the moment with one of my workbooks.
I have an array formula, nothing too complex that won't return any results.
In my previous version, V5, it works flawlessly, in V6, no good at all. Formula is the exact same between both worksheets. Named arrays are still the same also.
Formula is =IFERROR(INDEX(EntryID,LARGE(IF(Entryunit=$D$6,ROW(EntryID)),ROW(1:1))),"") and entered as CTRL+SHIRT+ENTER.
Any ideas accepted!!
TIA