Delete all Duplicates in Selected column This function will only work on one columns at a time. With this function you can eliminate all duplicate data. The first instance of the data will be preserved and subsequent occurrence of the same data will be erased. Since this function involves a lot of searching and erasing it will take a lot of time for a large database. Please save your file before running this program. Please note that the data need not be sorted on the key column for this function to work.
Colour all Duplicates in Selected column This function will only work on one columns at a time. With this function you can colour all duplicates of data. Since this function involves a lot of searching and erasing it will take a lot of time for a large database. Please save your file before running this program. Please note that the data need not be sorted on the key column for this function to work.
Count all Duplicates In Selected Columns This function will only work on one column at a time. With this function you can count all duplicates of data. Since this function involves a lot of searching and erasing it will take a lot of time for a large database. Please save your file before running this program. Please note that the data need not be sorted on the key column for this function to work.
This will Count the Unique Number of items in the selected Column.
Delete all Blank Rows in selection. In a large worksheet if you want to delete all the blank rows in a selected range then use this function.
Delete all Blank Columns in selection. In a large worksheet if you want to delete all the blank columns then use this function.
Insert "N" rows after every Row. With this program you can insert as many rows as you desire in between each row of data for the selected range. For Example you have data from Row 3 to 1000 containing Part Number wise Rate and Issue value. If you want to insert 2 rows between each row then just select this function after having selected the range of data, you will given a edit box with 1 as default, just type 2 and click okay. You will find 2 rows inserted between each row.
Insert "N" columns after every Column. It is same as inserting rows as above but in this case you can insert as many columns between the data range as you want after each column.
Insert row on Change of Key field. In a large database if you want to insert rows where there is a change in the key column then use this function. The Database should be sorted on this key column.
Useful at the time of using vlookup formula when we need to calculated the number of columns in between two columns say between b4 & ca4 then use this program to quickly get the figure.
Put Background Color Index Number in New Column. This utility will help you indirectly in sorting a database on the background color of a specified column. First select the column whose background has been formatted with different colors. Then use this utility. You will find a new column with the color index of the left side column in it, thereafter sort the database on this column.
Put Font Color Index Number in New Column. This utility will help you indirectly in sorting a database on the font color of a specified column. First select the column whose font has been formatted with different colors. Then use this utility. You will find a new column with the font color index of the left side column in it, thereafter sort the database on this column.
This is a very powerful program. You can filter a large database based on a specified background color in one specific column only. First start the program which will present you with a Dialog box.
In the first selection box select the column on whose background colour you want to filter. Select the entire data range except the headings. In the second selection box select any cell in the column based on whose background colour you want to filter the data. In case you want to select more than one colour then press Ctrl and click the next cell with different colour.
There are two options, you can hide those rows with the colours selected or hide the rows which do not contain the colours selected.
Filter Data in a Column based on Font Color
You can filter a large database based on a specified background color in one specific column only. First start the program which will present you with a Dialog box.
In the first selection box select the column on whose colour you want to filter. Select the entire data range except the headings. In the second selection box select any cell in the column based on whose font colour you want to filter the data. In case you want to select more than one colour then press Ctrl and click the next cell with different font colour.
There are two options, you can hide those rows with the colours selected or hide the rows which do not contain the colours selected.
Move or Copy Rows based on background or font Color
You must know how to correctly use this program to fully utilize its full potential. This program will be useful when you have a large database in which you have coloured a few cells based on certain criteria you have decided. Now suppose you want to either copy or move those coloured rows to a new sheet, this program will do it in seconds.
First off all select the entire data range with or without the header row. Thereafter select this program. You will get a Dialog Box like this. Check Spelling
In case in your data range selection the first row is the Header row then according select the radio box accordingly. Now the cells you have coloured, have their background colour been changed or the font color. Select the correct radio button accordingly. Now in the Edit box just select any one cell whose colour you have changed. Now you have two choice: copy the coloured rows to a new sheet or move the data to a new sheet. Please note there is no undo feature. However this program can cause problems to your database if you move some of the data to new sheet and these cells were referenced by the other cells in the original sheet. It is advised to first save the worksheet before moving any data.