T Techtrend Member Mar 31, 2017 #1 Need to Filter Separate when matches, The details are mentioned in the attachment Thanks for your help in advance NAREN Attachments FILTER SEPERATE.xlsx 11.3 KB · Views: 9
Need to Filter Separate when matches, The details are mentioned in the attachment Thanks for your help in advance NAREN
Luke M Excel Ninja Staff member Mar 31, 2017 #2 In a helper column, could use a formula like this: =(COUNTIF(H:H,A2)+COUNTIF(H:H,E2))>0 Then, filter on that column for 'true'.
In a helper column, could use a formula like this: =(COUNTIF(H:H,A2)+COUNTIF(H:H,E2))>0 Then, filter on that column for 'true'.
