column additions

Hi There, Im struggling to find any literture on how to execute the below: I have a large data set that has all the information I need. These include: - Sales person - Job Status - Sales Price - Purchase Price - Profit as a $ - Margin as a % In the past, i have only needed to report on the...

Hi! Im new to power query and would love your help! I have a date in YYYYMMDD format in cell B2, and would like to create a new column A to reflect this date in DD/MM/YYYY format. Is this possible? If so, how can I do this? Thanks heaps

I'm working on updating some overly complex and inefficient formulas in an Excel workbook. When doing so, I noticed one of the formulas that calculates a check figure wasn't working. After looking at the problem I noticed that the lookup range in the VLOOKUP columns was starting two columns to...

Hi there. I'm keeping a simple score for my game guild. I need to know the difference of =A1-B1, =A2-B2 =A3-B3 etc. When I add a new column it goes to =B1-C1, =B2-C2, etc. How do I keep the formula to stay on the new column A? I've attempted to use the $ symbol but it doesn't seem to work...

Hello Team, Hope anyone can help with below query.... I have input data however data columns may change everytime (Header name will not change) for example if I have Customer Name in A1-column next time Customer Name column may get in C1-column. I have one macro where will refer these data...

Hi All - Is it possible to enter a month and year on one sheet, say, April 2014, and then on another sheet, only 4 columns are populated (Jan, Feb, March, April) with a 5th column saying 2014? Basically, I don't want 8 blank columns before 2014 shows up, just the 4 months + 1 column for year...