This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a list of Award names that repeated multiple times. Unfortunately the number of repeats vary for each award name and their corresponding ceremony.
Does anyone know how to return the first 5 repeated award name for every award name irrespective of how many repeats there are? So, basically I would like to keep the stuff that are highlight in the image and discard the rest.
Screenshot of results workflow
It most likely is easy, but I have working on the whole workflow the entire and I cannot think of a solution.
Do you know how to fill rows in the reverse direction? As in get the string value in Record #15 [Award] to fill up the empty rows all the way to #1 and Record #27 [Award] to fill up the empty rows all the way up to #16 and so on?
I have tried multi-row formula but only know how to use it going in a downwards direction.