Get instant live expert help on I need help with formula parse error

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=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