Forum Discussion
Collating data from sheets and creating a list
Can anyone help me with this issue please. I would like to produce a sheet which analyses a table of data for a particlar critera and then produce a table based on that data. Essentially, I h...
If you are on Excel with dynamic arrays that could be like
=FILTER(A2:K1000,B2:B1000="Type 2")
SergeiBaklanThank you for your thoughts on this. Sadly, dynamic arrays are not an option because they are not on the version of Excel which is being used for this project.