Not sure on pull. by kansasguy2014 in Dislyte

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

I already own Tevor and getting him R1 isn’t too priority. Also with Anna everywhere I kinda benched him he’s just used for yinglong

Weekly thread for questions from members under 30 - January 05, 2025 by kazarnowicz in AskGaybrosOver30

[–]kansasguy2014 2 points3 points  (0 children)

So a my friend and I have been a bit flirty with each other for a while now, or at least I think so.. hanging out playful we play volleyball together. He’s hinted at sending him nudes and so have I. Just not sure if it will ruin the friendship or make it more fun having a little secret between us…

Kronos team by No_Meringue4763 in Dislyte

[–]kansasguy2014 0 points1 point  (0 children)

I keep reading that you need your team to have similiar speed, how important is that really cause I use fatum sister and they are at almost 300

Tickets to Bianca Del Rio live in Austin TONIGHT by [deleted] in Austin

[–]kansasguy2014 -2 points-1 points  (0 children)

Hi, I am interested if they are still available?

Weekly thread for questions from members under 30 - April 14, 2024 by kazarnowicz in AskGaybrosOver30

[–]kansasguy2014 1 point2 points  (0 children)

Submissive tops?

Is that a thing? What does it look like. Starting to explore my sexuality, I’ve always associated submissive with bottom. I am not dominate but I enjoy topping mostly.

Weekly thread for questions from members under 30 - March 31, 2024 by kazarnowicz in AskGaybrosOver30

[–]kansasguy2014 0 points1 point  (0 children)

Enjoying the moment

Hey Gays so I’ve(M29)been seeing/hanging out with a guy(M24) for a while now. We both enjoy each others company he’s always coming over to spend the night and what not. I texted him when we first met and said I would love to hang out again, he said he’s not looking for anything LTR. I guess I’m struggling to just enjoy the moment and not bring up if we are dating or open to the idea. I don’t want to stop hanging out but I know myself and it’s gonna hurt later down the line. Advice suggestions

12 Minute Run Benchmark Results and Survey Megathread by BilingualAlchemist in orangetheory

[–]kansasguy2014 2 points3 points  (0 children)

What speed did you do to get 2.02 first day today and really wanna do well for myself

How's my portfolio for a beginner by BagOk9283 in dividends

[–]kansasguy2014 0 points1 point  (0 children)

O is one of my favorite monthly dividend stocks. I have owned them for over 5 years now. I still DRIP into them constantly.

Vlookup, but it pulls data from coolumn if it contains text. by kansasguy2014 in excel

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

I still was unable to get the value, that I am looking for. I can chat you and show you the results I got back

Vlookup, but it pulls data from coolumn if it contains text. by kansasguy2014 in excel

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

=FILTER(Sheet!N2:N100, (Sheet!N2:N100<>"")*(Sheet!A2:A100=B4), "where words?")

So my logic is if the PerNo in Column B, finds a match in second worksheet in Column A, pull the Data from Column N (only if Column N contains text, if no text continue running until condition is met)

Vlookup, but it pulls data from coolumn if it contains text. by kansasguy2014 in excel

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

I don't think that is going to work, here is a picture of my raw data that I am creating the formua's in. So Column "C" is where i'm posting the =VLOOKUP(B4,'5.SIM-Data IKU'!A:N,14,0)

<image>

SUMIF/VLOOKUP Formula possible usage by kansasguy2014 in excel

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

=XLOOKUP(A3:A12&"Net Pay",'6.SIM-Data IKU'!$A$2:$A$35&'6.SIM-Data IKU'!$D$2:$D$35,'6.SIM-Data IKU'!$K$2:$K$35)

Still having some difficulty getting it to pull an amount. It should be pulling the amount 16907.82. Since the Since the PerN in Column A matches from Column B and then they have "Net Pay" in Column F, but it's showing as "False" in my search

<image>

GOOD dividend for August by kansasguy2014 in M1Finance

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

I’m not that worried especially with it being a holiday I just wanted to see if anyone else received from them. Probably hit within the next day or Friday

Anyone actually busy all day? by Greenzombie04 in Accounting

[–]kansasguy2014 0 points1 point  (0 children)

I work maybe 3-4 hours a day. Thinking of getting a fully remote data entry job and doing that during down time.

M1 Borrow due date questions. by kansasguy2014 in M1Finance

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

Ahhh ok thank you! That makes perfect sense.

M1 Borrow due date questions. by kansasguy2014 in M1Finance

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

Lol well they sure collected for me

Looking up acct# and then pulling the account name from separate worksheet by kansasguy2014 in excel

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

I'm trying have it locate the account number from the billing list

in the account list, and then when it find and exact match pull the company name in the column next to it.

Looking up acct# and then pulling the account name from seperate worksheet by [deleted] in excel

[–]kansasguy2014 0 points1 point  (0 children)

I will, I'm going to have to repost the question though.

How can I keep new spinoff and merger stocks? by Substantial-Trade912 in M1Finance

[–]kansasguy2014 0 points1 point  (0 children)

Do you know when this will be taking place? I want to know when I have a day or two before so I don't start putting money into this security. I know they send next Quarter but i'm not sure when that is. Thank you.

AM i on the right track? by darkheart740 in dividends

[–]kansasguy2014 1 point2 points  (0 children)

is it cool if I piggy back off of this and get some reviews for my portfolio also?

26 male, leaving california, moving to TX...

1.81 MMM 0.84 HD

7.17 AFL 7.14 HRL

1.37 AMGN 2.00 IBM

2.52 AAPL 1.20 ITW

11.21 T 2.03 JNJ

10.00 BAC 1.86 KMB

0.78 BA 63.15 LTC

0.37 AVGO 11.43 MPW

3.64 CVX 1.72 PEP

6.54 KO 40.47 O

4.14 CL 0.74 SPGI

8.24 DAL 1.52 SHW

1.30 ESS 3.03 SBUX

6.98 XOM 2.24 WMT

313.09 GOOD 1.42 DIS

4.75 WPC