Skip to main content

Posts

Showing posts from July, 2020

New Article

How to SUM by matching partial text in Excel

2D Column Chart with Background Image in Excel 2016

3D Cylinder Progress Column Chart in Excel 2016

Combo Chart with 2D Stacked Column and Scatter Chart in Excel 2016

Please SUBSCRIBE our YouTube Channel for more videos.

3D Infographic Full Cone Chart in Excel 2016

Please SUBSCRIBE my YouTube channel for more videos.

3D Info-graphic Mirror Glass Chart in Excel 2016

Please SUBSCRIBE My YouTube Channel for more videos.

3D Info-graphic Bar Chart in Excel 2016

Please SUBSCRIBE our YouTube channel for more videos.

3D Infographic Cylinder Chart in Excel 2016

Please SUBSCRIBE our YouTube channel for more videos

Daily Sales Area Chart in Excel 2016

Find the first no sales date with sale value as blank in excel 2016

Just now I've found an interesting formula to find the first no sales date by lookup with First Blank Cell. I was trying to create a Daily Sales Tracking Chart with a combination of Line Chart and Area Chart in Excel 2016. For that, I have designed my data table as below: Image 1: Sample data table to find the first no sale date Now, In F2 cell, I was trying to find the first no sales date by matching Sales is blank. I have used below Array Formula to get my result in F2 cell: =INDEX(B3:B32,MATCH(1,ISBLANK(C3:C32)+0,0)) And surprised to get the result. This tutorial is described in another way like "How to match blank cell in Index-Match formula". I know that you can easily find the 9-Jun-20 with below LOOKUP formula, like this: =LOOKUP(2,1/(C3:C32<>""),(B3:B32))+1 or Array Formula: =INDEX(B3:B32,MIN(IF(C3:C32="",ROW(C3:C32)))-2) Hope this tutorial will help you sometime in your excel world. Thanks.