Wow ETAF, that worked perfectly and such a simple logic. I hit myself hard for not thinking that. I just made a minor change to adjust the month automatically as a parameter.
=IF(AND(COUNTIFS($C:$C,C2,$D:$D,D2)<>COUNTIF($C:$C,C2), [@YearMonth]=202208),"Query","")
Can I bother you for another...
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...
Thanks Hui. I am able achieve this slightly differently.
My issue is when I try to do the following:
Concatenate "and" before the last section number . e.g. Sections 1, 2 and 3 or Sections 2, 4 and 3
Also add "commas" where relevant. e.g. Sections 1, 2, 3 and 4
Output of this formula feeds...
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 All,
Took longer. Been in struggle with IT get a power pivot to be installed on my machine. Didn't get the 2016 version yet.
Any chances this can be automated with VBA? As there are other tasks I need to execute once the data is transposed.
Thanks to all.
Thanks vletm and bluesky.
The pivot seems to do the job. I will try and apply it to the main data.
@bluesky63 - This seems to be a very good option especially for big data. I need to check if I can get power query working on my office machine.
I only looked at macro as there is more...
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 Marc,
Apologies for my delay. Been busy with a workshop and didn't get to post back. Yes the code did work for me except for a minor issue.
Not sure why, but when I adapted the code to work with my data the column that is synchronous to "Countries from" data is being duplicated. The final...
Thanks Marc. Yes I am comfortable with VBA, though I cannot say the same about Arrays. Unfortunately, it has never been my strong point. And your solution is very innovative. Once I got hang of it, I adjusted the code to work with my original table layout.
I am able to build the summary using...
Thanks Marc. This is Awesome.
I would love to understand what's happening internally. I am trying to adapt it to the original data, which has some intervening columns within the tables. Will get back.
Cheers,
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 Luke,
Thanks, I tried this option but this doesn't work for me. I was able to get the following VBA code to do the job as required (though with another issue).
Sub FindReplace()
'
'
Dim cel As Range, celQ As Range
Dim Find As String, Replace As String
Dim tblName As String
Dim lrow As...
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...