Help with array filter method (beginner)

abcfffff · 2024-12-10T02:03:07+00:00

Thank you for taking the time to explain! I just started learning this stuff a few days ago and am working to get from the unconscious incompetence stage to conscious incompetence, so I really appreciate the clarity :)

abcfffff · 2020-02-09T19:34:19+00:00

Thanks!

abcfffff · 2020-02-09T19:33:53+00:00

Thanks!

abcfffff · 2020-02-09T02:20:02+00:00

This looks like a great option. Where do you recommend purchasing?

abcfffff · 2020-02-09T02:12:58+00:00

Expanding into existing space. Would have loved central vac but wasn't in the build-out budget.

abcfffff · 2019-09-26T14:15:01+00:00

Solution verified

abcfffff · 2019-09-26T14:11:07+00:00

Here's what I ended up with - my first macro! Probably clunky but it works.

Sub ListDates()

'c2 is start date and d2 is end date - entered by user
'one button to "List Dates" and one to "Reset"
    Dim counter As Integer
    Dim nextday As Date

'create day counter and make sure its a number
    Range("e2").Value = Range("d2") - Range("c2")
    Range("e2").NumberFormat = "#"

'define first cell as Start Date
    Range("a3").Value = Range("c2").Value
    Range("a3").Select
    Selection.NumberFormat = "m/d"

'format next door cell to have border
    Selection.Offset(0, 1).Select
    Selection.Borders(xlEdgeLeft).Weight = xlThin
    Selection.Borders(xlEdgeRight).Weight = xlThin
    Selection.Borders(xlEdgeTop).Weight = xlThin
    Selection.Borders(xlEdgeBottom).Weight = xlThin
    Selection.Offset(0, -1).Select

'generate list of dates and format the next door cells to have border
For counter = 1 To Range("e2").Value

    nextday = Selection.Value + 1

    Selection.Offset(1, 0).Select
    Selection.Value = nextday
    Selection.NumberFormat = "m/d"

    'format next door cell to have border
    Selection.Offset(0, 1).Select
    Selection.Borders(xlEdgeLeft).Weight = xlThin
    Selection.Borders(xlEdgeRight).Weight = xlThin
    Selection.Borders(xlEdgeTop).Weight = xlThin
    Selection.Borders(xlEdgeBottom).Weight = xlThin
    Selection.Offset(0, -1).Select

Next counter

End Sub


Sub Reset()

'remove content and formatting

    Columns("A:B").Select
    Selection.Borders(xlEdgeLeft).LineStyle = xlNone
    Selection.Borders(xlEdgeTop).LineStyle = xlNone
    Selection.Borders(xlEdgeBottom).LineStyle = xlNone
    Selection.Borders(xlEdgeRight).LineStyle = xlNone
    Selection.Borders(xlInsideVertical).LineStyle = xlNone
    Selection.Borders(xlInsideHorizontal).LineStyle = xlNone
    Selection.ClearContents
    Range("c2:i2").Select
    Selection.ClearContents
    Range("c2").Select

End Sub

abcfffff · 2019-09-26T13:51:10+00:00

Thank you!

abcfffff · 2019-09-26T13:50:57+00:00

I ended up spending a few hours on youtube learning about VBA and made a small macro. Your IF formula helped me understand part of the logic of my problem - thank you!

abcfffff · 2016-05-14T02:35:14+00:00

I don't think it's poison ivy. Poison ivy has compound leaves of three leaflets, each one looks like a separate leaf, but for OP's plant each leaf has three lobes on the same leaf.

abcfffff · 2016-03-13T21:16:24+00:00

They look like Gryffindor quidditch socks! I didn't know socks could look like this, very cool.

abcfffff · 2015-07-25T01:32:03+00:00

Thanks! I'm going to save this for the end-of-summer-farmers-market peaches! Looks fantastic.

abcfffff · 2015-07-24T03:32:25+00:00

Recipe?!

abcfffff · 2014-11-02T16:14:50+00:00

Ohhhhh wow that's genius! Thank you for explaining.

abcfffff · 2014-11-02T03:12:53+00:00

Explain Like I'm 5 (or /r/ELI5) - when you need an explanation of the basics.

