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 have a table of 2 columns and 1000 rows. Column A is date and Column B is type. For the sake this exercise, imagine that I have only two types; Type 1 and Type 2. I would like to create a table which lists only the Type 2 entries along with their corresponding date.
I know I could use IF to look at the data and check for the types, but this will then give me a table with an empty row every time Type 1 is selected.
Can anyone suggest a way to create a table from a defined data set that will return entries for the desired data?
I hope this makes sense. I am confident that it doesn't.
Many thanks.
