Filter and update the new column with data

[Lakshraj]

Hello,

I am currently doing below step like filtering out each criteria and updating the text/comment in new column. Is there any easy way to do it in one go ?

Step : Filter in Merge cell (eg. Filter for "Income" and update the new column with " Verified". then Filter for "Expense" and update the same new column with "Sent out"). 

[ChrisTX]

Try the Find Replace tool

[AMansour · Accepted solution]

hello @Lakshraj 

I'll use one formula avec 

IF 
Contains([Merged column], 'interest recevable') 
THEN 'Interest recevable' 
ELSEif Contains([Merged column], 'interest payable')
THEN 'Interest Payable'
Elseif Contains([Merged column], 'FEES AND COMMS PYBL')
THEN 'Fees and Commissions Payable'
Else ''
Endif

let me know if that what you are looking for.

cheers

Amr