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

    Get twitter @mentions data in excel

    Twitter has made marketers rethink the way they market. You can follow (twitter term) any company and get their tweets on your twitter profile. On Twitter, you can find more companies than users. All have their twitter accounts and send tweets to their followers and it is the new-age marketing.
  2. T

    How to upload and use excel file to a website

    Some of the other answers to this appear to be making a pitch for your business, but they refer to Google sheets, not Excel. So, at the very least, you’d need to convert the Excel to Google, and then proceed accordingly. But the IDEAL solution would be simply to convert the Excel sheet to a web...
  3. T

    Pivot table with 2 sheets

    Hi, pivot tables do not support multiple tabs. You can use a QUERY formula instead though, and construct your dataset as a vertical array, for example =QUERY({StaffSheet1!A:Z;StaffSheet2!A:Z},"select Col1,Col2") You can add all 18 tabs between the { } and separate each range with ; If you need...
  4. T

    Extracting daily shift data

    How do i autonumber based on a value but in my case there is no "TOTAL". This is how my data is: UNKNOWN UNKNOWN UNKNOWN SEG034-PI-012.038 SEG034-PI-012.039 SEG034-PI-012.038 SEG034-PI-012.038 SEG034-PI-012.038 SEG034-PI-001.019 SEG034-PI-001.019 UNKNOWN UNKNOWN SEG034-PI-001.019...
Back
Top