how to use If function in excel using vba on entire column

[m_vishal_c]

hi Everyone
i have one excel workbook. The column structure is as below
AY AZ BB
date date -------

there are more then 4000 records(rows) in AY and AZ column. I need if function like if(AZ>=AY,"",AY) through vba. this formula will be placed on BB column

is anybody help me out

heaps thanks in advance

thanks

 

[m_vishal_c]

Question
Are there formulas in column BB? If so, show us the formulas.

M.

the below my formula is not in that sheet, I have placed my formula in another sheet (same workbook).

=COUNTIFS(ABC!$B:$B,A2,ABC!$BB:$BB,"<>")

in BB column there is not any formulas and after applying your formula I applied below code

Sheets("ABC").Columns(54).Copy
Sheets("ABC").Columns(54).PasteSpecial xlPasteValues

so only values left not any formula

 

[Marcelo Branco]

If I understood correctly, in column BB are the results of the above formula (post 4)
So in column BB there are cells with numbers and some cells that contains "" (empty string).
Question: are the numbers always positives or positives and negatives?

M.

 

[m_vishal_c]

If I understood correctly, in column BB are the results of the above formula (post 4)
So in column BB there are cells with numbers and some cells that contains "" (empty string).
Question: are the numbers always positives or positives and negatives?

M.

hi. yes you are right. in BB column there are some blank cells and values too (its Date). I just need to count how many dates are there
thanks

 

[Marcelo Branco]

Maybe...

=COUNTIFS(ABC!$B:$B,A2,ABC!$BB:$BB,">0")

M.

 

[m_vishal_c]

Maybe...

=COUNTIFS(ABC!$B:$B,A2,ABC!$BB:$BB,">0")

M.

Oh!!! Man.. you are great . you made my life easier. thanks a lot