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

    VLOOKUP (I think)

    Help, it's been years since I used Excel and I need to update the email addresses (Column G) in the 2nd tab (22-23) with email addresses from the 1st tab (21-22) where the conditions of Columns A match (Centre Name). If it's possible to populate based on Columns A & C matching would help even...
  2. M

    Transfer data from one sheet to another based on cell criteria

    Greetings I have 2 sheets and need to transfer the Students Taken in 2018 information from SiteTotals.csv sheet into Schools for CRM matching the schools. Please help, as I', unsure what is the simplest way to achieve this without manually copying each cell and pasting when working with a...
  3. M

    Conditional Formatting Multiple Formulas

    Hi Excel Geniuses I've attempted to create formulas here that reference texts in column H to fill the entire row i.e. 1. "Open" returns no fill for the entire row 2. "Complete" or "Complete *more text*" returns blue fill for the entire row 3. "In Progress" or "Awaiting *more text*" or "Review...
  4. M

    How to split a cell by case

    Dear Chandoo What's the best formula to split a cell by case. In the below example, how do I separate 15 Potts St from RYDE NSW 2112. 15 Potts St RYDE NSW 2112 Thank you
  5. M

    Convert Excel Data to Calendar

    Dear Chandoo Gurus I have Excel 2007 and am trying to creating a calendar from data. As I will need to modify the data on a regular basis I need to create a calendar that amends automatically with each update to data. Please see attached and advise what is the most efficient way to create one...
  6. M

    VLookUp / IF / Match Help

    Dear Excel Whizzes & Wizards I am trying to match a code to one s/sheet from another within the same workbook. I pretty much copied a formula sequence from my predecessor's files to no avail. Please take a look at my formula in Cell V3 of my dummy file and advise where I have gone wrong...
  7. M

    Look up Data

    Dear Chandoo Please forgive me if the title is not accurate. I am a fairly basic user of Excel and have just started a role that requires much reporting. I have an email exclusion list and would like to know the best formula to search current data to exclude the emails from my list. I have...
  8. M

    Creating a quick project plan / gantt chart using conditional formatting

    Dear Chandoo Under your tip entitled: Conditional Formatting in Excel – 5 Tips to make you a Rockstar, I tried tip # 2 for a gantt chart and it didn't work for me. There are 3 bullet points, I followed the 1st by creating the table structure. I am unclear about the 2nd and 3rd bullet points...
  9. M

    Macro to sort Worksheet by cell reference text

    Dear Chandoo you genius you, pls advise if possible to sort multiple worksheets by a cell reference text using a Macro. I am also curious to know if possible for cell reference by colour. Thank you
Back
Top