I have a list of data in a sheet and I want to extract into a new sheet
values based on a condition . E.g. Column A has 100 rows of data. Column B
has a grouping e.g. Dept A, Dept B, Dept C etc . I want to extract into
another sheet any data from column A based on the value in column B (say Dept
B). Could you advise on the best way?