Help formula needed to find similarity

[MarcNecs55]

Hi guys I need help finding out which formula works best at find similarities between to rows.

For example

Row A1................... Row B2
8443..................... 1231
1554..................... 54564
5456..................... 7897
1351..................... (-5465)
(-5454).................... (-54887)
131564.................. 4878
15645445............... 4545

I Would like to know how close these 2rows are similar to each other is it 2% or 70%. What formula works best at find this out.

Sorry if this seems like a dumb question but I am not good with excel or statistics. Your advise is greatly appreciated.

 

[Weaver]

Assuming you mean columns, you could try

=sum(a:a)/sum(b:b)

and format the cell with the formula in it to 0.00%

 

[MarcNecs55]

Yes I meant to say columns thank you.

Just one more thing I forgot to add. RowA1 is static while RowB2 is dynamic, where data in RowB2 changes every 30 minutes. will this formula still work??