Can't get INDEX/MATCH functions to do what I need?
It is quite an in depth excel sheet (to me) so here is a link to it: https://dl.dropboxusercontent.com/u/19122839/Movies.xlsm
On the Filters sheet, I have a search feature. This allows you to put in different genres, years, etc. and will pull up results.
The genre part does not seem to be working correctly for some reason.
In the movie_genres sheet, there is a Genre Equals and Genre Count column that seem to be marking the information correctly, but when you go to the movies sheet, the Matches Genre column does not. I use this function:
=INDEX(Genres[Genre Count],MATCH(Movies[[#This Row],[ID]],Genres[ID],0))
Which, to me, should pull the Genre Count, but in the case where there are more than one genre (I used Blank Check as an example in this case), it doesn't mark it as a 1. How can I make it so that this gets corrected.
For example, if you add the Comedy as a second genre, it pulls up more results than if you only have Family. I think I just need a fresh pair of eyes looking at this and it is probably something dumb, but any help would be great.
I believe I need to make it so that the index/match function I use in Movies[Matches Genre] will work as long as there is a 1 in Genres[Genre Count] for that ID. It only seems to work if there is a 1 in the first instance of the ID.
EDIT: I have added in a COUNT feature to better explain what I am talking about. With only Family as a genre, it shows there are 10 results, but when you add Comedy as a second genre, you get 40 results. This number should never go up as you add genres.
I am working through the kafka quickstart: http://kafka.apache.org/07/quickstart.html and the basic Consumer Group example: https://cwiki.apache.org/confluence/display/KAFKA/Consumer+Group+Example I h
This question talks about different payment processors and what they cost, but I'm looking for the answer to what do I need to do if I want to accept credit card payments? Assume I need to store credi
I am normally responsible for all scripting on web-sites running on my server, but some of my clients have other people working on (parts...) of their sites. When I give access, they can use php, so I
Wnen I use external resources such as files or DB connection I need to close them before I let them go. Do I need to do the same thing with Swing components ? If yes then how ?
I'm using VS 2010 Express and I've written an app that I want to deploy. I've decided to use a custom installer and I need to know, other than my .exe and .dll files, which files from the release\bin
We have a meeting scheduled early next week about adding SAML capabilities to our web application. Since I have no experience with SAML, I need to get hold of some information so that we can at least
I simply want to pass in an ID number (primary key) and get back any entries that were added since that ID. The ID increments for every entry so this should be a safe way to get new entries for the cl
i have a silverlight project it references other dlls in the bin folder it looks like this myproject.dll otherproject.dll otherdll.dll If I want to reference my project from another project what dlls
I want to debug pthreads on my custom linux distribution but I am missing something. My host is Ubuntu 12.04, my target is an i486 custom embedded Linux built with a crosstool-NG cross compiler toolse
I am using int 21-2AH and 2CH to get the time and date and understand what registers the results are returned. But when i use int 21-2 to output it i just get a funny character. What do i use to outpu
Being a application developer, do I need to know Unicode?
I need some help. I try to insert charmap button in fullscreen mode on wordpress, but I don't know, what I should write bettwen brackets. Usually to insert another buttons I wrote code like this: func
EDIT What small things which are too easy to overlook do I need to do before deploying a rails application? I have set up another question for any task that takes more than a minute or two, and so ou
And after that I deleted the git init with rm -rf .git and started a new one with git init, I messed my project? I want my older git configuration on my project, what can I do now?
Here are my requirements: I'll be adding users to N amount of roles; defined in a database. I need to protect each controller action with my authorize attribute. For example, the web application wo
I'm a .NET developer and I'm used to write standard WinForms and ASP.NET applications. In a few months I'll engage in a project that requires Sharepoint development. Problem is... I'm on ground zero r
Using .NET 4 and Silverlight 4 in Visual Studio 2010, I am trying to follow the MSDN guide to build a duplex service for a Silverlight client (http://msdn.microsoft.com/en-us/library/cc645027(v=vs.96)
I do not understand the reason for OpenCL native_ prefixed functions. The documentation says: Functions with the native_ prefix may map to one or more native device instructions and will typically ha
Amazon has Customers Who Bought This Item Also Bought. I am wondering and want to add this to my shopping cart which I made. What fields do I need in a database? Any website, blog or resources for t
I am looking to do something similar to what was asked here Getting list of parameters inside python function, but using partial functions. ie. I need to get the possible arguments for a partial funct
I have been working on an app for a while now and noticed today that when I export release build the final app icon (on android device) isnt produced - it just defaults to the standard android icon...
I have a week long holiday without 'net access coming up. I'm interested in learning iPhone development. What applications, tutorials, documents and so forth should I download in order to learn and de
I'm about to start GWT on OSX. I come from a typical Textmate/RoR background. Is there anything I should be aware of? Is OSX a bad envrionment to be doing GWT developmenet in?
I have OS 10.6 on my mac. I started with iphone SDK for snow lepard which builds for SDK 3.0 to 3.1.2. I'm ready to submit my app to the store. I'd like older iphones to use it as well. I can't find A
I installed 'ActiveSupport' and required 'active_support' in my code, but I get a No Method Error when I try to use the Hash.from_xml() method. What am I missing? $ gem list returns: \*** LOCAL GEM
Mono is an open source version of the .net framework, having a quick look at it's website it claims to have Linq-to-Oracle support. How hard is this to get working, e.g. does oracle software need to b
If I make an app targeting sdk2.2(api8) to sdk4.4.2, do I need to install every sdk from 2.2-4.4.2? Also should I install all the Android Build Tools? Thank you for your time.
If I run a basicHttpBinding WCF endpoint in a windows service what Windows features do I need to install? Do I need to install IIS? Do I need to install anything else? I'm on Windows 2008 server x64 S
Could guys please tell me what exactly I need to do in order to use com.jprofiler.agent.Controller in my code ? I have GWT/GAE application which I'm running under debugger of IntelliJ IDEA 11. I have
I am trying to create a text based adventure game in c++ for my school project. The roblem i am having is that my gameover() function needs to be able to goto my begin() function. The problem is begin
I'm doing some optimisation on a site Ive recently taken over. I've found a script I don't recognise: http://static.ak.fbcdn.net/rsrc.php/zo/r/V95Lkt_uLNB.js It could be a facebook thing, and there's
I have a wcf application hosted in a windows service running a local windows account. Do I need to set an SPN for this account? If so, what's the protocol the SPN needs to be set under? I know how to
This thread says I need three, but I have several options with those prefixes and don't know which three to link exactly. I'm working with iOS 5.1, XCode 4.3.2 Getting apple mach-o linker id error un
what files or plugins do I need to get tiles:insert to work? Do I need struts? I'm about 2 seconds away of just doing JSP include for everything. plz help thx!!
I have VS2010 and Expression studio 4 on my machine. I have done a fair amount of programming on Silverlight. What do I need to get started with development on Windows phone 7. I googled and found out
i am use a lamp environment , What things I need to pay attention during the development of the site, if the client wants to be ready to use CDN ? thanks
I decided to test my app in the production environment today. It's running fine in test and dev environments. But when I started a mongrel server in production I got a message about assets not being a
What do I do if I need to display a certain Preference in my PreferenceActivity only for large screens? Should I have then, say, xml-sw720 folder or is there another solution?
At work we have a web app that we'll need to interface with another company's web app using Single Sign On validated by SAML. Our web apps are written in PHP, and it's obviously irrelevant what langua
How can I get that API into our Android project.
I read , to set a session attribute I need to put : <sessions-enabled>true</sessions-enabled> inside appengine-web.xml and also implement java.io.Serializable. (though I don't understand
I am a java noob as well as very new to this site so please bear with me here. If I do something wrong in posting this please let me know and I apologize in advance for anything I do happen to do or a
I have an app on GooglePlay and would like to publish on Amazon app store. is there anything I need to change in my code? Most likely, the licence check from Google library has to be removed. Right? i
I am making a booking system using rails. I have 3 models - visitors, rooms and bookings. Visitors can stay in rooms. A booking can have many visitors and be in many rooms (or shared). A booking also
Im using Netbeans 7.1, Wicket 1.4.10 with Wicket extension 1.4.10. I want to use the datePicker, but Netbeans are not able to identify DatePicker as a class. I have searched the library and cant find
Would I need it in order for my VB.NET 2.0 client service to perform those actions? Is the Azure SDK only for web development?
Do I need to create a new distribution certificate or anything special before building and uploading to Apple a new version of my existing app? Or do I keep everything else the same as before save the
I'm new to Ant. Can someone please tell me what value to put for the 'classpathref' for taskdef? Will it be the path of the class file? If yes can an example be given because I tried that and its not
i have included a file in another file and now i want to use on of the functions from the included file. when i go to the included file and put a variable there the variable get passed and its all goo