Search results for query: *

Hi Skip Thanks again for the prompt response. Correct, it's not as effective as your set hence attempting to see if there's any solution around it. Thanks, arv

Hi Skip Thanks for the info above. In my real data, there is no company A, just 123 and 456. I have added company A as grouping for this purpose. The formula should really be driven by the code 123 and 456... Sheet1 - Remove data in E2:E4 Instead of looking up the company, Let the formula...

Hi Skip Correct. Results equates to the source data for the amount. Table contains the percentage split. Sheet1 = Company A comprise of code 123 and 456 In my real data, there is no company A, just 123 and 456. I have added company A as grouping for this purpose. The formula should really be...

Hi I need some help with an Excel formula. I have used the sumproduct formula to add up the respective company code amount. Each company code has a percentage split and I'm not sure if the sumproduct formula can accomodate it. Test File uploaded with expected results. Thanks...

Hi Skip I inherited the file and believe last user turned off the "Getpivotdata function was turned off when cells were refenced to the pivot tables" from options. Hi combo I thought that might be the case with having to edit cell by cell... Thanks, arv

Hi I have multiple worksheets whereby cells are referencing to pivot tables. Getpivotdata function was turned off when cells were refenced to the pivot tables. Hence, cell formula is showing cell reference instead of getpivotdata function. Is there anyway to bulk change / update from cell...

Thanks heaps. I had one closing bracket in the sum section and 2 closing brackets after. I shall leave you to enjoy the game. Much appreciated 👍👍👍. Regards arv

Accommodated negative amounts. If negative amount. It only shows in one column. =IF(OR($A3>E$1,$A3<MIN($1:$1),$A3>MAX($1:$1)),0,IF($A3=E$1,$B3,IF(ABS(SUM($D3:D3))<$B3*$C3),$B3,0))) I tried adding Abs below but it extends more than # Of times...

Yikes, the only issue is when its a negative amount, it extends more than the # of times.

Enjoy the game 😀.

Awesome, Thanks heaps Skip.

Hi Skip I think I can add another column to overcome this problem. I just realized I will have negative numbers in column B and the formula needs to be adjusted. Thanks, arv

Thanks Skip. Awesome. What if I have date 31-January-2021 in cell A15? The expected outcome is 0. Thanks, arv

Hi I'm trying to populate from column D to S with value from column B. Criteria: 1. If Period (column A3:A14) = Period (column D1:S1), then insert value (number of times as per column C across columns) Attached is the raw data with results i am trying to achieve. Thanks...

Thanks strongm. Issue resolved. Many Thanks to both Combo and strongm!

Hi combo Thanks for the code. It changes one of the connection name then came up with an error. Run time error 5. Invalid procedure call or argument. It appears that it is trying to rename the same connection when it loops. It does not seem to have a sequence from top to bottom or bottom to...

Hi I have a workbook with 10+ connections. Some connections are not being used. These connections are used to produced an OLAP-type PVT. Each connection having their own connection name. Naming convention can be random. I'm looking for a vba code to loop through all connections in the workbook...

Hi Combo The pivot table lists all the fruits that is listed in 2022. However, if there is a mismatch whereby a type of fruit that is in 2021 but not in 2022, the pivot table will not list the item. Thanks, arv

Hi Combo Re Point 1, i'll need some help again. Added another row and call it Jackfruit/Class A with period Jan-22. I intentionally omitted Jackfruit / Class A from period Jan-21. With the merge, it will not be able to match the record (Jackfruit/Class A). What's the best way to overcome...

HI Combo Thanks for the update. Noted re point 2. I will give it a ahot. Not 100% sure if i understand point 1 but I'll try. Thanks, arv