I have a question. I am looking for a formula in excel to help me with this (for work).
I have a single excel sheet, with an overall list of patients that i have. I would like to separate my rows based on values in a column (pneumonia or heart issues). If a certain patient has diagnosis of "pneumonia", to copy the entire row to sheet B, if a patient has a diagnosis of "heart issues", to copy the entire row to sheet C.
Is there a way for me to do this? Thank you very much for your help in advanced!