ah solver outputs makes sense, iirc the other guy was doing hand histories

you can filter these by the result (if unsure what i mean highlight A1 through E1 and click the filter button under the data tab

then you can just view the mono ones, manually change the color, then switch to another, etc,

there are probably a few dozen ways of solving this but this is by far the easiest one i come up with without google searching

How do I do a function such that if cell is > 100, color green.

Or if cell is negative, color red.

I'm not getting how I should be using the filter.

Here is my spreadsheet so far.



I'm playing around with custom autofilter using contains after highlighting all of the flop column but I'm not sure how to get it right.

highlight the region and on the home tab there's a conditional formatting button, go to new rule and voila

the issue with the other request is it's multiple variables that are text, i can get it to go green if it has a "d" in it for diamond but i don't know how to get it to count how many different letters there are so found that work around where you get that last cell to easily sort and then manually change the color

never been good at the conditional formatting stuff since i'm colorblind and it'll casue more trouble than good - but it is very nice for error checking, ie set up a rule where is a certain value pops up it'll get highlighted so i'll know there's a bug

I have scraped data from a sports book, and I want it to look like SBROdds
https://classic.sportsbookreview.com/betting-odds/

I have a fully editable Google Sheet right here, with screen shots and more detailed info:
https://docs.google.com/spreadsheets...it?usp=sharing
(anyone with a link can edit)
The "Main" tab will have desired output.

looks ambitious, that requires a ton of time involved, probably best outsourced to fiver imo

Mine, right?

At first I thought it would be easy, then when I dove in... it wasn't.

Thanks, I will try that!

yeah pretty much, honestly though, once you go to paying someone in Bangalore or Moldova to do it you may be better off at same cost making it into a web app or something - just spitballing here but if cost of hosting it on a server not an issue that would probably be better than constant excel data pulls

Thank you! Great idea!

Check out the betus_output tab, columns R - Y. I was able to get the data how I want so far, using =Index
Now I'm just looking to automate my Python scripts and link that to Google Sheets for 100% automation! Should be doable!


https://docs.google.com/spreadsheets...gid=1557687371


=iferror(INDEX(M:M, SMALL(IF(($P$4=$I:$N), MATCH(ROW($I:$N), ROW($I:$N)), ""),ROWS($A$1:A1))),"")

Is there anyway I can use an =IFS instead of =IF, so I can look at the date and the listed pitcher?

i tried a few "P4"&" "& but that bricks the time into code which i'm pretty unfamiliar with personally

I would personally do an additional cell for pitcher name but i'm sure some time on stackoverflow could resolve this & function bricking the time display

goodluck

I don't have time to play with it but couldn't you you could use And(($P$4=$I:$N),($O$4=$I:$N)) to return true only if both are true?

Thanks for the input guys, so I combined Pitcher with date and am using the same formula. I now have the desired results!

It looks at this now:
Yu Darvish2020-07-30

Oh, I'm sorry I misunderstood the question the first time. I shouldn't try to look at something like that on a 10 minute break. Glad you got it to work!

rickroll, Excel uses a number for dates so when you are doing a concatenate with dates you need to use the text() function to turn the date code into a string you want to work with. Like text(C4,"YYYY-MM-DD") for h_ven's date format.

i've been making dfs projection and ownership composites with pivot tables, but there's a lot of inconsistent spellings (jr smith vs j.r. smith) that im getting tired of fixing.

ideally id like to build a sheet where i can paste the projections in and they fix all the different iterations into one common spelling. any suggestions? thanks!

Fuzzy lookup extension is exactly what you need
https://www.microsoft.com/en-us/down....aspx?id=15011


This extension literally changed my life. Pm and I'll happily walk you through it via slack/dms if you have any questions

ty sir. ill dig into it before i bother you too much

Can you help me with an Excel formula? I'm trying to keep records of my play and the way my formula is set up (obviously wrong), if a loss follows a win or vice versa, when I extend the formula to the next cell, it will show as a loss or win based on what the previous one was, rather than the true result. Hope this makes sense.

These are the columns I am looking at: (date and Type are not part of the formula, so these fields are sufficient).


A) Cost (for SNG or MTT only)
B) Won
C) Lost
D) Profit
E) Account Balance
F) Running Profit & Loss (would like to see a loss show in red)
G) Running Total of Deposits

For all fields I am using Category = Number / Negative Numbers = 2nd choice given

If I need different fields, I can substitute them. I am mainly concerned with just being able to input that day's result and then have the formula do the math and I can copy/paste.

Thanks.

easier if you post some screenshots including what your current incorrect formula is

or upload the file somewhere

just discovered how to change fractions that import as dates when scraped back into numbers

=--TEXT(A1,"m.d")

so if you had a fraction of 2/3 that imported as Feb 3rd this will reveal 2.3

can also just grab each into separate cells =--TEXT(A1,"m") etc

doubtful anyone is specifically dealing with this, but it's been a nightmare for me as scraped data often imported as dates and all the answers I found would not work on my edge case where the original fraction never existed as far as excel is concerned

hey guys, so sometimes on my multi year old worksheets that are regularly updated i end up over time adding an insane amount of blank rows at the bottom - not sure how this happens but it does

on some sheets i'm able to highlight and delete them, on others that doesn't seem to work and I'm unable to find solutions to this via google

imagine you have a worksheet where you only use the top 200 or so rows but there's 100k blank ones underneath

I'd ideally prefer to be able to remove the blank ones cause they slow it down like crazy rather than copy the good part to a new sheet because there are so many connections to other sheets it'd be a nightmare to go through and change them all

appreciate any input - if i highlight the columns they won't delete as they normally do in other occasions
https://support.microsoft.com/en-us/...rs=en-us&ad=us

edit: nvm, after realizing i wrote columns here instead of rows and edited it for clarity, resumed google search but used rows instead

If you press ctrl-end, does it go to row 8675309 or row 200?

i thought that help page would help me but apparently not

hitting ctrl-end takes me sideways to column xyzx or something crazy like that

i've resigned to creating a new worksheet and just rebuilding the links because the million cell tab is just untenably slow - it seems i created this by selecting entire columns for formatting instead of just a few cells - so will remember that going forward

edit: omg i feel like an idiot, i could have just cut/paste the section i needed to a new tab and the linkages would have carried over all along - problem solved it seems

Holy hell, I just discovered that there is a function called IFS that just takes as many condition and result pairs as you want. I've got spreadsheets with nested IF garbage so deep that it takes me a long while to parse the ones I created. IFS is sooooo much cleaner and easier to read. I hope it is a new function because I've just been an idiot for 20 years I'm going to be really pissed off.

Added in Excel 2019.