# Help formula needed to find similarity

#### MarcNecs55

##### New Member
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.

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### Weaver

##### Well-known Member
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

##### New Member
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??

Replies
10
Views
435
Replies
15
Views
766
Replies
7
Views
178
Replies
3
Views
371
Replies
5
Views
239