Thank you so much !!!
Guess I was looking at it so intently that the obvious was missed. Tried the revision and it works perfectly.
You guys are the best !!
Have a great weekend.
I am using the Countif formula to extract data from the first worksheet.
The cell contents will be either Assoc CTC, CTC or SR. CTC values and I am wanting to get a total of each one.
On the second worksheet, I am using the following formulas:
=COUNTIF(Results!F$3:F$70,"*" & "Assoc" & "*")...
Have a question about comparing worksheets in Excel 2010.
Here is a simple scenario.
Sheet 1 has 10 rows of data
Sheet 2 has the same 10 rows of data but there are two additional for a total of 12 rows.
Is there a formula in Excel that will compare the 2 worksheets and highlight the...