Home > database >  Google Sheets - Return X rows based on cell value
Google Sheets - Return X rows based on cell value

Time:12-21

Let's say I have a list of names:

enter image description here

And I have another list for how many rows of each name I want to see:

enter image description here

How do I create a formula that outputs the following (notice how I want to take the first X of each first last name grouping):

Here is the link to the Google sheets if you'd like to write it out: enter image description here

  • Related