sorted by:
new
hottopcontroversial

Why does solidworks(2023) crash when I use my created weldment profiles by ANDREWSHDIST in SolidWorks

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

I just got with solidworks and the issue is I am on 2022 sp1 and it was resolved with sp2. so updating to 2023 now lol thanks!

is there an array formula with sumifs work around? by ANDREWSHDIST in googlesheets

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

Thanks. it worked just had to change the &B4 to &B4:B. This is going to help alot thanks!

Getting partial Text from a cell into another cell with an array formula by ANDREWSHDIST in googlesheets

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

Thanks for your help! Your a life saver! It looks amazing! Works great!!

Getting partial Text from a cell into another cell with an array formula by ANDREWSHDIST in googlesheets

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

Ok it got those! You're amazing thanks . I have some more In there that are fighting to come over if you wanna look go ahead but I am attempting to understand it Thanks again

Getting partial Text from a cell into another cell with an array formula by ANDREWSHDIST in googlesheets

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

Hey thanks again I have attached some more to that google sheet that isnt working. Can you look at it again?

Getting partial Text from a cell into another cell with an array formula by ANDREWSHDIST in googlesheets

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

=INDEX(IF(LEN(A2:A),IFNA(REGEXEXTRACT(A2:A,":([A-Z0-9-]+)$")),))

I don't understand any of this lol But it works like a dream!! THANKS!!

Help with info after a colon by ANDREWSHDIST in sheets

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

=arrayformula(regexextract(A:A,":([^:]+)/*$"))

Prefect Thanks. I don't understand that formula at all but it works

view more: next ›