Ask Your Question

find combinations that appears the most [closed]

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

Rait gravatar image

updated 2020-08-09 11:59:40 +0200

Alex Kemp gravatar image


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, 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


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 +0200 )edit

color names. they can be as well fuits or animals

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

1 Answer

Sort by » oldest newest most voted

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

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


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 +0200 )edit

Question Tools

1 follower


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

Seen: 75 times

Last updated: Mar 01 '14