Excel formula to find column similarity

Ukończone Opublikowano 6 lat temu Płatność przy odbiorze
Ukończone

Hi,

Please check the attached excel document.

I need a formula to check two columns, analyze them and then whenever I write a given string the formula should tell in which of the two columns that string has more percentage of belong to, based in similarity percentage of number of times character appears and character position.

Strings and words in columns are single words with 16 characters.

To sum up: I just want to know from the two columns a given string is more likely to be placed in.

Excel Excel VBA

Numer ID Projektu: #16367102

O projekcie

34 ofert Zdalny projekt Aktywny 6 lat temu

Przyznany użytkownikowi:

satishtl

Yes identifying a strings and which column has more % can be identified using Excel macro, using a click of a button. - Have done similar for the Scoring system (Freelancer Project), where automated scores would be pr Więcej

$8 USD / godzina
(48 ocen)
6.0

34 freelancerów złożyło ofertę na średnią kwotę $12/godzinę w tym projekcie

KulfiSoftwares

I have seen your attachment, and understand how you want the probability calculated for both Column A and B. I love excel automation, and have done several similar projects. I should be able to finish this within 10 ho Więcej

$15 USD / godzina
(280 Oceny)
7.5
avinav606lx

Hi There, I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman

$22 USD / godzina
(163 Oceny)
6.4
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do Więcej

$12 USD / godzina
(82 Oceny)
5.8
kannasanthosh

A proposal has not yet been provided

$10 USD / godzina
(38 Oceny)
5.7
whitehorsetechn

Greeting, I have understood your Excel formula to find column similarity task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, Excel Więcej

$8 USD / godzina
(14 Oceny)
5.2
Nicecreator

Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me . I have complited many data analytical work high quality and accuracy last five year. using mic Więcej

$8 USD / godzina
(11 Oceny)
3.5
Overseashelp

hello, i am interested in your project. i'd love to help you find in which column your string text is more likely to be found. i have been in this field for almost 5 years and i can will make the job in few hours. i w Więcej

$16 USD / godzina
(3 Oceny)
3.3
ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in ex Więcej

$10 USD / godzina
(14 Oceny)
3.1
rhodelta

Yes I can do it but I need to know exactly what you're after. Is there a particular formula to be used to generate the probability or come up with our own? What sort of formula do you need? Can I use say 3 columns to Więcej

$15 USD / godzina
(5 Oceny)
2.6
olenakravch

I believe it can be easily done with VBA

$10 USD / godzina
(1 Ocena)
1.8
Ranjan2201

A proposal has not yet been provided

$11 USD / godzina
(2 Oceny)
1.4
suvamkumargiri

i am subham. I have high skill with experience in computer professional. Always ready to provide better service and quality work for you. My Services are:  To find out the email address of CEO/Director - Top L Więcej

$10 USD / godzina
(0 Oceny)
0.0
cbk1982

I can do it well

$8 USD / godzina
(0 Oceny)
0.0
ManeeRauf7

I'm honest with my work and I have a good grip on Excel and Google docs, can automate reports by the help of formula and functions. Can complete tasks on estimated time mentioned by client, also will not demand to pay Więcej

$16 USD / godzina
(0 Oceny)
0.0
usept

A proposal has not yet been provided

$16 USD / godzina
(0 Oceny)
0.0
FIGUEROAJOX

I have the solution, according to the exposed problem, please Hire me! I have the formula for the problem

$11 USD / godzina
(0 Oceny)
0.0
ChamaraT

A proposal has not yet been provided

$12 USD / godzina
(0 Oceny)
0.0
Geetha95

hi, I am an Excel Expert. I can start immediately and deliver the file with the correct formula. Thanks, Geetha

$8 USD / godzina
(0 Oceny)
0.0
PKLM001

I have done the work. For the sample of entry string the column A have 37% match, the best match in the column is in the row 29 (with 81%); in the column B have 52%, the best match in the column is in the row 4 (with 8 Więcej

$12 USD / godzina
(0 Oceny)
0.0
pablomalave

A proposal has not yet been provided

$15 USD / godzina
(0 Oceny)
0.0