Count days

[rajeshv19]

Hello All,
Might need some help here..I have a series of customer lists, i.e. Account no. along with transaction dates. The list looks like this,
Account Transaction Dates
750002 29/04/2010
750002 27/07/2010
750004 25/02/2010
750004 03/03/2010
750004 20/04/2010
750004 27/04/2010
Column A – Account and Column B- Transaction Dates.
What I wanted to find is number of days between first, second and third transactions by an account. This is to gauge what are the dates between his purchases. Assuming I have a list of close to 30k customers who could have one/ ten transaction dates against them, it would be great to have a formula to do this trick.
Cheers

[Richard Buttrey]

Hi,

Welcome to the forum.

Assuming the list is sorted by account and date (ascending), then in C2 copied down

=IF(A2=A1,B2-B1,"")

[rajeshv19]

@ Richard,

Thanks a ton Mate. Just improvised on from your formula with an IFerror statement and voila i have the winner. Thanks for saving my day.Much appreciated. Cheers

Regards,
Raj