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

    what brands a user has.?

    Dear Excel Gurus, i came across a situation wherein i have to answer what Brands a user has.? Please refer to attached file. i have a user list with product brands owned by them. Now in the last columns (K in my data), want to get the Name of Brands a user has. (column K will update as soon a...
  2. C

    Sumif Help

    Hello There, i am stucked at one step. i have a month wise data and wanted to sum only till the month selected by User. ex. if a user wants a data only till Feb, then the sum should be only for 02 months, i.e. Jan and Feb. Have attached a Sample excel file for reference. Thanks in Advance...
  3. C

    Calculate Hours difference

    Hello Everyone, I have Incident Open Date & Time and Incident Close Date & Time. I need to calculate the hours difference between these 02 dates & time. It has some condition as below: The hours difference calculated is only between morning 08:30 to evening 06:30. Difference counter stops as...
  4. C

    Jump directly to linked cell in a formula

    Dear Excel Savvy, I have a Excel workbook with multiple worksheets in it. And one worksheet named as “Summary”. In this Summary sheet all other worksheets are linked with formula. Ex. =Calc!F16. Now the problem is, can I jump directly to the Cell in calc sheet from where the value in Summary...
  5. C

    Rows Grouping Help - VBA

    Hi There, I am using MS Excel 2010. Whenever I create a Group on Rows, bydefault it adds a PLUS sign buttons on left side of Column A below to the selected rows. I wanted to be added this PLUS button on the Upper side of selected buttons. Reference to the attached excel file. Have figured...
  6. C

    Concatenate based on Condition

    Hi All, I have the Product wise Print Quantity data available that is to be printed either with Digital or Offset technology. Any Quantity less than or equals to 99 to be printed Digitally AND any quantity Greater than 99 to be printed with Offset technology. I have find out the Digital and...
  7. C

    Finding matching qty from a group

    Hi All, I have an excel file wherein i have a rate card for the paper qty of different groups. The Rates available with me are for group of qty like, 0-100, 101-200 etc. The Rates are different for each group. Can any one please help me with deriving the exact rate from the group of qty...
  8. C

    Scrollbar misbehaving

    Hi All, The problem I'm having is that when I click the scrollbar, it keeps scrolling all the way, to either the left or the right, instead of moving incrementally one by one. I have set the incremental factor to 1, but it goes all the way as if I were continuously clicking the button. This...
  9. C

    Getting Max and Min Date from a Range, based on some condition

    Hi All, I have the machine serial number wise printed data on perticular Dates. I wanted to have the machine serial number wise summary wherein, i could figure out the first and last date of printouts taken from the machine with count of prints. Ex. My data looks like: Serial Number Print...
Back
Top