Excel Video 357 LEN in an Array from excel counting rows Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Description: As promised, there’s an easier array example in Excel Video 357 today.In today’s example we’ll assume that someone’s been counting something such as no shows, patients who arrived more than 15 minutes late for their appointment, or patients needing an xray.To count, they’ve been using some kind of tally mark, like the X’s in the video.The LEN function will count the number of characters (including spaces) in a cell.Rather than create a LEN formula for each row and then a SUM
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)