Скачать или смотреть IF, ISNUMBER, and SEARCH Functions to categorize long text-strings into standard categories

One of the biggest problem with 𝐍𝐨𝐭 𝐊𝐧𝐨𝐰𝐢𝐧𝐠 something is that 𝐖𝐞 𝐃𝐨𝐧'𝐭 𝐊𝐧𝐨𝐰 𝐖𝐡𝐚𝐭 𝐖𝐞 𝐃𝐨𝐧'𝐭 𝐊𝐧𝐨𝐰

Until I learned about this cool formula tip, I used to manually filter long text strings columns by searching for relevant 𝐊𝐞𝐲𝐬 and then pasting categorization values to the visible rows. Repeat this step for as many classifications as you would like to add, which was quite time consuming

Then, I learned about this awesome combination of 𝐈𝐅, 𝐈𝐒𝐍𝐔𝐌𝐁𝐄𝐑 and 𝐒𝐄𝐀𝐑𝐂𝐇 functions that now helps me achieve the same objective using a single formula (read as combination of formulas), isn't that cool?

Let me know how do you find this combination by commenting below 👇

Do 𝐋𝐢𝐤𝐞 and 𝐒𝐡𝐚𝐫𝐞 this video with your network

Do you want to hear about a particular topic from us? Let me know and do not forget to follow @Jawad Nagda and @Fin-Rizon

If interested in receiving guidelines related to 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬, do subscribe to our 𝐘𝐨𝐮𝐓𝐮𝐛𝐞 𝐂𝐡𝐚𝐧𝐧𝐞𝐥    / @financehorizon