• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    Can't find project or library Error !

    Thank you for the reply. However, could you please help how to stop. Can you please clarify, what does stopping all code means. Requesting your further help on this one. Thank You and Regards, Pavan.
  2. P

    Can't find project or library Error !

    Hello Team, Could you please help how to get rid of Can't find project or library Error which I am getting continuously. Whatever is the macro inside the file, the error is popping up. Below is the screenshot for your reference please. Kindly help how to resolve. Tried to research and it says...
  3. P

    Extract Asset Number from Description

    Need help please on this one
  4. P

    Extract Asset Number from Description

    Hello All, Attached is the excel which has Description of Expenses in sheet 1 named Expenses and Vehicle Nos. in sheet 2 named Vehicles. I need to extract vehicle nos. from the description whichever are matching with Vehicles list in 2nd sheet. In addition, need to identify expense type based...
  5. P

    Excel Slicer with animation effect in email body

    Hello, Can anyone help please regarding my query with reference to animated slicer as part of outlook email just like the slicer in this link https://chandoo.org/wp/introduction-to-slicers/ Thank you in advance, Regards, Pavan.
  6. P

    Shading between two lines in a scatter chart

    Hello, Please refer to https://peltiertech.com/fill-under-between-series-in-excel-chart/ which might help. Thanks, Pavan.
  7. P

    Excel Slicer with animation effect in email body

    Hello, Requesting your help in providing a solution to paste an animated image which has slicers as part of the body of the Outlook email. Kindly help. Thanks, Pavan.
  8. P

    Combine columns

    You are welcome. Please find the attached sample 2. You have to concatenate Material no. & Whose number to get a unique identifier with which you have to lookup for the value from the yellow table. Please refer to the attached excel. Thanks, Pavan.
  9. P

    Combine columns

    Dear Mikevr, Please use Power Query to transform the data. If I understand right, the columns from B to G have Warehouse numbers below which you have quantities. So, go to Data and click From Table/Range which will take you to Power Query window and from there in Transform menu, you can unpivot...
  10. P

    Extract specific data from text file

    Please post your query in Excel section. Currently it is under VBA Macros and also try to attach txt file which give more clarity please.
  11. P

    Excel Slicer with animation effect in email body

    Dear All, Could you please help in suggesting a way as how can I attach a summary from a Pivot Table with Slicer along with effects. For example: - If the Pivot table has sum of marks for 3 students A, B, C. There is a slicer for subjects: - Maths, Physics, Chemistry. The moment you click on...
  12. P

    Extract specific data from text file

    Dear Mahesh, Not sure if Flash Fill feature (Ctrl+E) helps your requirement. Please try. Thanks, Pavan.
  13. P

    Conditional Formatting Formula

    Thank You GraH. However, please note that if the value is below + or - 5 also, it should turn Green.
  14. P

    Conditional Formatting Formula

    Kindly note that if the value is in cell A2, and tried the below formula which is not working. =IF(OR(A2<5%,A2>-5%),"Green",IF(OR(A2<9%,A2>-9%),"Amber","Red")) Please correct and make it work. Thank You and Regards, Pavan.
  15. P

    Conditional Formatting Formula

    Dear All, Could you please guide me how to highlight Red, Amber, Green (RAG) using conditional formatting based on the cell value. The criteria is below: a) Plus or Minus 10% => Red b) Plus or Minus 5% => Green c) Plus or Minus 5 to 10% => Amber Thank You and Regards, Pavan.
  16. P

    Nested if function

    Dear Maniknandi, Attached is the file for your reference. Thank You and Regards, Pavan.
  17. P

    Need Dashboard creation help

    Dear DJ, Try to visualize the data using pivot tables only in one sheet and accordingly take those table headings to another sheet to write formulas like COUNTIFS, SUMIFS etc. to auto update the dashboard as and when the data gets updated. You can use data validation, drop-down to dynamically...
  18. P

    Chart creation with more attributes

    Thank you Hui. However, unsure of RAC measures. What does this mean? Could you please elaborate. Thank You and Regards, Pavan.
  19. P

    Chart creation with more attributes

    Dear All, Attached is the excel with 20 employees and parameters (A, B, C, D, E, F, G & H). Need to generate a single chart with all the employees and all parameters. Tried various options with radar, bar, column etc which are looking cluttered. Tried to create a chart with validation of all...
  20. P

    Lookup value based on Time value

    Could you please check the above and help Narayan. Thank You and Regards, Pavan.
  21. P

    Formula Help

    Hello, Check if this solves your requirement. This is not a formula though. Thank You and Regards, Pavan.
  22. P

    Formula Help

    Hello, Could you please specify whether you need all the possible time frames for a particular state based on shipping co. The formula you have is giving you the result correctly, but only one at a time. Thank You and Regards, Pavan.
  23. P

    Lookup value based on Time value

    Thank you Narayan. However, attaching herewith the file which is giving value error after I have increased the number of rows in 2nd sheet. Also, could you please help me in explaining the formula which would be a great help !!!
  24. P

    Lookup value based on Time value

    Dear All, Attached is the excel in which has master data with details like Date, Vehicle no., Name of the Driver, Shift Timings (Time In & Time Out) of each vehicle. There is 1st sheet in which the details like Date, Vehicle No., Time of Fine, Fine Reason are present. The Time Out and Time In...
  25. P

    Time Range Lookup

    Thank You Alan. However, please note that the Index and Match combination of the formula you have suggested is working only in parts and it is retrieving #N/A error whenever the time slot is present in column E instead of column D which is specified in the formula. Regards, Pavan.
Back
Top