Forum Discussion
Compare 2 columns and extract data to another sheet
I am looking for a formula or a short code for comparing column 5 (Unique) values with column 4 in Sheet 1 of Workbook and if they are equal that row should be copied to Sheet 2 which will be my o...
=FILTER(A1:D17;(D1:D17=45)+(D1:D17=46)+(D1:D17=47)+(D1:D17=48)+(D1:D17=10))
With Office365 or 2021 you can apply Filter function. With other versions of excel you can use advanced filter.
Thanks for the help , but actually my column 5 will have 100-200 unique values which needs to check against 49000 values in Column 4- is it possible to have range of the column in place of number 45 , 46 , 47, 48?