Delete if

[moeng]

How do I remove “B” from a sublist but not if the only item is “B”

ex.

0 - A
B
1 - B
2 - C
B

to

0 - A
1 - B
2 - C

[MartinSpence]

Hi @moeng,

You could do something like this:

[moeng]

I dont think I have explained it correct.

This is the actual list.

What I need is to delete all the N/A but only when there are 2 items in the sublist.

So if a sublist is 1 and N/A it should be 1. And if its only N/A it should still only be N/A.

[lsmm]

@moeng perhaps you could use all true and filterbyboolmask?
Does this yield the desired result?

FORUM_ListDeleteIf.dyn (36.2 KB)

[moeng]

Exactly! Thank you.

[MartinSpence]

Ah, i misunderstood you, @moeng.

Here’s another way to solve it:

[Vikram_Subbaiah]

@moeng

How do I remove “B” from a sublist but not if the only item is “B”