Match Column

Hello,
Please I need your help.

I have two columns in an excel file, what I want is to see if the cell of the second column is full we show the whole line in a new file.
find attach an example of the file.

Best regards,
File.xlsx (8.0 KB)

@Manjuts90 any help buddy

@ifranity Full means what it means exactly, from that excel file what output ur expecting can send out of it in excel.

1 Like

Hello @Manjuts90

please find attch the file and the output file File.xlsx (8.0 KB)
Output.xlsx (8.0 KB)
thanks a lot

Best regards,

@ifranity Please check the below workflow once and let me know.

flow-----.xaml (8.8 KB)

1 Like

gerde

1 Like

@ifranity u too have good day buddy

hello @Manjuts90
how are you, please i want to search into an sheet (col1,col2,col3,col4,col5) if col2 is not empty and/or col3 is not empty
copy those cell with cell in col1 in another sheet
Thanks a lot :wink:

@ifranity If Col2 or Col3 is not empty you want copy Col1 value or whole row to new sheet?

1 Like

Yes exactly

If col2 is not empty and/or Col3 is not empty, copy col1 col2 Col3 to another sheet
Thanks

@ifranity I have done using datatable. Please find the file below.

flw.xaml (12.9 KB)

@Manjuts90
Hi buddy happy new year and thank you a lot for the quick response, please i’ll attach the wanted output sheet (Sheet2) please can you help me to do it
thanks alot
Book1.xlsx (9.7 KB)

@Manjuts90

please find attach the updated file and thank you very muchBook1.xlsx (9.8 KB)

best regards,

@ifranity I didn’t get your logic, how you got that output?