True values in another column

[irfman]

Hi:

I am trying to write a formula such that the only numbers corresponding with the "True" status are populated in another column as per the example below in the result column.

Status Number Result
TRUE 1 1
TRUE 3 3
FALSE 5 7
TRUE 7
FALSE 9

Appreciare any assistance

[ChemistB]

Try

Please Login or Register  to view this content.

[TMS]

In the latest versions of Excel, you can use:

Please Login or Register  to view this content.

For any version of Excel, you can use the Array Formula:

Please Login or Register  to view this content.

committed with Ctrl-Shift-Enter rather than just Enter and copied down.

Or, as it's TRUE values, you can shorten it to:

Please Login or Register  to view this content.

committed with Ctrl-Shift-Enter rather than just Enter and copied down.

If you wanted the FALSE entries, you would need to specify FALSE:

Please Login or Register  to view this content.

committed with Ctrl-Shift-Enter rather than just Enter and copied down.


See: https://www.youtube.com/watch?v=Ohkom0GfF08