Nested if's or creating a fnSWITCH function

akephart

New member
Joined
Oct 12, 2016
Messages
12
Reaction score
0
Points
1
Location
Nanaimo
Excel Version(s)
365
Hi,
I'm wondering if it is more efficient to create a column with a nested if statement or a Switch function that is built similar to the one in the guide - M is for (Data) Monkey. My data is a bank file. I have spent a day looking for ways to split a description column that contains valuable info for categorizing types of transactions. I found creating a Conditional column works the best but I have 64 possible tests. It seems a little cumbersome to write and manage.
 
Back
Top