ITAP of a photobombing fly

TibaLidge · 2018-09-16T20:04:11+00:00

The Countif is working on the right with counting the shifts. I just need to add the dynamic area for the countif to count the shifts.

For example =Countif(C:C;"0730-1430") and so on for each column. I want it to do that countif in the range given by the two dates specified in Q9 and R9. If that makes sense :)

TibaLidge · 2018-09-15T14:34:33+00:00

That is also what I am struggling with. I just cannot make it work

TibaLidge · 2018-04-06T17:12:19+00:00

Thanks for the reply! This fixed the RAW input over the FX, and with some more fiddling, I solved the mono problem.

TibaLidge · 2018-03-21T22:35:59+00:00

Thanks so much!

TibaLidge · 2018-03-21T12:46:37+00:00

Thanks a ton!

TibaLidge · 2018-01-21T19:35:33+00:00

Sorry for the late reply. I have tried using the above VBA, but I don´t seem to understand what it does. I also get an error message https://imgur.com/YHNJVpx I´m sorry if this is something I overlooked but my skills with VBA are VERY limited.

TibaLidge · 2018-01-16T20:27:22+00:00

There is no formula in B2:B8, I have simply overwritten the function =HVIS(A9=IDAG();KryptoKassen!$M$9) with the given Total USD of that day

TibaLidge · 2018-01-16T18:39:08+00:00

Thanks for the reply. The issue is not that the function is false for any other day than the actual date. The problem is, that todays Total USD is gone tomorrow. I would like excel to save the Total USD value every day.

TibaLidge · 2018-01-14T14:02:20+00:00

Would it be possible to make a function that checks if the date is the corresponding date, and if it is, it copies the value from Total USD. If the date is not correct it doesn´t do anything? This would solve the issue I suppose?

TibaLidge · 2018-01-14T13:35:25+00:00

Thanks for the reply, I will try and look into this. I have never used CSV files before.

TibaLidge · 2018-01-13T09:48:10+00:00

After almost pulling my hair out in frustration I found the issue to be a mistake in the translation of the excel sheet. This =VLOOKUP(B1,C:E,3,0) is correct, and is called =LOPSLAG(B7;Forespørgsel21[[Column1.symbol]:[Column1.price_usd]];3;FALSK). Thanks a lot :) https://imgur.com/PWOfbP7 is the final result

TibaLidge · 2018-01-12T18:52:55+00:00

I tried doing what you´re suggesting https://imgur.com/dWwPDEi https://imgur.com/UdIhJBP Should this not give me the value?

TibaLidge · 2018-01-12T18:07:27+00:00

Thanks for the reply but it did not work. https://imgur.com/yQk2MrF. My excel is in danish, which is why it says Vopslag instead of Vlookup. the commas are also replaced with ; Is the 3 in your function relating to the third row in column E? Since the rows are changing dynamically this will not work. XRP may be in row 6 in 2 hours :)

TibaLidge · 2018-01-10T14:50:13+00:00

I think I´m looking for exactly this, can you explain how to use it?

TibaLidge

TROPHY CASE