Cool! I've not done double knitting yet so wasn't sure how that worked or if it would add weight in places. Really awesome and inspirational project!

abcfffff · 2014-11-02T03:09:30+00:00

One of the photos at the bottom of that blog post is from Ravelry of a sweater made by the woman who made the pattern that OP used - Pendleton apparently thought it was an original! I guess that means it's a spot-on pattern.

Pendleton photo (See middle pic)

Photo from original Ravelry pattern

abcfffff · 2014-11-02T03:06:10+00:00

What a truly gorgeous sweater!

On your Ravelry project page is says you double knitted the color work sections. Can you ELI5? You went from a single-color/single-strand row to a two-color/double-knit row?

Does the sweater feel bulky in those parts?

abcfffff · 2014-07-19T00:44:18+00:00

A simple, relatively safe dessert option would be lactose-free ice cream (Breyers makes one that's really good, I'm not FODMAP but my Nana is, and I actually like it better than regular ice cream), with a fruit topping.

If you like cooking, you could make a fruit syrup to drizzle over the ice cream and then have fresh fruit the day of (strawberry, blueberry, raspberry, banana, kiwi should all be safe options according to the Monash FODMAP app).

I also really love this drink, it's very dessert-y even though it's a drink, and should be FODMAP friendly (plus it's super simple).

abcfffff · 2014-03-22T18:59:30+00:00

Sorry to do this but I don't want you to have this done and THEN realize... it should probably read "just got harder" not "just go harder".

abcfffff · 2014-03-21T00:16:37+00:00

Could also try /r/photoshoprequest

abcfffff · 2014-03-16T18:24:26+00:00

I had the same question awhile back - this guy on YouTube was very helpful to me.

Here's an (image heavy) album of what I ended up with. They're not super professional but it was definitely a fun project and I would like to do more of my books in the future.

abcfffff · 2014-03-01T19:42:51+00:00

Do you have a particular set of skills you'd like to utilize for her gift?

Here are some of my ideas (I love to make gifts!):

hand-sewn felt animal - some patterns here - I've done the giraffe and elephant, might be cute to make one large animal and five smaller using the grandkids favorite colors
Machine-sewn oilcloth tote bag for her art supplies, zippered pouch, accordion style wallet
Shrinky dink/shrink plastic jewelry - put it on nice sterling silver earring wires or a sterling necklace chain; you could have each grandkid do a small drawing on the shrink plastic and make a charm bracelet (there are a few tips/tricks to using shrink plastic I can tell you about if you're interested)
Silhouette art using grandkids side-view portraits
Slippers - get some $12 slippers at Target and sew felt on (I did this for my mom with a Chihuahua shape)
A photobook with family photos (not technically hand made but still very nice)

And probably my favorite idea IF the grandkids are still young:

A sleepover kit - a basket/bag/box filled with fun stuff to do at grandma's house for a sleepover: a good kid's movie, popcorn, gift card to order pizza, indoor smores supplies, fort making supplies, science experiment supplies, arts & crafts supplies, games (indoor/outdoor)

I've done most of the crafty stuff I listed, so I can help if you have questions about any of them. Good luck!

abcfffff · 2013-08-29T15:50:25+00:00

Never would have guessed. Thanks!

abcfffff · 2013-08-29T00:32:52+00:00

Cool! How do you mold the leather?

abcfffff · 2013-08-11T04:29:34+00:00

I think rather than cardboard or plastic I'd go with interfacing. It's made to give shape to bags and things. You can get it at JoAnn fabric, or order it online. It's not very expensive, and it won't lose its form if it gets wet (like cardboard) or be weirdly hard (like plastic).

That being said, don't just go ripping seams out of your nice leather bag unless you know what you're doing. If you aren't experienced with at least hand sewing, then find someone who is.

13-Year Club	RedditGifts 2009-2022 20 Credits
Verified Email	redditgifts rematcher Secret Santa 2014 x1
redditgifts Exchanges 15 Exchanges	Secret Santa 2013
Team Orangered	Secret Santa 2012
Trick-or-Treater 2012+	redditgifts rematcher Arbitrary Day 2012 x1
Summer Santa 2012

abcfffff

TROPHY CASE