In Microsoft Excel when we apply filters and get the data that is redundant be it in one column or multiple columns. In higher versions of Excel that is 2007 and 2010 we have filtering that is row specific and data specific.
To filter same records:
1) Apply auto filters by clicking of Data menu and clicking on Filter and Auto Filter.
2) Now go to a column and click on the arrow that is beside the column heading and choose an option that is repeating that column.
3) When we select an option under that particular column it will be filtered and all the selected will be filtered and displayed.
0 comments:
Post a Comment