Sort If Function List Results
I have a list of 200 names, with emails, year of graduation and enrollment date. I am trying to extract a list of emails depending on the YoG and ED. My current formula works (e.g. it only it shows the emails with the criteria I ask for) but the emails in the new list correspond to the cell it is in, making it so I have five emails separated by 195 blanks. I want to arrange all the TRUE answers at the top, and leave the FALSE answers at the bottom, so all the emails appear at the top of the list, and all the blanks at the bottom. Current Formula: =IF(AND(H4=$K$2,E4=$K$7),C4,"") Translation: If entry has the text in Column H that corresponds with the text in K2 AND the text in Column E corresponds with the text in K7, give me the data in Column C. If not, leave the cell blank. Right now the formula produces this list in Column N: [Blank] [Blank] Email [Blank] [Blank} Email [Blank] Email But I want it to be: Email Email Email Email [Blank] [Blank]
Return Data from Privot table according to sums.
Hello Wizards, I need to get data form a pivot table according to the sum values in the table. I have a table that has each store's name, address, zip, etc on the vertical left of the table with the months across the top. The table measure sum of sales per product per store by month. I need to find all stores that have sold within specific months. I have tried GETPIVOTDATA, but it seems to only be able to return the sum of sales of specific stores rather than the stores with specific sales. I also need to be able to adjust the month of sales it is looking at. Right now, I am using an ISBLANK function referencing the latest month and building a separate table from that. However, I can't adjust the dates with the current set up
index match with multiple dates
I have a workbook built for my company that uses index match to return the subject line of a employee communication. However if there are multiple communications the formula only returns the first entry. What can I use to return the subject line based on the most recent date? There is an additional column that contains the date that the communication was sent. This is the data I am using: CommID EmpID EmpName Category Subject Viewed Created 7.72E+08 2214626 Doe, Jon Quality & Service DSAT - 3/8 - Discussion - Call not ava - 1/16/2019 1 1/16/2019 21:59 7.63E+08 2214626 Doe, Jon General DSAT - Disscussion - Verbal - Skill 1 12/25/2018 22:33 I want to return the Subject based on the most recent entry in Created. I am currently using this formula to pull the data: =IFERROR(INDEX(KPICommDetail[Subject],MATCH([Ident],KPICommDetail[EmpID],0)),"") Help and thanks!!pull data based on dropdown list
Hey guys, 1 worksheet, 2 different tabs. On tab 1, I have a drop down status list for different projects (along with other project information in the row). When a specific status from the drop down list is chosen, I want that project (row of data) to populate automatically in a row in tab 2. I am struggling to populate only the list of a specific status in tab 2, and populate the rest of the line.