0.0%

Hello I think I have over analysed this and I think it's probably simple but any help would be appreciated. Basically I need my data table to pull a figure into column AJ "% increase" based on the % in column AQ "PIR" and the PR number in column AH. An example: - AQ2=99.43% AH2=2 It should...

<tbody> A B C D E F G H I J K L M N 1 Price 2017 Price 2018 Price 2019/01 Price change Price 2019/02 Price change Price 2019/03 Price change Price 2019/04 Price change Price 2019/05 Price change Price 2019/06 Price change 2 20 22 23 4.5% 25 8.7% 25...

How do I calculate row percentage by subgroup within a pivot table? <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="58"><col width="152"><col width="112"><col...

Hi, can anyone suggest what is the best approach to tackle what I'm trying to accomplish? I have 8 columns of header and 132 rows of data per month starting January. I want to create on a separate sheet a dashboard so that the user can use a dropdown list to select 'Month' and another dropdown...

Why is XIRR 0% for years 2022-2025,but in 2026 its negative? Using a guess does not change the answer. <colgroup><col width="64" style="width: 48pt;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="3"> <col width="69" style="width: 52pt...

Hello, we use quickbooks for our accounting needs. The problem is that quickbooks (qbs) wont allow certain information to be displayed on some reports. We can pull a YTD sales report that shows a comparison from last year, but it will not display who the sales rep is for that company. Is...

Hello anybody can help me solve a formula to check if the inv date fall between a promo allowance and if so get that promo allowance % and multiply by case, below is the data incentive table that im referring, I will like to bring the percentage...

I am using a Large function to return the top 10 values in an array, once that is returned I am attempting to return a value in another column on the same row, everything works fine unless the value returned in the Large function is the same as another value, then the index match returns the...

See below pivot table format (the 4th column is what I am trying to accomplish). I want to calculate year over year change on percents. I do not want a YOY percentage change I want to know the percentage points YOY difference. I also want this to be a part of the pivot (ie a calculated field...

HI guys I am no expert on VBA and could really do with some help. I have data in a table on one worksheet and want to click on the result in a cell that is the performance of the bucket in the worksheet Overview and then for it to take me to the second worksheet, action tracker and...

Good morning trying to format multiple ranges. 1st range D6:G. the data will change (increase or decrease). the code I am using. Thanks Dim finalrow As Long Dim i As Long finalrow = Cells(Rows.Count, 1).End(xlUp).Row For i = 6 To finalrow With...

I am looking to create a formula to identify values (counts and sums), using a Greater than, Less than scenario. Example: =SUMIF(COMPANY!Z:Z,">0.0%","<50.0%",COMPANY!M:M) is what I am trying to accomplish, but I know that formula is wrong. How can I make this work properly?

I have 2 arrays that are 6 x 6. I would like to conditional format the cells in the first array based on whether the corresponding values in the second array are less than 15% (in green) or greater than or equal to 15% (in red). Below is an example of the 2 arrays. The first row is column...

Can someone please help me make the X-axis on a graph display months? I've tried every formatting option imaginable and it won't work. I don't see an option to upload my Excel sheet so I've copied my data below <colgroup><col><col span="8"></colgroup><tbody> Feb Mar Apr May Jun Jul Aug Sep...