I want to sort the column Reviews in descending and price in ascending but its not working, also is there a way to remove items if any of its data are incomplete. Im trying to make a dynamic data scraping based on user input and getting the best product. [exaample] [wrong] [test]

@darshanb.is22 Read the data…then use two sort datatable to sort both…or in excel also you have sort activity which works as well To remove rows…simply use filter datatable and filter for empty rows Or if needed on excel use a combination of filter and delete rows Cheers

Hi @darshanb.is22 Please check the below thread [image] Excel sorting and operation Studio Hi @darshanb.is22 Sequence: Main.xaml (14.6 KB) Macros Code: Sub FilterData() Dim ws As Worksheet Dim lastRow As Long Dim sortRange As Range ' Set the works…

Sorting columns in excel

Help Studio

vrdabberu (Varunraj Dabberu) January 24, 2024, 8:04am 3

Hi @darshanb.is22

Please check the below thread

Regards

1 Like

Topic		Replies	Views
Excel sorting and operation Studio datatable , excel , question	4	398	January 23, 2024
How to Sort a column from A to Z in excel? Help excel , studio , question	13	5013	August 17, 2021
Sort ascending or Descending with out using tables Help datatable , excel , activities	7	11073	October 17, 2018
Sorting data in Excel Help excel , activities , question	12	5761	December 28, 2019
Excel ordenar Activities excel	12	83	March 30, 2025

Sorting columns in excel

Related topics