With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, September 25, 2017
yogi_Repeat Sheet Names By Number Of Items In Respective Sheet Names In One Combined List
https://productforums.google.com/forum/#!topic/docs/uL6otiR9PNs;context-place=forum/docs Repeating value X times depending on number of entries in a range I currently use a Filter formula to grab all the relevant entries on multiple tabs:
That formula above will output 1 list of items from the "Fruits" tab and the "Vegetables" tab.
It's particularly helpful because I don't know how long the list from both tabs will be as they will grow/shrink daily.
What I want to do next is to add a column that describes which worksheet each entry comes from.
I know I can do this via a formula that will check each worksheet to find the name:
But I imagine there is another way to count the number of filter entries in the first formula and repeat "Fruits" for as many entries in the first part of the formula and then vegetables for the following entries. Any ideas of how to do this? Here's a spreadsheet with dummy data: