Extract information from main sheet into another sheet
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007 microsoft-excel-2013
I have an excel sheet that contains a list of events. The main sheet basically has thousands of events of different categories, such as educational, musical, art, etc.
Basically, what I want to do is divide the excel sheet into different sheets and have a formula extract information from the main sheet, but only of the event category that I specify. Also, I don't want the formula to return duplicate information, for example, if it extracts a musical event information from a specific row and column, it should not extract the information from the same row and column again.
So for example, I have a new sheet exclusively for educational events and the headers will be as the following respectively: Event Name, Event Location, Event Type, Event Time, Event Date. So basically I need a formula for each column to return information from the main sheet but without duplication. When I say duplicates, I'm not talking about values, because some events have the same name, but different time and date, so it should not take information from the same row/column twice.
Also, I'm making another statistics sheet where I put the year in a specific cell and it returns to me the total number of events in that year. The formula I need should allow me to specify the kind of event to count and the year in which the event occurred.
Sample picture: https://s17.postimg.org/c837a4ynj/2018-02-06_000925.jpg
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2007 microsoft-excel-2013
I have an excel sheet that contains a list of events. The main sheet basically has thousands of events of different categories, such as educational, musical, art, etc.
Basically, what I want to do is divide the excel sheet into different sheets and have a formula extract information from the main sheet, but only of the event category that I specify. Also, I don't want the formula to return duplicate information, for example, if it extracts a musical event information from a specific row and column, it should not extract the information from the same row and column again.
So for example, I have a new sheet exclusively for educational events and the headers will be as the following respectively: Event Name, Event Location, Event Type, Event Time, Event Date. So basically I need a formula for each column to return information from the main sheet but without duplication. When I say duplicates, I'm not talking about values, because some events have the same name, but different time and date, so it should not take information from the same row/column twice.
Also, I'm making another statistics sheet where I put the year in a specific cell and it returns to me the total number of events in that year. The formula I need should allow me to specify the kind of event to count and the year in which the event occurred.
Sample picture: https://s17.postimg.org/c837a4ynj/2018-02-06_000925.jpg
