MS Excel - auto-numbering in Dutch

-
Task
----------
get total number of cells from $B$2 to B4 if cell B4 is not empty
 
poss 1
----------
=ALS(NIET(B4="");AANTALARG($B$2:B4);"")
 
poss 2
----------
=ALS(B4<>"";AANTALARG($B$2:B4);"")
 
 
credit
----------

Comments

Post a Comment

I really appreciate you taking the time to comment, thank you!

Popular posts (all time)

Unsync and Remove iPhone Contacts From Facebook

-
This post explains how to: - See which of your iPhone contacts are already copied to Facebook - Stop synchronising your iPhone contacts to Facebook - Remove any contacts that have been copied from yor iPhone to Facebook (by the Facebook iPhone app). The simple instructions to Stop Synchronising and to Remove Contacts from Facebook are as follows: 1. Go to https://www.facebook.com/contact_importer/remove_uploads.php 2. Click the "Remove" button. 3. On the Facebook app on your iPhone, on the left-hand side scroll down to "Friends" and tap it. 4. On the Friends page press the arrow icon in the top right corner 5. Press " Sync Contacts" 6. Press the "Syncing" switch to turn synchronisation off. Please note. Any of your friends that are already on Facebook and have chosen to share their phone number with you will NOT be removed. If you just want to see which of your Contacts have been copied to your iPhone, follow this link: https://www...
Read more

WhatsApp from your Phone & Computer at the same time (PC/Mac)

-
Image
** UPDATE March 2015 ** WhatsApp now has a web interface, which you can use on all mobile devices except for iPhone. So if you have an Android device or Windows Phone, check out web.whatsapp.com  first as it may save you a lot of hassle! If you're on an iPhone however, please read on.. ** UPDATE March 2015 ** I implemented a nice way of using WhatsApp on my laptop and also staying in sync with WhatsApp on my iPhone. This will work with Android too (but you may prefer to use  web.whatsapp.com  instead). List of things you need: You must have a second SIM card (i.e. a second working mobile phone) that is not already being used for WhatsApp.  E.g. an old prepaid phone. As long as it has a working SIM card and you are able to receive an SMS message on it. A free program for your computer called BlueStacks, which you can get for PC or Mac at  http://www.bluestacks.com . ** UPDATE March 2015 ** Alternatives to BlueStacks are: AndY (free!) ; AMIDuOS ($10)...
Read more

How I Fixed Mac OSX Lion NTFS issue

-
After I upgraded my Macbook to OSX Lion, my NTFS-formatted USB drive would no longer mount... GREAT! %$#@ I use an free open source NTFS driver for Mac called NTFS-3G ( You can get it from SourceForge here - grab the dmg file). However NTFS-3G is built on top of a piece of software called MacFuse (part of the NTFS-3G installation)  and unfortunately MacFuse only provides a 32-bit interface, whereas OSX Lion has a 64-bit kernel. I found the explanation of the problem here . I was able to solve the problem when I came across a little gem on this site: http://www.fatframe.com/2011/07/25/macfuse-issues-mac-os-10-7-lion This guy has posted a custom compiled version of MacFuse, compiled for 64-bit. I downloaded this guy's custom compiled version (look for the link to the zip file half way down the page) and just installed it straight on top of my existing MacFuse version. Then rebooted. It solved my problem! I can now mount my NTFS USB drive and I have read/writ...
Read more

How to get an SSH server running on a Mac

-
To SSH into your Mac you just need to do the following. Go to System preferences >> Sharing Check the "Remote Login" box That's it! This will start sshd on your system and you can now be able to SSH your Mac with your usual Mac username and password. If this helped you out, hit the +1 button below. If not, feel free to leave a rude comment ;-)
Read more