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