Hi.

I'm pretty novice with Excel, and I'm trying to do a bit of a datamining project. I'm currently at a standstill.

I have about 250 lines worth of data that I extracted, and now I'm trying to count out certain trends among the data.

What I'm looking to do is a two step process.

I need to go through one column of data and count the instances of a certain value. Let's call it "A". Then I need to go through another column of data to find out if a certain value, we'll call it "B", appears in the cell adjacent. So basically I need to go down a list finding if the combination of A B appears in cells in columns D and E.

I think I got that across clearly.

Thanks in advance.