Ask Your Question
0

find combinations that appears the most [closed]

asked 2014-03-01 11:02:07 +0100

Rait gravatar image

updated 2015-09-11 23:46:59 +0100

Alex Kemp gravatar image

Hello!

i have a question that i have been looking for quite lot of time and still no answer. what if i have rows of data and i want to find similar combinations. for exsample:

black, green, red, purple

purple, red, white, blue

brown, golden, red, purple

orange, light blue, grey, yellow

the combinations that appears the most "red, purple" and it appears 3 times out of 4

is it possible to make such formula?

  • LibreOffice 3.5.7.2, english, Calc, Ubuntu 12.04 LTS
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 16:52:28.274594

Comments

Are you talking about background colours or colour name words in the cells?

m.a.riosv gravatar imagem.a.riosv ( 2014-03-01 14:27:55 +0100 )edit

color names. they can be as well fuits or animals

Rait gravatar imageRait ( 2014-03-01 16:33:27 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-03-01 11:46:23 +0100

ROSt52 gravatar image

I would look into the conditions of each color and use the if function with according conditions.

edit flag offensive delete link more

Comments

i think i have to add that possible combinations that there can be is so many it would take weeks to write with all the if´s one by one there is 50 different colors and every line has 6 colors but with fact that every color can be once every line that´s makes over 15 000 000 different combinations

Rait gravatar imageRait ( 2014-03-01 13:28:44 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-03-01 11:02:07 +0100

Seen: 69 times

Last updated: Mar 01 '14