“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=IF(DATE(2019, 1, 1) > TODAY(), 999, IF(J2 > DATE(2019, 1, 1), 999, COUNTIFS('Data Feed'!E:E, 'Data Feed'!E2, J:J, > J2, J:J, <= DATE(2019, 1, 1)))) Giving formula parse error

Solved by F. B. in 20 mins

I need to write a formula to parse the data in the classification and semester columns of the given data

Solved by E. D. in 21 mins

I need a formula to parse the data, I have already completed parsing most data but now am struggling for the last two columns of data, classification and semester.

Solved by C. A. in 26 mins

Need to parse the data without using excel commands and by only using formula (=MID, =LEFT, =RIGHT, =LEN). I only have the classification and semester columns left, but I'm struggling to write the right formula to do so.

Solved by M. Q. in 17 mins

How do I create a formula for a column to automatically parse data in a certain way (rather than manually having to redo it whenever I add a new entry to the column)?

Solved by S. A. in 23 mins