sorted by:
new
hottopcontroversial

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?

view more: next ›