Keyword Categorising

This may be close to what you are looking for:

Please Login or Register  to view this content.

Confirm with CTRL+SHIFT+ENTER

However, mine formula searches for whole phrases, not just single words, which would complicate things. For example, the first returned phrase is "meal planner" for modularity class 0. Then for modularity class 1, there is no mode, since none of the phrases are repeated, so an N/A is returned.

I know this isn't exactly what you are looking for, but perhaps a start.

Hope this helps.

When you say column I goes "up to 1000", what does that mean exactly? Does that mean that there are a range of 0-1000 Modularity Classes? Because if that is the case, you will be fine, since as you drag the formula down, it will look for the next most common phrase within the next Modularity Class. This is made certain by the ROW(B3)-1 portion of the formula, since it will give you an incremental increase in which Modularity Class to pull from, starting with 0.

I'll assume that you're acknowledging my previous posts in this message; if not, then disregard. The only thing in the formula that will need to be altered is the actual cell ranges for all the references. You could use column referencing (B:B, H:H, ect.), but it would take up more processing power.

Other than that, the formula does not need to be altered for each modularity class. This is because the formula is looking through the entirety of data in column I, and saying give me the most common phrase used, but only if column H contains "0" (this is for cell I2). Then once you drag the formula down one cell, it repeats the same process, but for modularity class 1. The reason it returns an #N/A is because there are no phrases that are entirely repeated within column I for modularity class 1.

Hope that was clear enough.