At the top in orange is the criteria table. Under that is a table of user based information. Names, Bosses, Individual Parts Attacked etc… What I would like to do is extract specific information based on the criteria table at the top and have that information auto populate to the list on the right.
In my example workbook I highlight the information I would like auto populated. I also added examples of what they should return.
Any help would be greatly appreciated.
Table.ods (19.0 KB)
Can not understand anything. I have applied advanced filter criteria to your data. What’s next? Well, try to explain everything in a more intelligible way using the example output.
So, the first sheet should have the data in its original state. On the second sheet, what needs to be obtained as a result of filtration, etc. Fill in manually please.
Merry Xmas and bye
Merry Xmas!
Maybe because people like you, too much smart for us, considering that anything you should need it’s in the help Advanced filter.
Marry Xmas.
Now and then I need to ask myself if I can’t find somebody else being clever enough to understand my question.
As mentioned. I wasn’t looking for a “filter” of any kind. I was looking for a way to code it.
I’m sure there are other ways to do it, but someone was kind enough to help me out, so I’ll help out those who may be looking for something similar and share what they gave me.
Unsure why you all had to get pissy about things, but whatever, I got my solution and I don’t have any of you to thank for it. Hope this helps someone else in the long run.
TEST2.ods (22.9 KB)
@Boaesh1: Formulas should be the same as possible for the quick restoration of an overwritten formula and filling them quickly. For instance,
Syntax Excel R1C1 >> R2C18: =IFERROR(VLOOKUP(RC17;R2C49:R9C57;COLUMN()-COLUMN(C17)+1;0);"")
The same formula for R2C18:R17C25.
Insead of:
Syntax Calc A1 >> R2: =IFERROR(VLOOKUP($Q2;$AW$2:$BE$9;2;0);"")
See: VLOOKUP Index is 2, 3… They are constants. In the screenshot, formula syntax has been changed to Excel R1C1.
And so on…
And you should use named ranges whenever possible. E.g., players & bosses named ranges.
Without these general approaches, it’s easier for you to figure out what you are doing yourself…
Not helpful in the least. Please stop posting here.
@Boaesh1: Same to you…
You could not appreciate good advice here either. We are far away. Digging into your code is a punishment. But using named ranges is one step further*. Everything has its time. You don’t value other people’s time. Nobody will understand your example, because it contains the responses to your secret desires. Do not answer.
@JohnSUN: We need also to extract the “DAMAGE DEALT”, but the text refs (e.g., Return M15) seem to be indicating to wrong cells (body parts do not match). Aside from using the advanced filter here, you probably just need to use implicit intersection. But for this you need to create ranges of rows and columns in the data source. But what is the row identifier in the data source is not clear.
BTW, the advanced filter is not a manual solution at all, but is fully automated with a little macro code. But the OP’s question went beyond the discourse format. And I personally don’t want to waste time on developing a solution.
A very strange expression of gratitude. Aren’t there other words in English?
P.S. In addition, the OP, due to his short-sightedness, did not even notice that he was talking to one of the LibreOffice Calc developers (not me) in his usual manner of communication.
I don’t value your advice. It’s always condescending. You don’t help. You complain about what is provided for you to work with, when nobody asked you to work with it. I sought outside help and got a result within moments. No bitching, no complaints, no false solutions.
Keep complaining. It’s all you’re really good for. Clearly no solution has come from any of your responses. Why you keep returning to this post is beyond my comprehension, but alas you continue to.
On the contrary, I try to help. And many people help me too. This is a reciprocal process. Don’t be so acidic. Well, God bless you…
I wish I could find out that place… This is a rhetorical phrase. No need to answer.
You failed with me.
Try Google. Let me know how it goes.
No, that’s not the answer anyway.
I don’t know your age, but I guess you are not young. No need to quarrel.
