construct

https://1drv.ms/x/s!AvjBsEPEq12ngUHobzEXQ8yvas2e?e=Otrz6s I wish to unpivot the data but how would you convert the row of 2019.01, 2019.02 etc into dates? (Using Power Query)

hello, looking to construct a formula for a four argument statement: if A1 is > 10, then return .30 if a1 is >=8, but <=10, then return a value that takes 100 / b2, and lastly, if a1 is <= 8, then return .40 any thoughts please?

Hi, After years of coding in other languages I have been asked to "automate" some Excel workbook actions, so this is my one of my first attempts using VBA. One of them is copying the used cells in a couple of worksheets to a new workbook. This VBA code works fine if run by clicking a button...

Hi, I have a task to construct polygon boundaries for specific data.. Have a large number of such polygons to construct hence any help as a VBA or directly in excel is much appreciated. I was trying to construct a polygon using scatter plot but the lines are joining to points that will form a...

Construct all pairs with the difference of or distances = 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,21,22,23,24 , 25 From the beginning of 01 to 80 Example = distance of 4 04 08 08 12 12 16 (I.e. Up until 76-80 Another example distance of = 12 05 17 17 29 ...... Up to 78 to 80 Put on an...

Hello, I need some assistance with VBA to open a file where the year, month, and days change on a daily basis. The filepath will be as such: S:\NPH Accounting\NPH Accounting Department\Treasury\2016\5 NPH FundServ\01 Daily\DTCC Settlement Reports Daily\05 Current Day DTCC Settlement\05 NPH\12...