Good morning,
I have this array formula that returns values from one table that contains blank rows (named CRSdata) into a new one without blanks:
Formula:
Please Login or Register to view this content.
I need to enhance it to skip not only the blank rows, but also the rows in which the values in column G are TRUE.
I will be eternally grateful to anyone able to solve this conundrum!
I have included two conditions to generate the final result.
Please try this logic.
Last edited by ramananhrm; 09-12-2013 at 05:29 AM.
Please click 'Add reputation', if my answer helped you.
Thank you ramananhrm, I think this is correct, however it only works with single column tables..how would you have to modify the formula to make it work for a table with more than one column (as in the attached file)?
puckman.xlsx
Sorry if this sounds dumb but I'm not the one who created that formula and I'm struggling a bit to get my head around it and make it work for my purpose!
You can modify the condition according to your desired result. (Marked in red)
=IFERROR(INDEX($B$2:$B$33,SMALL(IF($A$2:$A$33&$B$2:$B$33<>"",IF(OR($A$2:$A$33<>"West",$B$2:$B$33<>"West",),ROW($B$2:$B$33)-ROW($B$2)+1)),ROWS(D$2:D2))),"")
(Ctrl+Shift+Enter is required)
Last edited by ramananhrm; 09-12-2013 at 07:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks