Excel Filtering



thnx @ashapkina it worked bt what will i do if like in this file the largest four is 9076, 9075, 9073,9072 emp2.xlsx (8.9 KB)
so how this script will work . i.e 9074 is not there


hey @ashapkina i have an excel file i want to filter it by column DAT like latest is 9096,9095,9054,9053 so i want only first three 9096 ,9095 ,9054 whether theses three available or not bt i want these three counts and want to paste it in another cell.
1.xlsx (9.9 KB)


Here is a sample script that adds all rows with 4 largest versions to a new table.

filter-tables.zip (1.3 KB)

Note that the column with the versions has to be filtered from the largest to the smallest version for the script to work, so you will need to add actions to filter it at the beginning of the script.


hey @ashapkina how to save excel file into .csv file


There are no built-in actions for it. You can open the excel file on the screen and save it using mouse clicks and keystrokes: file - save as - browse, etc.

Here is a similar example from Word