Blank Subscription Forms: Fill & Download for Free

Thanks for posting the screenshot. Without it, this question was hopeless.I assumed that you had a layout exactly as posted, with a table in cells A2:M7 with column header labels in row 2 and row labels in column A. Most of the cells in the table are blank, but a handful have numbers. You want to concatenate the column header labels for those columns where there is a value in the row where the route in cell A11 matches one of the row labels in A2:A7.To solve this problem, you need Excel 2016 obtained using an Office 365 subscription. That’s because the required TEXTJOIN function was added after the initial release of Excel 2016—and the perpetual license versions of Office don’t receive added features like the new functions.The desired formula must be array-entered. That means you put the formula in the formula bar, then hold the Control and Shift keys down while you hit Enter. Excel will respond by adding curly braces { } surrounding your formula. You will likely get empty strings (look like blanks) if you don’t array-enter the formula.=TEXTJOIN(", ",TRUE,IF(INDEX(B$3:L$7,MATCH(A10,A$3:A$7,0),)<>"",B$2:L$2,"")) If you don’t have Excel 2016 on an Office 365 subscription, you will need to use a user-defined function (written in VBA) to solve the problem. The code shown below may be used with a worksheet formula (does not need to be array-entered) like:=CompetitorList(A11,B$3:L$7,B$2:L$2,A$3:A$7) Put the code in a regular module sheet. Use Insert…Module in the VBA Editor to create the regular module sheet.Function CompetitorList(TargetRowLabel As Variant, data As Range, HeaderLabels As Range, RowLabels As Range) As String Dim s As String Dim v As Variant Dim cel As Range  On Error Resume Next v = Application.Match(TargetRowLabel, RowLabels, 0) On Error GoTo 0  If Not IsError(v) Then  For Each cel In data.Rows(v).Cells  If cel.Value <> "" Then s = s & ", " & Intersect(cel.EntireColumn, HeaderLabels).Value  Next End If If s <> "" Then C 

Read AVC[1] MBA Mondays and Both Sides of the Table[2] along with InfoChachkie[3]. You might not know about StartupCFO[4], which taught me a lot.Are you fired up? Get back to building your business.Yes, reading is important, but it can also become a form of analysis paralysis. I have to fight it off at times.Read what you need to keep up with the industry. Spend time on understanding things that really matter like Landing Page Optimization. Reducing your costs of customer acquisition means increasing your profits and this is how you do it.I have 100s of subscriptions to RSS feeds grouped into folders in my Google Reader. I rarely have time to finish reading my _Must Read, but I try to as that is a good use of my time. I always read my __Security Alerts, however. :)If I have enough time to catch up on all of the content published that day, especially the Top 10 Tech Blogs folder, that means I am procrastinating and I have taken a day off. :)I try to participate on AVC whenever I can add some value. I see it as Fred Wilson (Venture Investor) 's personal Quora.I am sure there is a comprehensive answer that has a lot more interesting resources, but once you decide what you want to build you will find yourself having less time available to indulge in reading.Reading a book for a day that will save you a month of work is a good investment of time. I spent a significant amount of time on learning things like Test Driven Development (TDD), Product Management, Scrum (product development), the formal parts of Computer Science that I never learned like Algorithms and Data Structures, Code Refactoring, and REST (software architectural style). My productivity is much higher now because I can avoid creating bugs without thinking about it.Finally, here is a direct link to Steve Blank's Lean Startup class[5] on Udacity and Amir Khella's class on prototyping[6] on Udemy. Enjoy :)Bold links lead directly to Quora profiles.[1] A VC - Fred Wilson[2] 2X Entrepreneur Turned Venture Capitalist - Mark Suster[3] Hands-on startup advice for emerging entrepreneurs - John Greathouse[4] StartupCFO : Mark MacLeod - Mark MacLeod[5] Udacity - 21st Century University - Steve Blank[6] Mobile Apps Development by Amir Khella - Amir Khella

“ Physics is nothing but killer visualization and simple math.”Namo Kaul / Namo Sir (as i like to ‘kaul’ him) is possibly one of the best physics teachers our generation will ever see. He is one of the very few people whom i have ever seen to possess such clarity of a not-so-clear subject. This can only be understood by a person who has seen him teach, who has gone to him or gone to his videos to learn something.It irritates me a lot when i see know-it-all s coming to his UNACADEMY classes or YouTube Sessions. Sometimes people command him in during classes to teach this or teach that. Some are arrogant and disrespectful enough to say (or rather write) point blank that they do not like the classes at all and he is nothing more than a marketeer selling the Unacademy Plus Subscription.People, be respectful of him and his teaching style. Not two teachers teach the same thing in the same depth and pedagogy. His teaching might not seem appealing to some people. However that does not mean they will label him a crackpot and spread the propaganda of other teachers defaming him in the process. It’s all about one’s choices and preferences.Now that we have this out of the way, coming back to the question….His lectures are enough to build a good understanding of the subject. I myself am his student and believe me when i say that i am not some random Unacademy or Namo Kaul fanboy. I myself tried out many physics teachers before finally settling for him. He also makes us practice many JEE Adv. level questions. I personally think that a JEE aspirant must practice about 100+ sums per topic (average figure) and to complete that target we have to practice from other sources too. But, do not worry, he has also recommended books to practice from in his YouTube sessions.Fair warning: Namo sir designs his lectures such that all his students can benefit from it no matter at what level of preparation they have. So if a person has learnt the entire Resnick Halliday book by heart, he will initially not like the class. But yet again I say, attend all his lectures. There is always something beautiful to learn or soak in in his videos.