I am trying to get 3 pieces of information from an excel file.
I need only the information from D, E, and F
(CONDITION) The only way to tell the difference is if column E ends with a BA or F contains numbers ('aka the last line)
I have tried the filter data table option but not sure if I am doing it right.
Could someone give me a step by step sequence on how I would be able to only get the text from D, E and F of the bottom line using the conditions I explained and display it in 3 seperate 'Message Box’s