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

Summarize and paste the data based on criteria

V

Villalobos

Active Member
Hello Chandoo.org,

There were some changes in my system and due to this that formulae what I have used to summarize and paste (from Sheet1 to Sheet2) the data earlier, unfortunately not provide correct result anymore. My problem is that how to summarize and paste the data on Sheet2 from a new data source (Sheet1 - DATA SOURCE #2).

I have uploaded the sample file, wherein you can see the previously used formulaes.

Thanks in advance the reply!


P.S. The aesthetic flaw of this formulae was that I had to use an additional helper column. By the way to do that is there a simple VBA way to summarize and paste the data?
 

Attachments

Hello Somendra Misra,

Thank you for your time!
And how do you get the values in column H? I would like to avoid having to manually enter the values.
 
Hello,

I tested your solutions and those works fine so please receive my honorable mention.

My bonus question ;) regarding this would be that how could you avoid that if the value is 0 (on Sheet2 in J3), than do not appear in column J (Sheet2) this 0 value and "B" PN in column H (Sheet2)?
 
Hi, Villalobos!

In cell E2 there's a formula with this partial expression:
TEXT($B$2,"éééé.hh.nn")
I don't know how that date format arrived there, if manually entered or converted or how, but it's clearly wrong, if you see the same as I do. Try changing it so something allowed.

Regards!
 
You must log in or register to reply here.
Back
Top