Exclusion of value using SMALL IF

[diamends]

I am currently using SMALL(IF( and this is a function I am not super familiar with. I would like to exclude a return if a cell contains a certain value and I think I need an embedded IF somewhere, but am not sure where to put it. See below:


This is my current function and I would like to not return values if tab XRD has the value of WS in column B.

=IFERROR(INDEX(XRD!$C$2:$C$4031, SMALL(IF($A345=XRD!$B$2:$B$10000, ROW(XRD!$B$2:$B$10000)-MIN(ROW(XRD!$B$2:$B$10000))+1, ""), COLUMNS($A$1:C344))),"")


I believe I need something like this, but am just a bit lost at the moment.

=IFERROR(INDEX(XRD!$C$2:$C$4031, SMALL(IF($A345=XRD!$B$2:$B$10000(IF(XRD!$B$2:$B10000='WS',"",XRD!$B$2:$B10000), ROW(XRD!$B$2:$B$10000)-MIN(ROW(XRD!$B$2:$B$10000))+1, ""), COLUMNS($A$1:C344))),"")

I have another place I could exclude also, where I would just need to ignore WS in column Day 1 XRD. See Below:

=IFERROR(INDEX(XRD!$I$2:$I$1000055,MATCH(1,(XRD!$B$2:$B$1000055=[@Board])*(XRD!$C$2:$C$1000055=[@[Day 1 XRD]]),0)),"")

Any help would be appreciated.

 

[Fluff]

Hi & welcome to MrExcel.

Can you post some sample data along with expected results. Your criteria are not very clear.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[diamends]

Hi & welcome to MrExcel.

Can you post some sample data along with expected results. Your criteria are not very clear.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

So it does seem as though my organization has much of this functionality blocked on xl2bb. I understand if you are not able to give assistance because of this.

 

[Fluff]

Did you manage to install the add-in?

 

[diamends]

Did you manage to install the add-in?

Yes, but this is all that is available. When selecting a section of my sheet, mini sheet remains greyed out.

 

[Fluff]

Ok, have a look here XL2BB Icons greyed out