I have tick marks in Col I and branches in Col A
I am looking for a formula to extract all the branches not ticked
I have tried to use advanced filter but not is being extracted
It would be appreciated if someone could kindly assist me
I have tick marks in Col I and branches in Col A
I am looking for a formula to extract all the branches not ticked
I have tried to use advanced filter but not is being extracted
It would be appreciated if someone could kindly assist me
Please try at A13
=IFERROR(INDEX($A$1:$A$7,AGGREGATE(15,6,ROW($A$2:$A$7)/($I$2:$I$7=""),ROWS(A$13:A13))),"")
Try this ARRAY formula...
=IFERROR(INDEX($A:$A,SMALL(IF($I$2:$I$7="",ROW($A$2:$A$7)),ROWS($A$1:A1))),"")
**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Then copy down as needed.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
A13
Drag downPlease Login or Register to view this content.
Quang PT
thanks for the help guys
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks