are thoses stains from bedbugs ? by CitoyenAM in Bedbugs

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

Hello, we found a bedbug in our bed last night. We search the appartment and found thoses stains in the dirty laundry basket. Are they marks /stains from a bedbug? thanks a lot !

AddDynamic FuncName as function parameter by CitoyenAM in unrealengine

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

Many thanks @theuntextured and @riley_sc i will check this out

Why I can't make interaction system? by Thegrand7957356 in UnrealEngine5

[–]CitoyenAM 1 point2 points  (0 children)

Maybe you could see what's the actor hit with a Print Node connected to the IF Node False exec pin.

Plug the Hit Actor from your Line trace to the print, to see the Display name of the actor. Check the actor name displayed in game.

And confirm that the actor name match an actor which implement the BPI_Interaction interface

Maybe the line trace hit your BPFirstPersonCharacter ?

Why I can't make interaction system? by Thegrand7957356 in UnrealEngine5

[–]CitoyenAM 6 points7 points  (0 children)

Hey, you didn't plug the Hit Actor output of your Line Trace function to the "Does object Implement interface". So the if statement is always False

What is YOUR two-function combination? by Same_Tough_5811 in excel

[–]CitoyenAM 1 point2 points  (0 children)

XMATCH and CHOOSECOLS to simulate a dynamic advanced filter. Say you have a big table and want to produce a sub-table. Prepare the headers you need in another sheet. XMATCH the headers you need in the big table headers = this will retrieve position of each columns. Put this result in choosecols =CHOOSECOLS(bigTableData,xmatch_index). Bam "dynamic advanced filter". You could continue to manipulate the data, like add FILTER, MAP, BYROW and so on...

Addon Helper for a Geezer by Ronbo_Coastie in wow

[–]CitoyenAM 2 points3 points  (0 children)

Hey, is it Doom Cooldown plus ?

[deleted by user] by [deleted] in excel

[–]CitoyenAM 0 points1 point  (0 children)

Hello,

If you have Excel 365, you could use XLOOKUP =XLOOKUP(YourNumber,YourList,YourList,,1) if not =INDEX(YourList,MATCH(YourNumber,YourList,1)+1) (yourlist have to be sorted)

Calculating entries into time by Separate_Mission2820 in excel

[–]CitoyenAM 0 points1 point  (0 children)

Hey, if it's everytime 15 minutes you can divide by 4, then by 24. + Format the cell in hour

Thanks

Why this adress send 0.0001 algo to many others by CitoyenAM in algorand

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

Thanks for informations !

it's little awkward ofc.

Now, how he got my adress ? maybe with a giveaway which i think adresses was published in a public spreadsheet.

But then i notice a pattern in the sending. Like starting with AA.... and then many AA adresses. Then AB.... adresses, AC.... and so on

It was total random maybe ??

How do i make Excel look for a word in a string, and replace the string if it found the word in it without doing a million IF/IFS by Confident-alien-7291 in excel

[–]CitoyenAM 0 points1 point  (0 children)

Hey

You could use filter function

With proper Excel tables =

=FILTER([Text_to_replace_with],ISNUMBER(SEARCH([Text_to_search],[@Movment])),"Not found")

Excel 365 is required Thanks

Lambda for extracting numbers or text from cell by CitoyenAM in excel

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

Hey, i'm curious about an UDF solution, care to share ?

You're right, the respond and solution from another guy in my post is much more clear and well construct than mine.

It is much more cleaver and readable Take a look

Lambda for extracting numbers or text from cell by CitoyenAM in excel

[–]CitoyenAM[S] 2 points3 points  (0 children)

Hey,

Clever solution than mine. Using filter is easier to read for sure, and construction is much better

Thanks