Forum

So there is no way to structure the data in a way to trick Excel column chart similar way to the line chart? That's disappointing, I was really hoping...

Thank you so much, Mynda! Blanka

Sunny, Velouria, thank you both for your help. Very kind of you to provide the explanations. You've been very helpful. By the way, the files are...

Hi Sunny, Here is the file. I replaced only the actual data with fake values. The rest is untouched. When I first run it with c.Value = vbNullSt...

Velouria, I used the following: Sub ClearEmptyCells1() Dim TextCells As Range Dim c As Range Dim iCnt As Long Dim sTemp As ...

Thank you Sunny so much. This works perfectly. Velouria - thank you for your answer also. I wonder what the difference is between the two solutions...

Hi Phil, This is great. Thank you so much! Blanka

David, The Power Query output is in columns K through O. I did not touch the formulas in your original file. All the cells had the #Value! err...

Dave, If you want to go the Power Query route as Anders suggested - see the attached workbook. I built the query pointing to a folder on my...

Hi Catalin, Thank you so much! The calculations you created are way above my head. This looks like advanced PQ so now I feel better, becaus...

Hi Mynda, We recently started installment payments and it's throwing me for a loop. We load entire premium into the system at one time, but beca...