Showing posts with label Computer Tricks. Show all posts
Showing posts with label Computer Tricks. Show all posts

Removing Duplicate Rows in ODS/Spreadsheet

There is no automatic function to remove duplicate rows in ods. Follow below steps to delete all rows that have duplicate values in column A:

  1. Select all cells of the current data range.
  1. Sort the data range by column A.
Choose Data - Sort.

  1. Click an empty cell in the first row. Let's assume it is cell C2. Enter the formula:
=IF(A2=A3;1;0)

This will display 1 if the current row has the same value in column A as the next row. It will display 0 if the values are different.


  1. Copy the formula down for all rows of the data range.
  2. Drag the formula to last cell of the data present against to Column A
  3. Now filter Column C and select 1's in filter dropdown and delete
  1. Re-set(Open the filter and select All and Click on OK) the filter you can find desired unique values in Column A.

How To Make Symbols With Keyboard




Alt + 0153..... ™... trademark symbol
Alt + 0169.... ©.... copyright symbol
Alt + 0174..... ®....registered ­ trademark symbol
Alt + 0176 ...°......degre ­e symbol
Alt + 0177 ...±....plus-or ­-minus sign
Alt + 0182 ...¶.....paragr ­aph mark
Alt + 0190 ...¾....fractio ­n, three-fourths
Alt + 0215 ....×.....multi ­plication sign
Alt + 0162...¢....the ­ cent sign
Alt + 0161.....¡..... ­.upside down exclamation point
Alt + 0191.....¿..... ­upside down question mark
Alt + 1.......☺....sm ­iley face
Alt + 2 ......☻.....bla ­ck smiley face
Alt + 15.....☼.....su ­n
Alt + 12......♀.....f ­emale sign
Alt + 11.....♂......m ­ale sign
Alt + 6.......♠.....s ­pade
Alt + 5.......♣...... ­Club
Alt + 3.......♥...... ­Heart
Alt + 4.......♦...... ­Diamond
Alt + 13......♪.....e ­ighth note
Alt + 14......♫...... ­beamed eighth note
Alt + 8721.... ∑.... N-ary summation (auto sum)
Alt + 251.....√.....s ­quare root check mark
Alt + 8236.....∞..... ­infinity
Alt + 24.......↑..... ­up arrow
Alt + 25......↓...... ­down arrow
Alt + 26.....→.....ri ­ght arrow
Alt + 27......←.....l ­eft arrow
Alt + 18.....↕......u ­p/down arrow
Alt + 29......↔...lef ­t right arrow