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

    Combining 2 'Live' spreadsheets one below the other.

    Hello Experts, I am looking for a solution to combine 2 'live' trackers that get updated by 2 separate teams. I have a "Team-A.xlsx" report which gets updated by 5 team members, hosted on a SharePoint. In this spreadsheet, I 'mirror' few Columns (A,B,C,E,F & I) from 'BaseData-A' to 'Combined-AB'...
  2. S

    Extract last n lines from a cell

    Sorry, I could not thank you earlier. Thank you bosco_yip & Peter Bartholomew. Appreciate your help.
  3. S

    Extract last n lines from a cell

    Awesome Luke... Can I ask for more :):) Thanks a ton. Sekhar
  4. S

    Extract last n lines from a cell

    Hello Experts, I have a project tracker in which each row is represents an on-going project. There is one Col-'Status Update', in which team adds a note, starting with a date and in a single line, what happened on that day. I am looking for a formula to extract the last 3 lines in a cell from...
  5. S

    Look for a unique text sub-string & always return the last Col value in table.

    Apologies for delay in responding to you both. Thank you Grah-Guido & bocso_yip. Appreciate your help :)
  6. S

    Look for a unique text sub-string & always return the last Col value in table.

    Hello Experts, I have a Pivot table created from a realtime data source in "Pviot_Data" tab. Each row in the Pivot will have be in this format: Text1-Num1-Text2-Text3 I am trying to extract: 1. Text1 & Text3 in 'Pivot_Data' tab into separate Columns in 'Extracted_Data' tab. (Done) 2. Need to...
  7. S

    SLA metrics report based on multiple conditions

    Hello Experts, First of all, I don't know if this is the right approach to ask for such a big help, where you folks do it for free. (as I understood). I'd be happy to donate my bit, for all the amazing help you render here... Anyway, below is the reason I am here: Context: Sales team reaches...
  8. S

    Sumif with 2 conditions, one being 'fetch data from last Col' from a Dynamic Pivot table

    Thank you Khalid NGO, Marc L & Chihiro. Grah - Guido, rightly said, priceless advice. Will start my baby steps sooner than later :)
  9. S

    Sumif with 2 conditions, one being 'fetch data from last Col' from a Dynamic Pivot table

    Thanks to you all Experts: Chihiro, John Jairo V & bocco_yip. Really appreciate your quick responses & help.:) Also, if you can suggest: What's the best way to learn to construct such formulas & also step into VBA & Macros? Thanks in advance Sekhar
  10. S

    Sumif with 2 conditions, one being 'fetch data from last Col' from a Dynamic Pivot table

    Hi Experts, I am trying to do a Dashboard, where the source data is realtime from server, configurable as a pivot table in 'Data' tab. I configured a pivot table, which looks like the one in 'Data' tab. FYI - in attached, I just copy pasted values there, to re-create the data/format. What I...
  11. S

    Help! Extracting Unique Records & creating a dynamic table

    Thanks bosco_yip. This works well. The only edit I need is the formula in Col M-thru-S NOT considering zero(0) while calculating Averages. Can you help?
  12. S

    Help! Extracting Unique Records & creating a dynamic table

    Hello p45cal & Nightlytic. Thanks a ton!!! for quick help. Both are really helpful, but Nightlytic's formula based solution will be more appropriate to my need. p45cal - As you pointed out, the count in Nyghtlytic's sheet doesn't include zeros, but the average takes them into account. This...
  13. S

    Help! Extracting Unique Records & creating a dynamic table

    Hello Chandoo Community, I am new to the forums & looking for help. Background: I have a spreadsheet attached in which 1. We are trying to identify 'Implementation Channel' for all our Customer & non-customer project effort. This is a manual work in progress, some may never be identified...
Back
Top