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
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 )
lol!
BRO!!! 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.
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!