=IF(ISBLANK(IFERROR(INDEX('Main Schedule'!$N$10:$N500,SMALL(IF('Main Schedule'!$P$10:$Q500=$Q$2,ROW('Main Schedule'!$N$10:$N500)),ROW(1:1))-9,1),"")),"",IFERROR(INDEX('Main Schedule'!$N$10:$N500,SMALL(IF('Main Schedule'!$P$10:$Q500=$Q$2,ROW('Main Schedule'!$N$10:$N500)),ROW(1:1))-9,1),""))
This is my formula that I'm using to make a list. When I drag the cell down it makes a list based off of the small function which is finding all the numbers in column P-Q that match my number in Q2. It then indexes to another column and tells me the data there, in this case column N. My problem is that I'm trying to filter this generated list based off of a priority and when a new item is added to this list it pushes everything down to be in order because of the small function. My priority number that I put in is then one cell off because it does not move with the data as my other cells do in the list. In the picture you can see a new entry is added to the top and pushes everything else down one cell, meaning the priority numbers are off by one cell. Is there a way I can alter this function to add new entries to the bottom of my list so that my priority numbers stay in line with my data, or possibly another solution?
Thank you and I'm new to this.
Bookmarks