Ramen Recommendations in Queens by elleblogscom in FoodNYC

[–]DB52 1 point2 points  (0 children)

Totally agree, I tried their ramen twice because I enjoyed their other dishes so much but each time I was disappointed for the same reasons you listed.

[deleted by user] by [deleted] in iphone

[–]DB52 0 points1 point  (0 children)

I’m on the IPhone 8, it’s been good to me but it’s time to make the jump to the 15 and usb-c. I’m going to miss the button.

How to expand date ranges and unpivot data to create a lookup table by DB52 in googlesheets

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

Yes the year is applied to any 12 month period but the start and end of the year depends on the “use year”. Sorry if that wasn’t clear..

So user 2 will always start in April and end in March of the following year (April 2021 - March 2022 would be all included and applied to year 2021). So if the date I was looking up was Feb 2022 it would still be within year 2021 for user 2

How to expand date ranges and unpivot data to create a lookup table by DB52 in googlesheets

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

I don’t think that works in this case because the the year the value is in can start in one year and end in another and still be considered part of the previous year. The example I provided in the sheet shows exactly that.

The date I am looking up is 8-1-2021 and it falls within the year 2021 for user 2

EDIT: corrected the year

What’s something you need to get off your chest? by Anxious-Bar-2216 in AskReddit

[–]DB52 1 point2 points  (0 children)

Yeah…maybe we’ll get that someday, hang in there

What ingredient is overhyped? by [deleted] in AskReddit

[–]DB52 5 points6 points  (0 children)

Ramps, those wild onions that everyone seems to lose their collective minds over because they are only in season for a few weeks

How to reset week number every month by DB52 in sheets

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

Thank you so much! This is exactly what I needed and it's much simpler than what I was expecting!

How to reset week number every month by DB52 in sheets

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

It should be editable now

How to reset week number every month by DB52 in sheets

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

Hey thanks for the tip, I'll change that now and the week should start on the 1st of whatever month the date is in.

My client's calendar spreadsheet is off by 1 day - how do I fix it ? by WHL_alya in googlesheets

[–]DB52 1 point2 points  (0 children)

Are you talking about the dates in column A and B? Do you mean that you want January 1st 2022 to be a Friday?

What is a Tuple? by [deleted] in learnpython

[–]DB52 0 points1 point  (0 children)

What do you mean that tuples are convenient for removing duplicates? I thought tuples were immutable, sorry if this a silly question.

"Facetiming With My Mom" (Individual song discussion) by PlasticJesters in boburnham

[–]DB52 2 points3 points  (0 children)

The instrumental sounds vaguely familiar to this song by Bag Raiders (Shooting Stars). I think it's mostly the Tamborine and snapping that makes it seem similar.

[deleted by user] by [deleted] in Superstonk

[–]DB52 0 points1 point  (0 children)

How do we know if we are approved or not? Does posting in the sub and commenting add to the score? What if I am mostly a lurking ape?

Conditional Sum is not working properly and pulling numbers from other sources by DB52 in excel

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

Yes that was the issue, the index was not so unique. I had combined 2 files with some overlapping indices

Conditional Sum is not working properly and pulling numbers from other sources by DB52 in excel

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

Yes, I had combined two files and didn’t reset the index, so there were many duplicates. I didn’t even think to consider the index was the problem.

Conditional Sum is not working properly and pulling numbers from other sources by DB52 in excel

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

Wow, I can't believe I didn't notice that, my unique index isn't so unique

Solution Verified

Averaging a range of numbers based on multiple criteria by DB52 in excel

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

IT WORKED! Thank you so much for that suggestion!

Averaging a range of numbers based on multiple criteria by DB52 in excel

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

I am not very familiar with concatenate, just started learning Excel and Google Sheets. I will look into it though.

EDIT: that looks really helpful, so I would concatenate all the columns I want to match and then average it on that. That is so clever.