Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. arvarr

    Excel Formula Help

    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
  2. arvarr

    Excel Formula Help

    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...
  3. arvarr

    Excel Formula Help

    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...
  4. arvarr

    Excel Formula Help

    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...
  5. arvarr

    Excel - getpivotdata function

    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
  6. arvarr

    Excel - getpivotdata function

    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...
  7. arvarr

    Excel Formula

    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
  8. arvarr

    Excel Formula

    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...
  9. arvarr

    Excel Formula

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

    Excel Formula

    Enjoy the game 😀.
  11. arvarr

    Excel Formula

    Awesome, Thanks heaps Skip.
  12. arvarr

    Excel Formula

    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
  13. arvarr

    Excel Formula

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

    Excel Formula

    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...
  15. arvarr

    Rename Connection Name (Data Connection)

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

    Rename Connection Name (Data Connection)

    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...
  17. arvarr

    Rename Connection Name (Data Connection)

    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...
  18. arvarr

    Pivot Table - Calculated Fields / Different From

    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
  19. arvarr

    Pivot Table - Calculated Fields / Different From

    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...
  20. arvarr

    Pivot Table - Calculated Fields / Different From

    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

Part and Inventory Search

Back
Top