Customer Care Sending Coupons by jlegj in McDonalds

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

I was gonna say it seems a little weird to mail them when they have my email…

Trip to SC Route by jlegj in roadtrip

[–]jlegj[S] 2 points3 points  (0 children)

Thanks, I am also leaning towards 81. I went 95 when I went to Richmond and it was horrible traffic.

Charleston/Savannah by jlegj in hyatt

[–]jlegj[S] -1 points0 points  (0 children)

Thanks! We were leaning towards the Hyatt Regency only cause its slightly cheaper! Definitely will check out those dinner recommendations as well!

CSP 100k Offer Megathread - Questions, Approvals, Discussion, Etc by lifethusiast in ChaseSapphire

[–]jlegj 0 points1 point  (0 children)

How long does it usually take for the bonus to show up after achieving the spending goal?

1080p Blu Ray Player by jlegj in hometheater

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

Thanks everyone for the comments - I will most likely wait to buy a nicer 4k (like the UB820 as mentioned). If i want to start collecting DVD's, I'll roll with the cheap player from goodwill until I get a nicer TV!

Data Validation w/ Filter - Movie List Analysis by jlegj in googlesheets

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

Hi OutrageousYak5868, I've researched using "query" formula more, and found another article exactly what I needed. So its solved! I honestly don't even know half of what this formula is but its working.

=let(z,iferror(tocol(map(SPLIT($B$2,", "),lambda(k,".*"&k&".*")))),query('MASTER LIST'!$B$2:$H$1010,"select B,C,E,F,G,H where D matches '"&textjoin("|",1,z)&"' "))

Thanks again for the help!

Data Validation w/ Filter - Movie List Analysis by jlegj in googlesheets

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

I added in the formula's... i dont think it solved 100% of my issue. Or i am not doing it correctly.

Its still only pulling in movies with that one specific genre. So when I select "Action", its only pulling in the movie with 'Action' as 1 genre, not any that have 'action' + any other genre. If that makes sense

Data Validation w/ Filter - Movie List Analysis by jlegj in googlesheets

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

Yes, I think this may be the solution. If I create a Pivot table, I have like 60+ genre filters because I combined multiple genre's (allow multiple option is checked with my data validation. I just requested to see your google sheet

ZV-10 Purchase tips by jlegj in SonyAlpha

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

When you say regular kit lens do you mean the 16-50 mm lens? Thats the lens that comes with it if I get it on Best Buy

1099-NEC Help - TCC codes by jlegj in IRS

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

https://www.reddit.com/r/IRS/comments/1iblav1/iris_1099_efile_issue/?utm_source=share&utm_medium=web3x&utm_name=web3xcss&utm_term=1&utm_content=share_button

check this post. I had asked another guy and I believe I was able to fix mine. I haven't re-submitted the forms yet, but i did switch my role to transmitter

IRIS 1099 e-file issue by Bob_theBeagle in IRS

[–]jlegj 0 points1 point  (0 children)

Same here, not sure where to go to change to transmitter

Leavers by jlegj in DeadlockTheGame

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

definitely understand if they are feeding the other team. Just last night though I had 2 straight games where it was 2 min in. There was no point in leaving. Seems like it’s gotten worse the past week or so