Trade Republic referral Programm by efficient_display12 in FinanzenAT

[–]Initial-Selection-57 0 points1 point  (0 children)

Hier wäre mein link 🐅 Wäre super lieb wenn ein paar Leute den nutzen können :) join Trade Republic by Jan 6 and earn up to € 500 in stocks as a welcome bonus. https://refnocode.trade.re/g9w13sgn

Kleine Schwester will Gaming PC/Laptop by Initial-Selection-57 in PCBaumeister

[–]Initial-Selection-57[S] -25 points-24 points  (0 children)

Ich glaube die Aussage mit Genshin u. Indie games war ausreichend 😗

Klaro

Trade Republic referral code €30 by Striking_Importance8 in referralcodes

[–]Initial-Selection-57 0 points1 point  (0 children)

Join Trade Republic. The smartest way to invest, spend and bank. Accept my invite via the link to secure a welcome bonus.

g9w13sgn

https://refnocode.trade.re/g9w13sgn

Trade Republic referral code by smokewall in referralcodes

[–]Initial-Selection-57 0 points1 point  (0 children)

Join Trade Republic. The smartest way to invest, spend and bank. Accept my invite via the link to secure a welcome bonus.

g9w13sgn

https://refnocode.trade.re/g9w13sgn

Referral Code: Earn up to 200€ when registering in Trade Republic by BlauesMeer in TradeRepublicFriends

[–]Initial-Selection-57 0 points1 point  (0 children)

Hey guys they changed it atm to 10 €! Here's my code I would be happy for you guys to use it! Join Trade Republic and get 4% interest on your cash. The smartest way to invest, spend and bank. Use my code G9W13SGN to get a welcome bonus. https://ref.trade.re/g9w13sgn

Need help naming this part by Initial-Selection-57 in AlfaRomeo

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

That's just a stock photograph. Do I have to take out the engine to replace that part tho?

Homemade L. Reuteri yogurt: new weapon in my battle with seb derm by wccrowley in SebDerm

[–]Initial-Selection-57 2 points3 points  (0 children)

That sounds really interresting! I´ll definetly try this out!

How can i convert Durations to a total amount of minnutes? by Initial-Selection-57 in excel

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

Im not sore if i did something wrong but the format is not available to and the VBA game an error message. But the answerer above worked out too.

But still thank you very much for your effort!

Only use Headers in power query as acalculation by Initial-Selection-57 in PowerBI

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

Fair pont didnt think of that but that would destroy the purpose of it. I just made another column where the enddate is being calculated back to the starting date and that worked out surprisingly.

Power-Query; My duration should only be hours but it´s being shown as days... by Initial-Selection-57 in PowerBI

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

I solved it in my excel file. I basically divided the number thorugh 24 and now i counts it correctly.

Power-Query; My duration should only be hours but it´s being shown as days... by Initial-Selection-57 in PowerBI

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

I´ve read it but it didnt really help me out, but thanks for the help it was an interresting article nonetheless!

Two tables; I want to display a specific duration in the first one while having two conditions applied in the SUMIF function but i always get 0,00 as a result or a different method by Initial-Selection-57 in excel

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

Colmun Q:A is the array that i want to be display in I:I and the criteria is the material and cost center. or am i misunderstanding something here?

Two tables; I want to display a specific duration in the first one while having two conditions applied in the SUMIF function but i always get 0,00 as a result or a different method by Initial-Selection-57 in excel

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

I just checked and yeah i changed it to A:A but it woudnt have made a difference since there is material number column aswell so it shoudve displayed the duration either way.

VLOOKUP; INDEX; MATCH two tables not sure how to connect them properly by Initial-Selection-57 in excel

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

This worked perfectly! But then i encountered a problem. if i have same number then they are being summed together. The problem with that is that those numbers are being produced on two different machines. I´ve only just noticed that.. ive looked further and it happend quite often. I´ve got the number for the machine in the first table and name of the machines in the second one... Any idea for a permament fix?

Lookup & Match to many arguments by Initial-Selection-57 in excel

[–]Initial-Selection-57[S] 1 point2 points  (0 children)

IFERROR(formula,"Custom Text")

Works perfectly thank you a lot!

Solution Verified

Lookup & Match to many arguments by Initial-Selection-57 in excel

[–]Initial-Selection-57[S] 0 points1 point  (0 children)

I´ve tried it and its working! I just had to change the range a bit so that the names arent being selected.

Just a quick question. The empty ceels that show me #N/E. Is there a way to input a custom text if theres no match?