Excel Help, Formula to not show a blank cell

[eford]

Ok guys I have a questions that I hope you can help with.

I have a pivot table that has this information among other values

Months	Agent Code
4	AA1234567
4	AA2345678
5	AA3456789
28	AA4567891
29	AA5678912
1	AA6789123

<tbody>
</tbody>

What I am trying to accomplish is write a formula that will show the value for all AA #s that have less than 12 months.

The formula I am using does not give me the result I want:

=IF(ISBLANK('Sheet tab name'!$C5),""IF('Sheet tab name'!$B5<=12,'Sheet tab name'!$C5,""))

And it gives me this result:

AA1234567

AA2345678

AA3456789

AA6789123

<tbody>
</tbody>

What changes do I need to make to return this result:

AA1234567

AA2345678

AA3456789

AA6789123

<tbody>
</tbody>

Thanks for all your help.

 

[Ornthorpe]

Looks like you just don't want to see rows that are greater than 12 months. I don't think that can be done with a formula. Try evaluating each row one at a time with vba and hiding any >12. ---assuming all this is one sheet---