Help formula needed to find similarity

MarcNecs55

New Member
Joined
Aug 8, 2011
Messages
2
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.
 

Some videos you may like

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
Joined
Sep 10, 2008
Messages
5,196
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
Joined
Aug 8, 2011
Messages
2
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??
 

Watch MrExcel Video

Forum statistics

Threads
1,108,728
Messages
5,524,486
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top