• 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

    Paste link and transpose at the same time

    haha .. if u talking abt da alt + e + .. stuff well it is the shortcut on excel .. basically ALT E S gets you paste special box .. u cn type E for transpose and V for values .. will give u da result .. plzz forgive me for using short writings/grammar/errors of ny sort etc .. :)
  2. S

    Paste link and transpose at the same time

    paste link // umm nt sureif m getting it right .. bt u cn surely paste nd transpose simultaneously .. ALT + E + S + E + V .. basically it will get u paste special nd den do transpose + paste value together ..
  3. S

    Conditional copy

    use VBA .. make a sheet event which gets triggered on change event .. make E1 as target cell and set an if condition which says if its value id S then perform the task ..
  4. S

    Combine text from multiple columns based on condition

    create a function .. would be of the following sort .. concatenate_new(array,delimiter) .. you can pass the array that has to be worked on plus the delimiter which separates them ..
Back
Top