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

    Count in number of changes in a row

    Hi, PFA File. Please Check.
  2. R

    Percentage increase table

    Hi @Lara_1234 , PFA File. Please check Regards, Rahul Shewale
  3. R

    Clever formula to concatenate

    Hi @ravikiran , PFA Solution Using office 365. Using helper Column
  4. R

    help creating a nested IF function in an HLOOKUP.

    Hi @valsrodriguez , Please upload sample file with desire output manually.
  5. R

    Look for unique data associated with other columns

    Welcome
  6. R

    Look for unique data associated with other columns

    Hi, PFA file. Array Formula With helper Columns.
  7. R

    Look for unique data associated with other columns

    Hi @Kenshin, or VBA Code
  8. R

    Look for unique data associated with other columns

    Hi@ kenshin, Microsoft Office 365 Version solution ( Dynamic Array ) =SORT(UNIQUE($A$3:$B$23),1,1)
  9. R

    Or function or what else?

    Hi @Ufoo, Please provide desire result manually.
  10. R

    Require MIN price for each SKU Group

    Hi @walker.cycling , See if is it ok ? Get Unique Sku Name : H3: Copy Down ( Array Formula : Press Ctrl + Shift + Enter ) Any Version {=INDEX($A$3:$A$50,MATCH(0,COUNTIF($H$2:H2,$A$3:$A$50),0))} if you have office 365. =UNIQUE(A3:A50)...
  11. R

    Use Changed Pivot Values in Calculated Fields

    Hi @Willstein818, See if is it ok ? Power Pivot Solution.
  12. R

    Max & Min For team Name by Sum Total Points

    hi @Hany ali , Please give detail from where value coming ( Points = 12, Team Name = Real betis, Sum MAX/ Min Points
  13. R

    Save invoice open new invoice

    hi @Norman_Atkinson , Test this but not sure NewFN = "C:\David\Inv" & Range("E5").Value & ".xlsx" Changed : NewFN = "C:\David\Inv" & Range("E5").Value ActiveWorkbook.SaveAs NewFN, FileFormat:"xlOpenXMLWorkbook Changed to : ActiveWorkbook.SaveAs NewFN, FileFormat:=xlOpenXMLWorkbook
  14. R

    Skip Blanks and lookup the values

    hi @fareedexcel, try this H5=MAXIFS($D$4:$D$9,$B$4:$B$9,F5)
  15. R

    Use Changed Pivot Values in Calculated Fields

    hi @Willstein818 , Please upload your file with desire output.
  16. R

    Put month end dates between two given dates

    hi @mahesh402 , See if is it ok ? Macro Solution .
  17. R

    Put month end dates between two given dates

    Hi @mahesh402 , See if is it ok ?
  18. R

    add ; between numbers

    hi @david gabra , Data Start from Row 1. C3=TEXTJOIN(",",TRUE,$A$2:A3)
  19. R

    Conditionally Format Groups of Rows

    Welcome
  20. R

    Conditionally Format Groups of Rows

    hi @DashboardNovice , Just Change CF Formula. =COUNTIFS($E$5:$E5,$E5)=1
  21. R

    Formula to add cells in a row until reaching a criteria and then assign a cell to that criteria,

    hi @alvaro2000 , Cell H11 Copy Across =IF(SUM($G11:G11)=$E$11,0,IF(SUM($H10:H10)=$E$10,$E$11,0))
  22. R

    Referring to column in a macro

    hi @ferocious12 , Please upload sample data
  23. R

    SUMIF(SUMPRODUCT(INDIRECT Formula Malfunction

    Hi @Leighbrek , Please upload sample data Regard Rahul Shewale
  24. R

    named ranges and data validation

    Welcome
  25. R

    named ranges and data validation

    Hi @jules meredith , try this ? =SUM(INDIRECT(A1))
Back
Top