• 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. J

    Identify two different items based on condition

    Hi guys, In my master file I have invoices. Some invoices will have multiple products or services. If any particular brand has a warranty included in the same invoice, then I need to get the total qty. of warranty sold for that brand. sample data attached. Request your thoughts and insights...
  2. J

    Need to fetch data based on multiple conditions

    Hi, I need to calculate incentive based on conditions from 2 tables. Sample file attached. Incentive need to come on Sales data sheet. There are two slabs for achievement - For 100% and more and for less than 100%. Achievement - Will tell group wise achievement. Example; Group APL...
  3. J

    Extract unique values in Excel 2019

    Thanks alot John. That worked like a charm.....
  4. J

    Extract unique values in Excel 2019

    Hi, expecting your expert opinion.
  5. J

    Extract unique values in Excel 2019

    Hi John, Thanks alot for the solution. As you rightly said I converted my data to table. And this formula is working for majority of the groups but not working for one group. I have added one more condition though. I am unable to understand where I went wrong. Attaching file for your reference.
  6. J

    Extract unique values in Excel 2019

    Hi, I need to extract unique values based on two conditions. Tried below formula but no luck. ={IFERROR(INDEX('Raw Data'!$R:$R,MATCH(0,COUNTIF(Y10:$Y$10,'Raw Data'!$R:$R)+IF('Raw Data'!$N:$N<>$B$2,1,0)+IF('Raw Data'!$AD:$AD<>$D$2,1,0),0)),"")} where condition 1 is in $B$2, Condition 2 is in...
  7. J

    Split cell values based on a delimiter

    Thanks alot for the simple solution Marc.
  8. J

    Split cell values based on a delimiter

    That never came to my mind. Thanks alot
  9. J

    Split cell values based on a delimiter

    Thanks alot I tried text to columns. But I would love to use such VBA codes.
  10. J

    Split cell values based on a delimiter

    Hi, below is a sample of my cell value; 248527/248528/248529/248690/248691/248692/248693/248694/248695 I want to separate each 6 digit numbers in different cells. So the result will looks like below; 248527 248697 248529 248690 248691 248692 248693 248694 248695 The "/" delimiter will not...
  11. J

    Copy Table Data in Web and Paste to Excel As Rows & Columns

    Hi, While copy pasting a table from web to excel, the data is not getting pasted as rows and columns. It is getting pasted like below; And the actual table in web looks like below; I tried below methods; 1. All paste special options in Excel - All of them gave same results. 2. First...
  12. J

    Join Worksheet function & VBA function

    Thanks alot Chihiro :-)
  13. J

    Join Worksheet function & VBA function

    Hi, I use below code to get Sheet Name; Range("K1").Value = Split(ActiveSheet.Name, "_")(0) Example Result - APS And below code to in cell A1; WorksheetName = "=CONCATENATE(""GC - "",Text(Today(),""MMMM DD""),"" - "",K1)" Example Result - GC-July 07 - APS...
  14. J

    Get Part of Work Sheet Name

    Thanks vcoolio....
  15. J

    Get Part of Work Sheet Name

    Thanks alot shrivallabha...
  16. J

    Get Part of Work Sheet Name

    Hi, I am trying to get part of active worksheet name by avoiding date part after underscore. I used below code; Given Sheet Name is Computers_July 15 Range("K2").Value = Left(ActiveSheet.Name, Len(ActiveSheet.Name) - InStr(ActiveSheet.Name, "_") ) And it returned below result - Compute Where...
  17. J

    Use If Then based on cell value

    Hi, That really worked. Thanks alot. Regards Junarkar
  18. J

    Use If Then based on cell value

    Hi Below is my code which will create a fill effect to a wordart; >>> use code - tags <<< If wsDFD.Range("F34").Value <> olval Then With Shapes("Rectangle 58").TextFrame2.TextRange.Font.Fill .TwoColorGradient msoGradientHorizontal, 1 .GradientAngle = 270...
  19. J

    Calculate based on condition

    Thank you for your time and solution. I totally agree with you that the task is complicated and apologize that I find it difficult to explain in a easy manner. I will go through my problem again and try to give a clear version. Regards Junarkar
  20. J

    Calculate based on condition

    Hi, Am I posting in a wrong Forum. Because I am not sure if it is doable with formula or VBA. Please extend help.
  21. J

    Calculate based on condition

    Hi, My requirement is little complex than the heading. Below is my Data; Billing Date Sales Person ID Invoice No Category Desc. Classification Article No Sales Qty. Net Sales 01-03-2020 14456 464193454 Power Accessory 102572 1.00 1.00 01-03-2020 14456 464193454 TV Main Product 109567...
  22. J

    Get Dates if the month of which is equal to current month

    Hey Piviot can also do the work but like you said I was curious to learn how it can be done with formula. Thanks
  23. J

    Get Dates if the month of which is equal to current month

    Hi The second formula done the work :) . Thanks alot for the solution. Regards Junarkar
  24. J

    Get Dates if the month of which is equal to current month

    Hi Khalid, I tried it but it returns error. I couldn't figure out the reason for error. Below is my formula and I tried it without CSE; =IFERROR(INDEX(Emp_Name,AGGREGATE(15,6,1/((MONTH(CSS!$G$3:$G$22)=MONTH(TODAY()))/ROW(CSS!$G$3:$G$22)-2),ROW($1:1)),),"") When checked...
  25. J

    Get Dates if the month of which is equal to current month

    Thanks for sharing the link. But I stuck at a point because how can I compare the month of dates in a range with month of current month? I can't use filter because I want this data in a dashboard. My formula looks like this...
Back
Top