I have data is three cells (M15, M27 & M39). They may have various text in them, but only one cell will be either "Overtime" or "PointinTime".
In cell M44 I would like to display the data from whatever cell contains the either the word Overtime or PointInTime.
I am unsure how to do this. I...