Reputation
281
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 5 26
Impact
~79k people reached

Oct
9
awarded  Famous Question
Sep
23
awarded  Popular Question
Aug
26
awarded  Popular Question
Aug
9
awarded  Popular Question
Jun
28
awarded  Popular Question
Jun
14
awarded  Popular Question
Feb
21
awarded  Nice Question
Oct
2
awarded  Notable Question
Sep
24
awarded  Autobiographer
Jul
23
awarded  Popular Question
Jul
3
comment Local DNS queries fail on server but work on clients
This doesn't work either. Same problem. The file gets overriden as soon as I save it.
Jul
3
asked Local DNS queries fail on server but work on clients
Jul
2
awarded  Curious
Jun
29
comment VirtualBox VMs in the same network, not in the same as host
Thanks for answering, but I found that there's a built in network type that does the same. Also, I couldn't get this working.
Jun
29
accepted VirtualBox VMs in the same network, not in the same as host
Jun
29
answered VirtualBox VMs in the same network, not in the same as host
Jun
22
asked VirtualBox VMs in the same network, not in the same as host
May
22
accepted Minimum and maximum speeds in Excel
May
21
comment Minimum and maximum speeds in Excel
After a little bit of research, I came up with this for the maximum speed: {=MAX(INDIRECT("B2:B" & COUNTA(B2:B1000) + 1) / (INDIRECT("C2:C" & COUNTA(C2:C1000) + 1) * 24))} Though there are still some hard coded values, but it's good for years. This seems to work for now, but do you see if there's anything that could cause problems?
May
21
comment Minimum and maximum speeds in Excel
Thanks! This works quite good, but when I add new values, it doesn't update automatically but instead a small green mark appears on the top left corner to ask if I want to update the formula to contain the added rows. How do I automate this? Also, I had to format the formula to this: {=MAX(B2:B19/((C2:C19)*24))} Thats because there's something strange going on with the fields formatted as time.