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.
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