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

    sum-up only filtered data (contains different suffixes)

    hi Thangavel D, i have uploaded all soln. last solution of bosco's worked for me... with regards relio:)
  2. R

    sum-up only filtered data (contains different suffixes)

    hi, bosco... thanx and sorry for late to respond, i had some issues here but ur's 2nd solution worked for me and it resulted correctly till now. if any issues raised i will inform you, again i have uploaded all solution for others. thankyou with regards relio:)
  3. R

    sum-up only filtered data (contains different suffixes)

    hi, bosco, your sol. saved me, friend, thanx for working on this problem, just for curiosity asking, am really sorry, can we solve it without adding a new column becoz as narayan's sol. (separation of suffix & summing values) was a straight way solution with adding a column to data...
  4. R

    sum-up only filtered data (contains different suffixes)

    hello, 1) sol. its not working for other values (its good to avoid table) 2) sol. i don't want values get separated with suffix, when items are filtered then sum-up of qty will be shown in the top row 3) sol. working fine, i tried this, data on 1-sheet and result on another but here (others...
  5. R

    sum-up only filtered data (contains different suffixes)

    hello, to all, need help on this topic...
  6. R

    sum-up only filtered data (contains different suffixes)

    hi, rahul & to all i saw power query and Pivot table with Slicer is a good and neat way of data representation, but here it needs like "put the formula & get the result", personally i would like to learn more on power query and Pivot table with Slicer. thanx for this. i have uploaded all three...
  7. R

    sum-up only filtered data (contains different suffixes)

    Hi, thanx for response (David), adding another column for suffix is a straight solution, but here boys carelessly put any suffix, so as per bill (some time may have / may not have suffix), i need the solution (summing up values with suffix) which can trim all suffix inside the formula and then...
  8. R

    sum-up only filtered data (contains different suffixes)

    hello, this is relio new here, i have problem and uploaded xl-file for reference simple daily account data contains figures with suffix needed to sumup the values by the reference of items on left, i tried subtotal with sumproduct and messed up. thanx in advance for any help. relio
Back
Top