This array formula works just fine when looking at cols B to F, but when I insert an additional col G, (B to G) it fails and gives #Value! error
=INDIRECT(TEXT(MIN(IF(($B$5:$G$500<>"")*(COUNTIF($H$4:H4,$B$5:$G$500)=0),ROW($5:$500)*100+COLUMN($B:$G),7^8)),"R0C00"),)&""
Any help gratefully received.
thanks
Often an array entered formula will produce a value error if it isn't activated using Ctrl, Shift and Enter.
I tested the formula and as best I understand, find/display the first value in the range B5:G500 reading right to left and top to bottom, it worked as I would expect.
It may be easier to help if you upload a sample file that illustrates the problem you are encountering (instructions are in the banner at the top of the page).
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks