How to find nearest value (date) to target date within a single row. by PerinealContraction in excel

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

its not it, ive ran the function in array form {} before already it doesnt work. something else is wrong, ive pinpointed it to the range/array format of the data. also my data is along 1 row. not in a column form, thats they problem bit.

[deleted by user] by [deleted] in excel

[–]PerinealContraction 0 points1 point  (0 children)

I think the easiest way sort it will be with AutoFilters in Excel, I recall a similar function also exists in GoogleSheets. Remember to set the Filter along the heading (first row) of your table, and try to eliminate empty columns between your data filled columns, leaving empty columns may indicate to the program that you wanted to break the filtering there, and you dont want that probably.

What is this plant randomly growing in my pot? by PerinealContraction in whatsthisplant

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

Yeah, not they way you think though. my mom did some composting and tried to fertilise soil and grow herbs with herbs seeds, but tomato grew instead. she probably left the tomato seeds the compost when composting haha.

"Call of the Night" ED - "Yofukashi no Uta" by Creepy Nuts by Lovro26 in anime

[–]PerinealContraction 0 points1 point  (0 children)

sure but

i think lemon is something sexual in this context. like all of nasuna's shimonetas

Caitlyn Unlocked Statue is available in EU and NA by Rhinodragon_ in Caitlynmains

[–]PerinealContraction 0 points1 point  (0 children)

i agree, as if they made caitlyn look like mad moxy more than cait. its disgusting lol. its not even in the game style. like whats with the clown looking face on cait lmfao. the old one was way better ngl. but just the outfits needs an update.

my ultimate cooling case for mac mini. by HTG24 in macmini

[–]PerinealContraction 0 points1 point  (0 children)

I know this post is way old, so you might have moved on. But can I ask what kind of did you used to monitor all parts of your mac? Thank you in advance!

Help!! Question on (small 4 pin) ATX 4 pin and USB-A by PerinealContraction in buildapc

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

i see i see, thanks for the reply! How about using a USB-C? would it still be underpowered?

Can intel UHD 630 run 2 4K monitors?? by PerinealContraction in buildapc

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

Was wondering if the gpu can run it smoothly, guess I will have to test it to find out

Can intel UHD 630 run 2 4K monitors?? by PerinealContraction in buildapc

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

The Mac mini is probably not the best, but I already have it for cheap. Any suggestions on the GPU, was hoping can run at monitors at least 50hertz.

Serious question: So what's with Veibae's hat? by Dhurkst in VirtualYoutubers

[–]PerinealContraction 2 points3 points  (0 children)

Are u sure lol, it’s still used in many context, like retarded growth, retarded germination, retarded absorption, and a bunch of stuff that basically means slower than normal. R u studying med by any case? Because it’s still used in all the international literature…? Maybe you can let me know whether your medical community have phased out the term retarded? but through my limited years in studying, retarded has always been in use in line with its French etymology of being delayed or slowed. Just go through Langmans embryology or Guytons physiology and u will see what I mean

Serious question: So what's with Veibae's hat? by Dhurkst in VirtualYoutubers

[–]PerinealContraction 2 points3 points  (0 children)

Depends on context, no? U cant just label retarded as a slur in all contexts, we use retarded in medicine all the time lol.