Can you please help with formaula required to create a list from content of Column C, based on criteria set from Col A & Col B
Regards
And Thanks
Baj
Can you please help with formaula required to create a list from content of Column C, based on criteria set from Col A & Col B
Regards
And Thanks
Baj
Try this in I6 and copied down:
Formula:Please Login or Register to view this content.
Try this in I17 and copied down:
Formula:Please Login or Register to view this content.
Note these are array formulas and therefore need to be confirmed with Ctrl+Shift+Enter.
If you want to read up on how it all works, try this:
https://www.ablebits.com/office-addi...-values-excel/
BSB
Another variation...
=IFERROR(INDEX(C:C,SMALL(IF(($A$2:$A$33=$G$6)*($B$2:$B$33=$G$7),ROW($A$2:$A$33)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks