Forum Discussion
Extract or copy rows of data from one sheet to another based on multiple criteria.
Hello I am not sure which excel function would be best to resolve this. A little background I work in a school setting where students are taking multiple classes and the data given to me is one excel...
An alternative could be Power Query which is available in legacy Excel e.g. Excel 2013. In the attached file you can add data to the blue dynamic tables in sheets "rawdata" and "mystudents". Then you can click in any cell of the green table in sheet "mystudentsprogress" and right-click with the mouse and select refresh to update the green result table.