Sort and remove lines in Excel

This method would work buddy
I think we are almost done but only missing with single quotes next to [Product] = ‘ ‘
(I kept space between the single quotes to show that it’s single quotes, but it would be like
[Product] = ‘’

Cheers @Doktorgud

OMG!!! been up for way to long! (and call me Sis :partying_face: )

lol! :rofl::rofl:

BRO!!! :laughing: :sweat_smile:So i got it to work with the duplicates! (im so happy)

but now the empty rows and “79003” and “79021” i want to remove from the list.
so its not “only” empty rows but mostly.

can i have the excel?? so that i can try!

if you want to remove that row contains “79003” do this
array_dataRow = DataTableVar.Select("Prouducts = “” ")
in for each loop use invoke method to Remove to delete rows

SchedulerReport (1).xlsx (35.4 KB)
This is the file without anything done to it (need the info from “Product” and everything that starts with numbers and a letter after)

SchedulerReport.xlsx (45.9 KB)
This is how it looks “now” after my assign.

@Pradeep_Shiv


you want to remove that empty cell or the entire row??

All i need from the entire exl is the “longer” numbers from “Cell Product” nothing else.

i asked somthing!

Remove the row.

give a sample output excel also it’ll help!