producing

Hi, I have done a lot of searching everywhere and came up with a few different ways of doing this, but the final formula that started working for me needs help. Here is what I need: I can only export the data i need from a price field ie: 0.00 due to the limitations of the program I use. A...

Why is this line... ActiveSheet.Range("B3").Resize(3, 1).Value = Array("Jan", "Feb", "Mar") producing in Range B3:B5 >>>>> Jan Jan Jan Does the Transpose statement need to be considered? Tks in Advance!!

Hello, I am trying to forecast into the future using excel's automatic forecast function. It's producing negative values, when the minimum possible is 0 (as it's number of items sold). Is there anyway to fix this, or another way to forecast that might be better? Please help!

Greetings all - I think I am close to having this right, but certainly am missing something. I am trying to calculate Max Drawdown of a portfolio, and have the following: CS2 =(running total equity curve) CT2 =max(CS2,CT1) CU2 =IFERROR(IF(CS2=CT2,0,MAX(CU1,CT2-CS2)),"") CV2...

Hi All I have spent fruitless hours on something that I am pretty sure should be straightforward, please help my sanity :confused::confused: <tbody> 1 AJ AK AN 2 Date expected Overdue? Submitted 3 05/05/2018 07/05/2018 4 16/07/2018 #/N/A 5 05/09/2017 #N/A </tbody> So, I want the...

Hi, does anyone know how I can concatenate to ignore blanks? My formula is this: =IF(AW6="",E6,CONCATENATE(E6," This funding has contributed towards a ",AW6," - ",AX6)) However, AW6 is blank and it is producing a result of the contents (a sentence) of cell E5 plus "(blank) - (blank)" at the...