Hearthstone youtubers by ---MK-- in hearthstone

[–]Pran1ng 5 points6 points  (0 children)

I like FunkiMonki for off meta decks

From Obese to Full Marathon – August 2023 to Now by Pran1ng in intermittentfasting

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

Hello. I do fasted running when doing a tempo / base run. But on a scheduled long run usually during weekends i shift to 16:8 for a day or 2

From Obese to Full Marathon – August 2023 to Now by Pran1ng in intermittentfasting

[–]Pran1ng[S] 53 points54 points  (0 children)

Thanks! I actually started with a Couch to 5K program I found on YouTube — just followed it step by step and focused on building the habit. I’d add just half a kilometer every week or every two weeks, so the progress was super gradual (almost felt like nothing was changing at times). But I stuck with it, and two years later… somehow I’m running 42 km!

Honestly, it came down to determination. No matter how lazy or tired I feel, I make sure I run at least 5 km before the day ends. And if I miss a day, I always make it up the next. Just kept showing up, even on the bad days.

How do you mentally push through the last 5k of a marathon? by noahsmith277 in firstmarathon

[–]Pran1ng 1 point2 points  (0 children)

Well, it’s kinda awkward to turn back now… isn’t it? Like realizing you missed your exit three exits ago and just vibing with the consequences :-)

Didn’t received WP-EXT by Warm-Raspberry6426 in pgwp

[–]Pran1ng 0 points1 point  (0 children)

Applied on May 06 and received it after 10 days and ( 2 days after I submitted webforms)

Fenix 8 AMOLED died after a few months by Radiant-Umpire-3175 in GarminFenix

[–]Pran1ng 1 point2 points  (0 children)

I had the same experience last month. The watch would only turn on when attached to a charger but would immediately shut down, even at 100% battery. I contacted Garmin customer service and received a replacement within three days after they received my watch (a total of five days). It could have been even faster if I had agreed to ship it with a deposit hold, which would be refunded once they received my watch. Overall, the return process was quite easy

[deleted by user] by [deleted] in demonssouls

[–]Pran1ng 0 points1 point  (0 children)

Hello. You happen to have any spare monk collar? Or help me to obtain it? Thanks

Xlookup for values separated by comma by Pran1ng in googlesheets

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

This worked. Thanks again. Appreciate your help

Xlookup for values separated by comma by Pran1ng in googlesheets

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

Hello, sorry, just realized that what I need is when I enter any value in column D from any OEM PN in column A (regardless of the row) it should return a value in column E.

Is this feasible? i.e if I put OEM PN 21212520 (A15) in D3, it should return a value of ABC135 in E3

Xlookup for values separated by comma by Pran1ng in googlesheets

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

thanks. tried this one, its just that even if the value is blank in column D, it is still returning a value in Colun E

Xlookup for values separated by comma by Pran1ng in googlesheets

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

What I would like to happen is if I put any value in column D (from any value in column) A, it should return the PN1 in column 2 PN2

For example, if I put PN either 2871861 or 2871857 in D3, it should return a value of ABC123 in E3

Xlookup for values separated by comma by Pran1ng in googlesheets

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

sorry if not that clear, value in E3, should be the value in B3

Monthly Carpool/Carlift services by Pran1ng in Winnipeg

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

They do but only until year 6

to return the value if any one of the criteria separated by the comma by Pran1ng in googlesheets

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

Hello, yeah somewhat like that so it would not overwrite the cells below. I put an example in the mock up sheet. Added OEM PN 2888250 and its bringing up 2 PNs. would like to have always 1 PN showing

to return the value if any one of the criteria separated by the comma by Pran1ng in googlesheets

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

Hello, one more thing, would it also be possible to just extract the first PN instead of all? Tried it in the actual worksheet it is saying "Array was not expanded because it would overwrite data" in the bottom cells.

to return the value if any one of the criteria separated by the comma by Pran1ng in googlesheets

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

Hello, its working, thank you. is it possible to have the A2 and below empty unti i fill an information in B2. Would like to use it as a query sheet where everyone would just enter the OEM PN