Home Page

SSuite Office Software

Providers of Safe and Trusted Software with Pure Visual Simplicity

How to Find and Highlight Unique and Duplicate Items in SSuite Accel

This example teaches you how to find duplicate items in a selected range and highlight or clear them in Accel spreadsheet.

 

Step 1:  Select your range of items{Text or Numbers}, for this example we will use both text and numbers.

Tutorials to make you a better software user.     Tutorials to make you a better software user.



Step 2: On the dropdown button, select the "Highlight Duplicate Values" option.

Tutorials to make you a better software user. 



The Result will be the following: Text is highlighted in red and numbers in blue.

Tutorials to make you a better software user.       Tutorials to make you a better software user.



The Result for selecting "Highlight Unique Values" will be:

Tutorials to make you a better software user.

 Tutorials to make you a better software user.

The result for selecting to clear the duplicate items in the text example:

Tutorials to make you a better software user.

As you can see, only the originals are left, all the other duplicates have been removed from the selected list.

Tutorials to make you a better software user.



That is it for finding and highlighting unique and duplicate items in a selected range. This method can be used for both text and numbers.





Click here to view all our free office suite software downloads that are available directly from our servers. Free SSuite Office Software and Suites. Instant LAN video phones and conferencing without an internet connection, instant video lan chat and wifi. Gif Animators, Envelope printer, and Label printers with Avery templates. Click here to view our main page and selection of free office suite software downloads. We have the best free office software and suites including instant video with voip conferencing software and phones for LAN and internet without the need for an internet connection. Standalone voip video and instant messaging software also available. Gif Animators, Envelope printer, and Label printers with Avery templates.