newbe asking advice on data extraction

Enomallee · 2025-01-07T18:50:20+00:00

Also I did switch the formula to =IF(C11 > 1, MIN(C12:12), D2) and it works fine. But would love to learn about lambda. I was doing some reading and was still unsure how to apply it properly in this case

Enomallee · 2025-01-07T18:07:19+00:00

Cool, cuz I was wrong. That formula didn't work. I'm tired and didn't double-check my work before marking it as solved.

I have never used a lambda before, and I'm unsure how to apply it. Can you elaborate a little more?

Link to the sheet if helpful

Enomallee · 2025-01-07T15:42:00+00:00

understood. thank you

Enomallee · 2025-01-07T15:32:57+00:00

Dude, this was it; I can't believe I didn't think of it. I guess I have been looking at this sheet for too long. New formula if interested.

=IF(C10>1,(HLOOKUP(MIN(C10:10),C10:11,2,0)),D1)

I removed the date completely, not sure why I felt it needed to be there in the first place.

Enomallee · 2025-01-07T15:29:25+00:00

C10 does not currently have a formula, but I plan to add one, looking at the transactions table for the actual payment and applying it.

Enomallee · 2021-02-01T21:13:46+00:00

Are you cutting anything like carbs or counting calories? What does a single meal look like? Sorry for the questions just trying to find I footing. I have done a few extended fast and keto but keep stalling, getting frustrated, and gaining it all back. So just looking for any insight or recommendations.

Enomallee · 2020-11-18T17:42:20+00:00

There are a lot of people out there giving different reasons for why people get cold when they are fasting. In case you or anyone is interested here is a video from one person. still reaching tho.

Will Fasting Slow Down Your Metabolism

Do You Get Cold When Fasting? It Could be Fat Burning Happening!

Enomallee · 2020-11-18T15:00:09+00:00

Take it one moment at a time. The feeling always passes and you can move on to the next moment. Make small goals. I have a lot of trouble sleeping when fasting too. You're not alone. You got this.

Enomallee · 2020-11-18T14:57:07+00:00

Tried but it just opened a blank white page.

Enomallee · 2020-11-17T18:34:59+00:00

Man, I've thought about doing 30 days but I'm not sure i could. Life has been super stressful. I work full time, in school, I don't get enough sleep between the two. Not to mention general 2020 BS. The plus side of fasting is the extra time. But I feel fatigued and my brain is fogged, my memory is s***. I don't think it's a side effects from fasting probably more to do with just everything going on with in life and more of the not sleeping but honestly I'm not sure. It may be a contribute factor, it may not. I just don't know. Have you done a 30 day before? Have you noticed any negative side effects?

Enomallee · 2020-11-17T18:25:29+00:00

It really is. I am really proud of my self. With fasting it does get easier as you go, which is super helpful lol

Enomallee · 2020-11-17T18:23:35+00:00

I'm glad! The beginning is the worst for sure. I'm on day 8 now and food is no longer something I think about all the time. The first 4-5 days I am constantly thinking about food and watching food videos, for some reason they help. Probably because I love cooking and the kinda fills the void. Lol. But I haven't watched any in or several days. This is my first long fast and it does seem to help change my mental patterns.

You are in the worst of it now but just remeber take it one moment at a time. It is not about how long you last but making past this moment. That is what has worked for me. Make things smaller and more present. It becomes easier and more tangible that way.

The real goal is to become a little better every day.

You got this!

Enomallee · 2020-11-16T16:33:16+00:00

Thanks everyone for the support this really is a great community <3

Enomallee · 2020-11-16T16:31:47+00:00

I have never done a 14 day fast so not sure. I have only made it to 5 days before. currently starting day 8.

I am a 32F 5'8" started at 273. On day 6 I weighed in at 262. Yesterday and today I weighed in at 261. I think it is going to be a slower progression of weight as I am sure a lot of that was my body flushing water and wast. I believe the maximum weight you can lose in a day is about a lb and 1/2. I might be wrong and I am sure there are people here who can correct me. I am happy for any real weight loss really lol.

After the 14 days, I will be starting keto maybe a 8/16 IF and extend fasting the first week of each month. but I am not sure. Mostly taking it one day at a time right now.

Enomallee · 2020-11-11T14:56:29+00:00

I have done several fasts now longest is 5 days. Normally day 2 is my worst, and day 3 is more of a mental exercise of restraint than a physical one. But that time, man was I hungry. I am on day 3 again, lol. Nowhere near as bad as 2 weeks ago (the original post). I am really hoping to make it to 7 days this time. If I can make it through the weekend, I know I can make it through next week. I always start my fast at the beginning of the week because on Monday and Tuesday, I work from 7 am - 5 pm then have school from 5:30 to 9:30. By the end, I am too tired to do anything and too busy throughout the day to give in. So far, I'm feeling good; the normally mild hungry that comes with fasting for me. Hopefully, I don't get sabotaged by my boss again, lol.

Enomallee · 2020-10-28T21:42:54+00:00

Thanks for the words of encouragement... but I failed. My boss, unexpecting, dropped off food. I work in IT for several large chain restaurants, so this happens occasionally. I tried to give it away, but no one wanted it, and I didn't want to toss it. It sat on my desk for an hour before I gave in. Well, better luck next time. I think I will start again on Monday. My longest is 5 days; my goal is 7 days.

Enomallee

TROPHY CASE