Highlighting duplicate values in a column in OpenOffice Calc

Multi tool use
up vote
0
down vote
favorite
I'm using a Linux machine and I've been trying to find an equivalent to excel's
"highlight Cell Rules > Duplicate Values"
formula that I can use to color cells that have duplicates on the column in OpenOffice Calc.
I've already found and tried
COUNTIF(A$1:A$15; A1)>1
as a formula but this doesn't work on every single item in the column vs every single other one.
excel formula openoffice-calc
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
I'm using a Linux machine and I've been trying to find an equivalent to excel's
"highlight Cell Rules > Duplicate Values"
formula that I can use to color cells that have duplicates on the column in OpenOffice Calc.
I've already found and tried
COUNTIF(A$1:A$15; A1)>1
as a formula but this doesn't work on every single item in the column vs every single other one.
excel formula openoffice-calc
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm using a Linux machine and I've been trying to find an equivalent to excel's
"highlight Cell Rules > Duplicate Values"
formula that I can use to color cells that have duplicates on the column in OpenOffice Calc.
I've already found and tried
COUNTIF(A$1:A$15; A1)>1
as a formula but this doesn't work on every single item in the column vs every single other one.
excel formula openoffice-calc
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm using a Linux machine and I've been trying to find an equivalent to excel's
"highlight Cell Rules > Duplicate Values"
formula that I can use to color cells that have duplicates on the column in OpenOffice Calc.
I've already found and tried
COUNTIF(A$1:A$15; A1)>1
as a formula but this doesn't work on every single item in the column vs every single other one.
excel formula openoffice-calc
excel formula openoffice-calc
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 22 hours ago
toti08
1,4291523
1,4291523
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday


Amet Jadir DeCrypt
1
1
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Amet Jadir DeCrypt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Amet Jadir DeCrypt is a new contributor. Be nice, and check out our Code of Conduct.
Amet Jadir DeCrypt is a new contributor. Be nice, and check out our Code of Conduct.
Amet Jadir DeCrypt is a new contributor. Be nice, and check out our Code of Conduct.
Amet Jadir DeCrypt is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53203204%2fhighlighting-duplicate-values-in-a-column-in-openoffice-calc%23new-answer', 'question_page');
}
);
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
rwORDO1,ca GyrEWKA5VO,zFo9bVRI9kZ7XRM1kDB7Sr7Vjmyx7y,F,6Ta4,za3Urm