• 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

    Extract Names into Separate Columns

    I am trying to separate names into two or more different columns but am running into a problem. My data is in Cell A1 and is formatted as Initials, a hyphen, then the first and last name. There is no space, only a comma, between the next name, so it looks like: JED - John Doe,JMD - Jane Doe...
  2. M

    I need help sorting my list on my dashboard!

    The following formula works to pull the name I want from a large list of various client names. IF($AH3="0",IF($AH3>0,IF(O3>=$AJ$15,IF($AG3=0,INDEX($P4,MATCH($AJ$10,$T$3:$T$500,0)),""),""),""),"") My problem is that the list comes into my Dashboard on the same Row number as it is on...
  3. M

    round numbers inside a concatenate formula?

    Here is my formula, and it works great except that the average number has too many decimals! I just want to round it up to the nearest whole number. I assume I should use ROUNDUP, but I'm not sure where to put it in the formula. CONCATENATE("Actual Hours 31% or more under Estimate...
  4. M

    Count items in column that match a specific cell, only if another cell is 0?

    How can I count all matching items in a column that match a specific cell, but only if a third cell is equal to 0? I need to count everything in column A that matches cell D2, but ONLY if the same row in column B=0. column B is a Countif formula if that makes any difference. This probably...
  5. M

    Is there a way to delete an entire row if specific columns are blank?

    I am trying to create a list of only "Qualified" sales leads with their current activity. I have a sheet with a list of each salesperson's Contacts that includes their qualifying components indicated with a 'yes' in any or all of the component columns, G, H, I, and/or J. Then a sheet with a...
Back
Top