Need help with Countif and placing the result in adjacent cell

[senthia87]

I need to find the countifs of two seperate variables and put that result in the adjacent cells. Basically, trying to find a way to pin point where the last two variables reside in the two seperate countif ranges. Data will be added in anytime
ex. rows (7-11) and columns Y and AA

Y	AA
DEF
ABC
ABC
ABC	=countif(Y:Y,"ABC")
DEF	=countif(Y:Y,"DEF")

<TBODY>
</TBODY>

Then if the ABC countif is greater than "V38", I want to populate the cell next to them with a P. For countif DEF I want to do the same except use cell "V39".
ex. Let's say V38= 3 V39= 2

Y	AA	AB
DEF
ABC
ABC
ABC	=countif(Y:Y,"ABC")	=if(AA10>V38,"P"," ")
DEF	=countif(Y:Y,"DEF")	=if(AA11>V39,"P"," ")

<TBODY>
</TBODY>

So if there was another ABC after the last DEF than I would need the macro to recognize that and put the P in the adjacent cell to that instead if greater than "V38"

Is there a way to do this?

What i started to mess around with:
Dim countif as an integer
countif= (Y:Y,"ABC")
when countif > "V38" then
activecell.value = "P"

 

[Andrew Poulsom]

For the formulas in column AA:

Excel 2010
	Y	Z	AA
1	DEF
2	ABC
3	ABC
4	ABC		3
5	DEF		2
Sheet1

Cell Formulas
Range	Formula
AA1	=IF(COUNTIF(Y$1:Y1,Y1)=COUNTIF(Y:Y,Y1),COUNTIF(Y$1:Y1,Y1),"")

For the formulas in column AB what determines V38 or V39?

 

[senthia87]

Then number is input by someone into a table, it can change at anytime.

 

[senthia87]

Also how would i put this into a macro??

 

[zhfgtj27]

Are the last two inputs guaranteed different, or not necessarily? If not, do you still want the 2 COUNTIF formulas to be applied to the same input? Or there are only 2 types of input in Column Y and you want a count for each of them to be placed at the bottom 2 rows in Column AA?

 

[senthia87]

They are not guaranteed to be different. In column Y there might be more than two inputs. If there is, then I want the countif for each put in AA where the last variable for each countif is.
ex.

Y	Z	AA
DEF
ABC
ABC
ABC		3
DEF		2
GHI		1
ABC

<TBODY>
</TBODY>

 

[senthia87]

Just realized i made a mistake. The "3" was supposed to be adjacent to the last "ABC".