| Products | "No macros and no macro viruses found!" | |||
 |
||||
General Excel Finder - A solution for automatic transposing and search In excel transposing (from rows to columns and reverse) can be done by the commands copy / paste special - transpose. Even more rows can be transposed, but if we want to transpose each rows of a table, one by one, we have to repeat this operation as many times as many rows we have. If the rows (columns) to be transposed contain formulas, during the transposing the cell reference of the formulas may change, so the transposed rows (columns) will show different values than the original. The automatic transposing is a complex (written) procedure, that enables the view of the excel sheets row by row in a transposed way (in another sheet). The search in excel is also possible with the integrated find command. There is also a solution for the collection of the search results. On the other hand we do not use the search only to find a special data, but in many cases we need the content of the row of the searched data. We can review a row more easily if we transpose it. The automatic search function collects the hits to a list. Clicking on any of the hits from the list, the whole row of the data will appear transposed. Also with a simple click we can easily move between the search results. Beside the two basic functions it is also not negligible that by clicking the hyperlinks of the cells of the transposed row we can immediately jump to the adequate cell of the original row. The integrated display of the software that is used for transposing and search can be copied, so the user can format it at will. The software can be translated to and be used at any languages. In the downloaded version 3 translations, English, Hungarian and Romanian can be used. The use of the software is very simple. Download the demo or full version. Copy your table to the downloaded file. If it is not possible, copy the FDR_Set worksheet (as a worksheet) of the downloaded file to your excel file. After making some easy settings you can immediately use the software. You can find a detailed description in the help of the downloaded file. |
||||
|
General Excel Column Filter 1.00 - a simply horizontal filter and column sorter Excel gives solutions for overviewing a huge excel file with the commands Window/Freeze Panes, Window/Split, Format/Column/Hide, Data/Sort or Data/Filter. But with these commands it is rather difficult and time consuming to simplify and to be able to overview a huge table. These operations can be substituted by General Excel Column Filter displaying any excel table in 8 columns in any order. The colums can be selected with a simple click without making any change in the original (source) file. The rows can be scrolled also with simple click. The table simplified this way can be printed very easily. The licensed version of the program enables to create the display (Own Display) where the user can write his own formulas and practically can execute any operation. The program does not contain macros! | ||||