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

    Using Drag to keep range patterns w/out Macro

    I have posted a sample file. Basically, the end result I would like to achieve is an easier way to add additional providers to the Service Provider worksheet and additional services to the Service Type worksheets, for each child 1-5, and across the 4 scoring metrics, Same, Positive, Worse, and...
  2. G

    Using Drag to keep range patterns w/out Macro

    first 11 cells, not 121...
  3. G

    Using Drag to keep range patterns w/out Macro

    The next hurdle this spreadsheet poses is adding additional categories. For example: =IF(AND(COUNTIF(INDIRECT("'Test Data'!D" & ROW($A1)*2 & ":D" & ROW($A1)*2+1), "Building Healthy Connections"),INDIRECT("'Test Data'!L" & ROW($A1)*2)>0, INDIRECT("'Test Data'!L" &...
  4. G

    Using Drag to keep range patterns w/out Macro

    Initial test I did looks like it will work...I have to put it in the spreadhseet I am using to work out the kinks with the exsiting format but this looks very promising. Thank you.
  5. G

    Using Drag to keep range patterns w/out Macro

    Thank you for welcoming me to the community! I am fairly new to using Excel as a "Power User", and this site has been helpful to clear many things up for me. Here are two formulas, using the ranges. The difficulty I have is dragging the cell containing the first formula, and then getting it...
  6. G

    Using Drag to keep range patterns w/out Macro

    I am trying to figure out a way to drag cell ranges, and have Excel recognize the pattern of the range. I have several thousand ranges I need to edit, and manualy copying new ranges becomes extremely time consuming. The ranges will reflect cells in the pattern A2:A3, A4:A5, A6:A7, etc. When I...
Back
Top