Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 08 Mar 2018 10:05:22 +0100column Comparisionhttps://ask.libreoffice.org/en/question/148545/column-comparision/I have a column like this
MIR548H2
MIR548H2
MIR548H2
AAGAB
AAGAB
AAGAB
AAGAB
AAGAB
AAGAB
AAGAB
Want the counts in increasing manner like this
MIR548H2 1
MIR548H2 2
MIR548H2 3
AAGAB 1
AAGAB 2
AAGAB 3
AAGAB 4
AAGAB 5
AAGAB 6
AAGAB 7
Thu, 08 Mar 2018 04:55:46 +0100https://ask.libreoffice.org/en/question/148545/column-comparision/Answer by gsk for <p>I have a column like this</p>
<pre><code>MIR548H2
MIR548H2
MIR548H2
AAGAB
AAGAB
AAGAB
AAGAB
AAGAB
AAGAB
AAGAB
</code></pre>
<p>Want the counts in increasing manner like this</p>
<pre><code>MIR548H2 1
MIR548H2 2
MIR548H2 3
AAGAB 1
AAGAB 2
AAGAB 3
AAGAB 4
AAGAB 5
AAGAB 6
AAGAB 7
</code></pre>
https://ask.libreoffice.org/en/question/148545/column-comparision/?answer=148547#post-id-148547Found solution
=COUNTIF($A$2:A2,A2) Thu, 08 Mar 2018 05:27:49 +0100https://ask.libreoffice.org/en/question/148545/column-comparision/?answer=148547#post-id-148547Comment by Lupp for <p>Found solution
=COUNTIF($A$2:A2,A2) </p>
https://ask.libreoffice.org/en/question/148545/column-comparision/?comment=148553#post-id-148553This way **each formula has to sift a range** whose length increases by one per row. Assuming you have 10000 rows this means about 50 000 000 comparisons needed. A sheet has > 1 000 000 rows. Filled next to completely this makes about 500 000 000 000 comparisons.
In fact your data look as if you can assure that any specific content occurs in only **one contiguous range**. Exploiting this assurance you can reduce the expense in comparisons to N where N is the number of used rows.Thu, 08 Mar 2018 10:05:22 +0100https://ask.libreoffice.org/en/question/148545/column-comparision/?comment=148553#post-id-148553