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

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