days inbetween or column matching

[rawr19911]

Hello, so i need help with a quick formula with hopefully a easy solution
I have below and im trying to find out days between action 1 and action 2
i need it to do it ased off of loan number and compare action 1 to action 2 in column H i took out all personal info

note loan numbers are not always in order, its based off of dates and more

 

[SanjayGMusafir]

so i need help with a quick formula with hopefully a easy solution

Share XL2BB of actual data to understand the data and sorting order...

 

[rawr19911]

i am not able to use a addin- i can update the data manually to help better understand let me know if this helps

 

[rawr19911]

also not sure if it matters but there are 200 rows of data- and will be refreshed daily

 

[SanjayGMusafir]

Assuming you are storing data from Column A and you want days in Column J

Try this and revert -

=IF(And(B2=B1,H2<>H1),I2-I1,"")

 

[rawr19911]

Assuming you are storing data from Column A and you want days in Column J

Try this and revert -

=IF(And(B2=B1,H2<>H1),I2-I1,"")

this works your amazing!

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.