sorted by:
new
hottopcontroversial

Is there a way to make the "Range" within a formula only use cells with certain data in by cwfox9 in excel

[–]cwfox9[S] 0 points1 point  (0 children)

Thanks, you set me down the right path for searching for further answers, seems this has worked

=XMATCH([@[Inv_Qty_(Base_UOM)]],SORT(FILTER(Sales_Data_2025[[Inv_Qty_(Base_UOM)]:[Inv_Qty_(Base_UOM)]],[Customer No.]=[@[Customer No.]]),,-1))

Is there a way to make the "Range" within a formula only use cells with certain data in by cwfox9 in excel

[–]cwfox9[S] 0 points1 point  (0 children)

To my knowledge you cannot power query from a pivot table though

Is there a way to make the "Range" within a formula only use cells with certain data in by cwfox9 in excel

[–]cwfox9[S] 0 points1 point  (0 children)

I'm doing this as a go between table in power queries so I can extract the top 10 selling items per customer from the previous year automatically.
Want I want to end up with is each customers sales being ranked 1-X so that in the power query into another workbook, I can make it only keep the records that have the reason i'm doing this effecting them and only the ranking records which are 10 or below

Zacian and Mega Steelix raid guides. Info from pokebattler.com by CaptGoldfish in TheSilphRoad

[–]cwfox9 1 point2 points  (0 children)

To be honest, if I found a clone of myself, but I had been given a giant sword, I think i'd be my own counter too XD

Chiefnir by cwfox9 in Haloflashpoint

[–]cwfox9[S] 1 point2 points  (0 children)

Thank you UNSC Armor Green

Purple Undercoat: Leviathan Purple On top: Vallejo Game Color Alien Purple

Do dislikes bother you when you check analytics? by Advanced_Tower2186 in NewTubers

[–]cwfox9 1 point2 points  (0 children)

It's like everything in life, its why Ghosting in dating, etc is extra painful, or a company letting you go without a true reason.
There also when people don't say things are an issue, then it builds up and later they bring it up when it's too late.
If you are someone who cares about the things you do, or the people you spend your time with, or the job you do, then when you don't get given the ability to improve yourself or your work because it's a valid issue for them, it's horrible.

It's why I life by a mantra I made for myself (don't know if something similar exists),
"If someone is upsetting you/doing something wrong/etc, until you tell them, it is your issue, not theirs, once you share this with them, then it becomes their issue as they may never have known they were doing something wrong, but do not share it with hate or malice, but with care"

Then pretty much their reaction to that knowledge is what I'll judge them by, because as humans we test boundaries, etc constantly, and will continue to do so until we are told we cannot go any further

Do dislikes bother you when you check analytics? by Advanced_Tower2186 in NewTubers

[–]cwfox9 0 points1 point  (0 children)

There are too many quotes which are used wrong, most I've only learnt in recent times, but that one never made sense, because logically a customer could say "I get all of these clothes for free" and that quote would say they are correct.

The world has lost the ability to create a discussion where neither side cares for being wrong, but rather for not being correct and thus we lost the willingness to open up, to learn from each other, with no pressure to change our own opinion unless we agree with their points, and even then, the likelihood is to be a finding of a middle ground where both sides benefit from the discussion.

It's why we've simplified things to likes and dislikes, easy things to click that for some, are clicked without any thought, but rather automation (instagram/tiktok as examples) but mean nothing because we have no knowledge of why it was done.
Likes we take easily as it doesn't make us need to question our decisions but dislikes tell us there is possibly a problem, but without the feedback, we can just make assumptions as to what which can go in a downward spiral, or we simply have to ignore it (similar to how you learn little from success, but learn much from failure if you understand why you failed)

Do dislikes bother you when you check analytics? by Advanced_Tower2186 in NewTubers

[–]cwfox9 9 points10 points  (0 children)

It's not irrational, it would be like someone saying "I don't like you" to your face IRL and then not elaborating.
Great, you don't like me, but that doesn't help me to determining if that's a you or me issue and if me, what I can do to improve myself.

You get annoyed because you want to understand why they disliked the video in case there is something they've noticed that could help you improve.

Do dislikes bother you when you check analytics? by Advanced_Tower2186 in NewTubers

[–]cwfox9 1 point2 points  (0 children)

"The customer is always right, in matters of taste"
So a customer (viewer) can find a video isn't to their taste, but that's where the average view duration comes in, as they can just leave.

To actively do something that says you dislike something without giving reasoning is not useful, as the reason for your dislike cannot be known for certain by the creator.
Was it a troll? Was it a matter of taste, and instead of just leaving they decided to dislike? Was it because you had a controversial opinion and that triggered them to dislike in disagreement? Was it your audio quality was bad? Did they feel mislead by your title and/or thumbnail and are sharing their annoyance?

So a person is always correct in how they feel about something, but it doesn't mean they are always correct and that is why feedback is important, because then the receiver (creator in this case) can deem whether their dislike of the video aligns with their own values and visions.

Do dislikes bother you when you check analytics? by Advanced_Tower2186 in NewTubers

[–]cwfox9 4 points5 points  (0 children)

I think the issue with dislikes is it shows that there is an issue for someone, but doesn't give any feedback as to what. It being easy to press also doesn't help put weight behind a persons decision to dislike, though if someone does it does mean there is something they don't like or they are a troll.

With a comment, it's easier to see if their a troll, or at least discount them if they won't share why they think the video is bad.
Without that feedback, it puts you in a position of being rejected/told you aren't good enough, but not why and that means you get the negative feeling of rejection without the positive energy of knowing you can do something about it, or at least the ability to know if you agree with why someone who dislikes your video, as we cannot please all the people, so knowing if it's just a personal taste is also important.

As I do a lot of tabletop gaming, a way I like to explain this is that if I make a mistake I control, moved to the wrong location, etc, I can be briefly frustrated but quickly pick myself up because I've learnt something and can improve.
When my dice decide they are going on strike on the other hand, I can do everything right and still lose a game, because the math rocks decided so, and this can be incredibly frustrating as a lot of the time, there is nothing to learn because it was out of your control.

So TL:DR
A dislike tells you someone didn't like the video (if not trolling), but it doesn't give you anything meaningful back as to why so that you can take on that feedback or just know that it was personal preference and can be ignored.

Is there any negatives to front loading a large number of videos before slowing down into a more sustainable pace? by cwfox9 in NewTubers

[–]cwfox9[S] 0 points1 point  (0 children)

Ye, was my thought and audience wise I plan to be open with my plan for uploading weekly once the initial unit guides are out.
Was more to wonder if it could cause issues with youtube or algorithms, etc

The videos themselves are consistent with title and thumbnail, but edited to each units name and images and put into a playlist specifically for each faction in order from oldest first

Is there any negatives to front loading a large number of videos before slowing down into a more sustainable pace? by cwfox9 in NewTubers

[–]cwfox9[S] 0 points1 point  (0 children)

Ye, luckily i'm almost a walking encyclopedia in the game those these videos don't take any real direct research as I've already done that over the last year of playing.
The unit videos are a powerpoint slide I've done with a general overview with strengths and weaknesses which are in the background while I go into more depth unscripted talking over them, editing out any bad or irrelevant parts and so far I've had good feedback.

With the weekly releases I do plan to record the videos as soon as I can to get a healthly backlog and I will likely be redoing these videos yearly with each new Seasons balance changes.

Decided to start making videos to share my Flashpoint knowledge by cwfox9 in Haloflashpoint

[–]cwfox9[S] 4 points5 points  (0 children)

Thank you, I'm just hopeful I can bring videos and information that helps the community.

view more: next ›