remove all rows with word Complete in column called Status

[nzt101]

Hey guys,

loading data from an external workbook, how could i use power query/transform to remove all rows with the word Complete in a column called Status?
haven't touched excel in a long long time and am enjoying getting to use it again, but i've tried searching and can't find how to do this,

thanks in advance!

 

[nzt101]

ahh all good, i've worked it out.
the worksheet has 13000+ lines in it, i removed the top 13000 lines then it let me untick the COMPLETE status rows to only show the others
i'm not sure how to delete the thread so i'll leave this here in case anyone else needs something similiar and this helps