Search results

Hi Gurus, I need some quick help with a formula. I am trying to compare Product prices between few months, where I need to highlight if the price changed from previous month(s). I pasted few scenarios below: Current month is 202308 Product A - It is exactly the same for both months - so no...

Hi Gurus, I need a clever formula to concatenate few rows. Example below. Depending on the active sections the output in the highlighted cell changes. In the following example it is expected to be Sections 1, 2 and 4. However if 2 3 and 4 are active, the output will be Sections 2, 3 and 4. Also...

Hi Excel Gurus, Need help to create a macro to do the following transformation. I though using a Dictionary will help to do the job. But I am at loss on how to do it. Any help is appreciated. I have a larger worksheet over 15K rows to be transformed. Regards, Ravi.

Hi Excel gurus, I need some help with a specific requirement to merge 3 tables into 1 summary table. Unfortunately, I cannot install or use PowerPivot for this purpose. I attached sample data file and also added screenshot of tables + expected output. Expected output: I am finding it...

Hi Gurus, I need some help with Find & replace functionality. Just to confirm, I tried many options without any luck. I am able to automate the whole process except for this functionality, forcing me to do the job manually. Requirement below: 1. Mapping worksheet contains a mapping table...

Hi Excel Gurus, I have a weird problem (I never faced it until recent) with one of my excel workbook. Actually occurred multiple times when I worked on copies from history. I am working on some updates to an Excel Workbook with lots of Worksheets, tables and VBA code. The changes involved are...

Hi gurus, I need a quick help. I am looking at comparing three lists (NamedRanges from different workbooks), which have few common values. I am trying to update all 3 NamedRanges by adding the distinct values from others. Typically all 3 lists look alike (without any duplicates) once updated...

Hi Gurus, I need to display a very small info in an descriptive viz for a powerpoint presentation. Data as follows: I need to display both the Company growth and Revenue growth at the same time. Please suggest me the best way to do this. (Sample file uploaded) Thank you, Cheers, Ravi.

Hi Gurus, I have this formula requirement, I am unable to solve. I have a table with raw data and another table (below) with possible combinations of criteria to sum the total. I need ONE formula to calculate the sum of "Amount" field for all these combination. I am aware that I can run a...

Hi All, I have a custom charting requirement. Glad if anyone of can assist me in this. Requirements below: I have yearly data pivoted into Quarterly calculations. Quarterly Forecast and Actual totals. I need to generate a chart which can compare re-forecasts between Forecast/Actual for all...

Hi Excel Gurus, This is an automation issue I am trying to solve and seek help from experts in various forums. I need my excel macro to do the following on Internet explorer (or chrome): 1. Open URL - Click This Link 2. Select Dropdown - "M-Option on UK Natural Gas NBP Future" 3. Click on...

Hi Excel Gurus, I have this weird problem that is bugging me since yesterday. I am trying to Automate a complex dashboard that queries data from various data input files (in CSV). I am using ADO connection to fetch the calculation queries such as below. The issue I have is when I run this...

Hi Gurus, I have a query to solve in Power Pivot. Seems like a small formula in Excel, I am unable to crack it on Power Pivot. I have 2 tables. Table1: Name, DateIn, DateOut, Product Table2: Name, DateAsOn There are multiple values for the User to use different Product, but falls in different...

Hi VBA Gurus, I need help with this code to fetch the Grade from the following Access Table. Low Score High Score Grade 39 Fail 40 59 Pass 60 74 1st Class 75...

Hi Excel Gurus, I need help with developing VBA code to get a CountIf summary statement from a table. Requirements: I have some data in a table with Name and Activities the person is involved. (there might be multiple activities for one person). There are two tags for each activity - Priority...

Hi Gurus, I have an problem with pivot. Ashamed of not to be able to get the thing working. But hopefully one you might enlighten me. Problem data: Month Sales Person Quantity Jan Smith 101 Jan Kiran 125 Jan Smith 111 Jan Smith 110 Jan John 149 Jan Laura 145 Feb Smith 102 Feb Laura 120 Feb...

Hi Gurus, I need help with a macro that copy-pastes an Excel Table (table name: PPTData) into a new Powerpoint slide. And adjust it to the slide size leaving some space on the top. I am quite new to PPT objects. I am able to achieve this for copy-pasting charts but not with tables. Please help...

Hi All, I have an issue developing a VBA program for a small logic. I tried posting it earlier here with no luck. Seems like I didn't communicate my requirement properly. So I am re-writing my requirements: I need help with a small VBA logic that can loop through a set of tasks and assign...

Hi Excel Ninjas, I need help with a small macro to automatically allocate tasks to users based on the % of allocation. Missing clarity? Let me put down the example: I have few tasks (with 2 levels of difficulty) that come up everyday (say 20 in this case) and I have 2 or more employees to be...

Hi Gurus, I have a curious request. I have been an aggressive VBA Developer for the past few years. I observed that the forms I design change for almost every project. I usually take two factors into considerations while designing - End User Age and Type of computer they use (mainly resolution...

Hi, I am trying to develop an excel application for an Event house. They have two houses and each will have business slots booked throughout the year. These slots will be in hours. They are open for 8 hours every day. Slots are booked in the following way. 5th April to 7th April for 20...

Dear Gurus, I have a very typical problem with Date Format. I run an online report every day, export it into excel and then run it through a tracker. Once I download the file, I need to make some changes. I am planning to automate those tasks and am running into problems tackling the date...

Dear Gurus, I have a complex issue to be solved (complex enough for me at this moment). Please help me achieve this VBA code. Please find the link to the sample file here: https://rapidshare.com/files/2211042122/Sample.xlsx I have a list of records with Date and Time, from this we need to...

Hi Excel Gurus, I need help with this small code. I know how to find a date from a range. I tried using the same code where the date is derived through a formula (I am adding up date by 1 day to each subsequent cells and use "FIND" in this range to get the column of the date). Surprisingly...

Hi, I have one issue bugging me. I am using Excel 2010. I need to add a Date Picker to the VBA Form. I will be using this on a regular basis and so I want it to be displayed in the "Toolbox", just like a regular ComboBox, ListBox etc., Please let me know how to achieve this. Thanks in...