User Profile
Riny_van_Eekelen
Platinum Contributor
Joined Sep 04, 2019
User Widgets
Recent Discussions
Re: STOCKHISTORY Function Not Working
bob3 Your question is 22 hours old, though it didn't show up in the Forum until now. Perhaps an issues that was reported all over the internet yesterday has now been resolved as your formula works perfectly for me. But please be aware that the 3rd-party Stock information provided in Excel is to be used "as is" and not for professional or trading purposes. I would like to add that you should not use it for anything crucial in your private or business life either. It's a nice feature if and when it works. And when it breaks every know and then just wait until it's fixed. Better to find and more reliable source for such information if it really matters.Re: How total up hours?
Provided that these are real time values, you can enter a formula =SUM(C2:C16) where you want the total to be. Then apply a custom format to that cell like [hh]:mm. That will tell Excel it's dealing with a duration, not a clock time. Leaving the cell in its default format will wrap after every 24 hours and display the remainder as clock time. Example attached.Re: 365 bestand downloaden naar desktop
Lijkt me sterk dat de desktop versie iets niet kan wat on-line wel werkt. Maar goed, druk op the drie puntjes achter de bestandsnaam (on-line) en kies dan "openen in de desktop" (weet niet hoe het precies in the NL versie heet :( ) (screenshot vanuit de engelse on-line versie) Werkt het dan ook niet? Hoe groot is dat bestand? Ander moet je het bestand gewoon kunnen openen in de desktop versie en dan naar je OneDrive locatie navigeren.Re: Sorting data on multiple sheets
Donsclan So may I assume that you are using a regular SUM function that points to cells for specific individuals in the weekly sheet? If so, look into using SUMIF or SUMIFS instead. These functions allow you to sum values in an entire range based on criteria in another range or other ranges. But perhaps better to get rid of the weekly sheets all together and create one table with whatever you are tracking, in a tabular lay-out. Much easier to analyse/summarise than data in separate sheets.Re: Excel Tables and Conditional Formatting
BaltaD Worked on something like this a long time ago and can't remember if I made this up myself or found it somewhere on-line. Anyway, I now found it in my saved example files and share it here. The CF formula I would use to color the rows based in the team number in column B is this: =MOD(SUM(IF(FREQUENCY($B$2:$B2,$B$2:$B2),1)),2) Can't upload the file. The system is a bit screwed lately. Therefore just a picture.
