Finding Errors

[Gene Smolko]

Hello Everyone,

I have a sheet with a lot of data and I need to check it for a certain error. Basically I have a database that lists maintenance procedures with a line entry for each component that maintenance procedure is performed on. There are many columns in this database but there is one that I need to check for errors called task type. The task type for a maintenance procedure should be the same every time the maintenance procedure is listed regardless of component. If it's different, that's an error that needs corrected. I was thinking that a formula that could number task types for a maintenance procedure would work. For example, for a given maintenance procedure all task types should be the same, a formula that numbers them should all be "1," any twos, threes etc would be an error. If anyone has a different idea for a solution that would work, that's fine too.


I have created an example spreadsheet to illustrate what I am talking about, but I can figure out how to post it in the comment like I have seen others do. I tried a screenshot and a jpeg from that, but the software wants a URL for some annoying reason. I tried that by trying to insert a test image from the net, but that didn't work either!

 

[JoeMo]

Here are links for two alternative ways to post your example worksheet.

Excel Jeanie link: Excel Jeanie Html
MrExcel HTML Maker link: http://www.mrexcel.com/forum/2545970-post2.html

 

[Gene Smolko]

Much thanks, Joe, this should illustrate what I'm talking about.

Excel 2007
	A	B	C
1	Maint #	task type	formula
2	1212	Weekly	1
3	1212	Weekly	1
4	1212	Weekly	1
5	1212	Annual	2
6	1212	Weekly	1
7	1212	Weekly	1
8	1212	Monthly	3
9	1212	Weekly	1
10	1212	Weekly	1
11	3412	Monthly	1
12	3412	Weekly	2
13	3412	Monthly	1
14	3412	Monthly	1
15	3412	Monthly	1
16	3412	Monthly	1
17	7812	Annual	1
18	7812	Annual	1
19	7812	Annual	1
20	7812	Annual	1
21	7812	Annual	1
22	7812	Annual	1
Sheet3

 

[Gene Smolko]

In this example, Maint # 1212 has two errors, an Annual and a Monthly, Maint # 3412 has one error, Weekly. The actual spreadsheet has over two thousand entries, if one of the Maint # with an error comes up first, this formula would number all the other (maybe all correct) entries as other than one. This won't be a big deal, because I will be able to see that is what is going on. As I said earlier, other suggestions how to achieve this end are welcome too.

 

[StephenCrump]

Reposted: http://www.mrexcel.com/forum/excel-questions/858249-finding-error.html