How do I copy a set of cells based on a logical condition
I've names in column A and status level (low or medium or high) in column B.
I want to copy all 'names' with 'status level' as 'low' in to a different
sheet through a formula. I do not want to do this manually.
similarly all all 'names' with 'status level' as 'medium' in to a different
sheet and so on.
I also want the value to get updated automatically if I change the status in
original sheet from 'low' to 'medium'
|