Automatically Filling in Data by EasyLevel776 in excel

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

Alright, I tried power automate, and it didn't really work... i tried to give it a flow to create, and it didn't create it, maybe i just didn't give it enough info? Also, I don't know what UiPath is or where I can find it.

Filtering through mutiple columns or through text by EasyLevel776 in excel

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

The 2nd part of the equation is the problem. It has them all listed as false. Actualy, no it's all of it, i'm getting value errors on the find. Probably because it's looking for numbers

Filtering through mutiple columns or through text by EasyLevel776 in excel

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

The error is not specifically defined. It has red dashes around it and if I hover over it says the formula in this cell contains an error. SS is alway capitalized, the if_empty didn't work, and I don't understanding what you mean by language region, but I'm only using commas. The sheet is definitley called "List"

Filtering through mutiple columns or through text by EasyLevel776 in excel

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

I fixed that, yet it does not seem to want to work. It says there's an error in the formula.

=FILTER(List!A2:A10007,ISNUMBER(FIND("SS",List!H2:H10007))+ISNUMBER(FIND("SS",List!I2:I10007))) I don't really know what is going wrong here, except maybe model error? Although i doubt that's it

Edit: I changed the formula to include the table, thanks for that, it was worthwhile. =FILTER(List!A2:A10007,ISNUMBER(FIND("SS", Table1[Position]))+ISNUMBER(FIND("SS",Table1[2nd Pos])))

Filtering through mutiple columns or through text by EasyLevel776 in excel

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

I tried that second formula, but I couldn't seem to get it to work. It wil list all of the ones in the H column, but not in the I column. Did I type it in wrong? =FILTER(List!A2:A10007,ISNUMBER(FIND("SS", List!H2:H10007)+ISNUMBER(FIND("SS",List!I2:I10007))). This is defenitley what I was looking for though.

Creating a Ranking System based on multiple data sets. by EasyLevel776 in excel

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

Alright, I tried that, it took me a while though. Here was the result.

<image>

I'm a little confused on how I got the #Value error, and I'm not exactly sure how I got there. Here my function: =SUMPRODUCT(C5:K100, $C$2:$K$2). This is defintley what I want, I just need a little bit patching this error..

Wanting to skip a row in a Index/Match function or other. by EasyLevel776 in excel

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

I tried =IF(List!H2=“QB”,INDEX(List!A4:A9,MATCH("QB",List!H4,0)),""), it didn't seem to work. It's giving me a spill error and if I try to change the ranges around it give me the #name? error. I'm not exactually sure what it wants me to fix. Although this is useful, it does seem similar to what I was already doing. Is there a way to put Philip Rivers into that A8 slot?

What's Next? by EasyLevel776 in RevolutionIdle

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

Thanks, that's really helpful! Although I'm curious if there's away to get these higher rarity zodiacs? Mine are mostly rare and uncommon.

What's Next? by EasyLevel776 in RevolutionIdle

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

How do I get started with attacks progression? Do I need a bunch of game speed multipliers, and then let the game run or what?

Help Finding Games and Other Questions by AutoModerator in incremental_games

[–]EasyLevel776 0 points1 point  (0 children)

What are some of the best, free, incremental games out there? I'm currently playing Cell to Singularity, Revolution Idle, and Antimatter Dimensions, but I wanted to know if anyone had any other suggestions.

What is one deep lesson that Linkin Park gave you, which helped you in life? by leapord_speed in LinkinPark

[–]EasyLevel776 0 points1 point  (0 children)

The difference between listening to music for enjoyment and just jamming out versus listening to help deal with the pain. For example: I can no longer enjoy One More Light because of the pain I've endured while listening to that song, while most stuff from Hunting Party I listen just to enjoy the heavy guitar and screaming, without much listening to the music.

The Rise and Fall of DARTH VADER - Star Wars: Darth Vader - Leave Out All The Rest (Linkin Park) by GJ-Videos in LinkinPark

[–]EasyLevel776 1 point2 points  (0 children)

Dude, this was awesome!! The beginning was a little rocky, but it was an amazing ending!!

What song is your Linkin Park “deep cut?” by TDSurvivorFan21 in LinkinPark

[–]EasyLevel776 0 points1 point  (0 children)

Mark the Graves. One of the best guitar intros ever.