Clicking and doing FIlter in excel using UI

AuthBuyerList.AsEnumerable.SelectMany(Function(x,i)if(Regex.IsMatch(x(10).ToString,“YES”,RegexOptions.IgnoreCase),{i},{})).ToArray

this is my new code , old requirment of data comparison is not needed.
but i am not getting the desirable result.
many rows deleted apart from required rows!!!

@Seetharaman_K I am a bit busy now :sweat_smile:, But you share a sample of that file that you have and I can check later with it. However Since rows are getting deleted that means it is working, But the Condition you have used just might not be right, Try to alter it, Check if the Column Number is the Right number that you have used, 10th Column Index meaning 11th Column. Also will the value only consist “YES” in it?