Hi All Need some help on formula in filtering the data. I have below data and wanted to filter based on below two condition First: If column B/S contain "B or S" then exclude the row None Second: If Column B/S does not contain "B or S" then only None row should come in output. Account B/S Short Sale Ind Trade Date Settle Date Posting Date Quantity 1111 B 0 05/17/2026 05/17/2026 05/17/2026 50,000,000 2222 S 0 05/17/2026 05/17/2026 05/17/2026 113,755 4444 S 0 05/17/2026 05/17/2026 05/17/2026 133,000 5555 B 0 05/17/2026 05/17/2026 05/17/2026 54,000 None Thanks in advance

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter with Multi Column condition

bubblyjai1982

Hi All

Need some help on formula in filtering the data.

I have below data and wanted to filter based on below two condition

First: If column B/S contain "B or S" then exclude the row None

Second: If Column B/S does not contain "B or S" then only None row should come in output.

Account	B/S	Short Sale Ind	Trade Date	Settle Date	Posting Date	Quantity
1111	B	0	05/17/2026	05/17/2026	05/17/2026	50,000,000
2222	S	0	05/17/2026	05/17/2026	05/17/2026	113,755
4444	S	0	05/17/2026	05/17/2026	05/17/2026	133,000
5555	B	0	05/17/2026	05/17/2026	05/17/2026	54,000
None

Thanks in advance

Workflow

Accepted answers

Qiu

@bubblyjai1982
We can first use a Flag (0 or 1) parameter to Flag If column B/S contain "B or S" then take the maximum value of Flag. A trick here is to make the switch for output automatically as shown below.