Auto-hiding rows with the same value

[bdavis87]

http://tinypic.com/r/149xo37/6
Above is a picture of my data set.

Hi All,

New member here. I am working with in Office 2008 (For Mac). I want to auto-hide some rows when two columns of criteria match. I will provide an example: Since A3 through A6 match, AND C3 through C6 match, I want to hide the rows 3 through 5, leaving only the ultimate row, 6 unhidden. Is this done easily?

Many thanks.

 

[bdavis87]

well i'll be damned - http://tinypic.com/r/35hqxbm/6

I can't hit F9 since I have a stupid Mac. But the picture above should mean the calculations are automated, right? I must not have it set up right - that's the only reason I can imagine it's not working..

 

[Andrew Poulsom]

Yes it seems to be AutoMatic. The equivalent of F9 is Cmd+=.

How many entries do you have for aol.com201100342550100? If it's only one I don't know why you aren't getting TRUE. What do these return?

=COUNTIF(H$2:H2,H2)

=COUNTIF(H:H,H2)

 

[bdavis87]

I figured out the problem - sometimes the same person goes back to the website they were at before so it's comparing the whole row instead of just the cell before it. Have a look. The first one should be true but is false since the first user goes back to yahoo later. Order of web navigating is important to the study I'm working on so is there another way to run a formula/check?

http://tinypic.com/r/1434aau/6

 

[Andrew Poulsom]

Is it?

H2<>H3

 

[bdavis87]

awesome! thank you so much!!!