Get instant live Excel expert help to learn how to find invalid data in excel

“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

I need to pull out invalid emails from a list of emails. I have the list of invalid and valid emails in two separate excel files.
Solved by V. U. in 18 mins
I am trying to create a data validation rule excel that will only accept DATE values corresponding to the dates between 5/18/2018 and 5/20/2018. The problem is I keep getting an error telling me, "The date you entered for the Start Date is invalid." I have no clue why this error keeps holding me back. Please help???
Solved by V. H. in 24 mins
I need to write a formula in Excel that I just cant figure out...In the Years of Service column, modify the formulat to include the IFERROR function and display the message Invalid Hire Date if an error value occurs. Test the modified formula by changing the date in cell E2 from 7/10/2014 to 17/20/2014. Autofit the column
Solved by X. F. in 16 mins
I need to modify this formula: =IF(MONTH(E2)='Data Tables'!$B$4,"Yes","") I need to modify the formula to include the IFERROR function and display the message Invalid Hire Date if an error value occurs. I need to do so in the Work Anniversary column. I just did this same type of problem for another column, so I just do not know why I can't make this one work.
Solved by A. J. in 14 mins
can not turn my data into a pivot table... reference invalid
Solved by I. B. in 30 mins
I am trying to use the MATCH function to locate a number in an array, where I can only use one cell to answer a question to an assessment. For example, if I use =MATCH(5,{5,6,7},0), I can expect to return the number 1, as it is the first number in the array. But why is it that I cannot use formulae within the brace parentheses? It gets marked as invalid and I have zero guidance on how to fix this.
Solved by V. Q. in 22 mins
Hi, How do I correct this formula? I have tried various ways and it's not working. I think it may be invalid :) =SUM(SUMIFS('MF Customer Level'!$T$2:$T$11243,'MF Customer Level'!$B$2:$B$11243,'Detailed Analy'!J$7,'MF Customer Level'!$J$2:$J$11243,'Detailed Analy'!$A8))&(SUMIFS('Usage Customer Level'!$K$2:$K$4566,'Usage Customer Level'!$B$2:$B$4566,'Detailed Analy'!J$7,'Usage Customer Level'!$C$2:$C$4566,'Detailed Analy'!$A8)) Thanks
Solved by D. J. in 30 mins
iferror with a existing vlookup function that results in a Invalid Staff ID text
Solved by S. C. in 15 mins
Having problem with data graph validation, comes up with an invalid count.
Solved by T. S. in 26 mins
VBA HELP (I already have done the fill color to yellow I can not figure out the next steps Using VBA, in column D of the worksheet, enter “Invalid Part Number” for a row that does not have a valid part number (one that begins with a letter). Change the Fill color to yellow. Next, part numbers that are even numbers are ones the firm produces itself, while ones that are odd numbers they purchase from an external source. Again, using VBA, for the valid part numbers display in column D, “Ours” for the ones we produce and “Purchase” for the ones we get from external sources.
Solved by B. J. in 15 mins