Match Column

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


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

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

flw.xaml (12.9 KB)

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)


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?