• 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

    Not sure where to start

    In the cell I have selected 37131, and the blue-highlighted portion is reflective of the complaint number. Had I entered another complaint number, then it would have highlighted the new complaint number entered in similar fashion. does this help?
  2. S

    Not sure where to start

    See attached sheet; In Q17, you would be able to enter the complaint number, and then the data that pertains to the complaint number you entered would highlight a different color.
  3. S

    Not sure where to start

    I am needing a kick start... I have a chart, product number, and several dates that pertain to each product number. Its a big chart. Id like to have a cell, where i can enter the product number. Then, the cells adjacent to that cell would return a few specific dates. Then, I could delete the...
  4. S

    Using single cell for two solutions

    I am looking to have a single cell where a user could put "+" or "-" and then a number in order to add points to a subtotal. This would allow points (Which are calculated) to be added/deleted to the total for usage elsewhere. In N8, the user would have the option to place points, and the "+" or...
  5. S

    Looking for a range of cells to be returned...

    That's what I went to doing, I was just curious if there was a different way. Thank you for your assistance.
  6. S

    Looking for a range of cells to be returned...

    Ok, here's an example.
  7. S

    Looking for a range of cells to be returned...

    I am looking for help in the following: I would like the user to input a value. Then, ideally, Excel would look at that value, look for the matching value in a list, and return a range of cells. Using MATCH only returns a single cell. Am I on the right track by researching MATCH still? I am...
  8. S

    Forcing the same result with MATCH

    Thank you Narayan, it works great. I know have to go educate myself on INDEX. Thanks again for your help! -Jeremy
  9. S

    Forcing the same result with MATCH

    Thanks for trying to help, I finally got home from work... :-) I did not include any formula, only an explanation of what I am trying to accomplish. Thanks for viewing the file.
  10. S

    Forcing the same result with MATCH

    I am using the below formula to gain a result: =MATCH(K1, $B$6:$F$6, 0) However, it returns the result in B6:F6, which the cell value differs. How do I force the result to be whatever value I want? I'd like it to return a single number, and be the same number as I utilize the above formula to...
  11. S

    Help with IF Statement

    Could you please delete the included file-- I accidently did not 'wash' the file of personal info.
  12. S

    Help with IF Statement

    The formula I was using is: =IF(M3<=3,4,IF(M3<=15,6,8))
  13. S

    Help with IF Statement

    I may over complicating the issue, but I am having such a problem with getting my simple IF statement to work proper. On tab LEAVE PROBABILITY, Leave Category should reflect the following: If employee has 3 years or less, then he is Category 4. If he is 3-15 years, then he is Category 6. If he...
  14. S

    Divide one cell text to two.

    Upload a document showing expected results and we'll see if we can help you.
  15. S

    Looking for a calendar solution

    The solution you offered is not what I am looking for, it is entirely different approach. In addition, it doesn't seem to work. Thank you so much for your time, and I do think I need to learn VBA. Regards, Jeremy
  16. S

    Using IF and AND to find a number

    Thank you Bosco_yip. Sometimes I tend to complicate things so much...
  17. S

    Looking for a calendar solution

    I was tasked with making an Excel workbook that helps management see at a glance, all available weeks of vacation remaining. In making this workbook, I have focused on formulas only, as I know nothing about VB. So far, all seems to be coming together. As I finish up though, I realized that I...
  18. S

    Using IF and AND to find a number

    I am looking for a formulas to Look at the start time and end time, compare it to the times listed, and if the times are as reflected, to put a "1" in the box, and nothing if it doesn't fit. I was using the following...
  19. S

    Multiple criteria RANK using dates

    Gotcha! Thank you for your explanation! Best regards, Semper5
  20. S

    Multiple criteria RANK using dates

    I just found out our rules do not permit us to use Excel RAND in order to break a tie for seniority. (Has to be a witnessed function). Is it possible for you to provide a way to highlight duplicates in order to manually enter the tie-breaker? seniority is based on EOD. If more than 1 employee...
  21. S

    Multiple criteria RANK using dates

    Wow, thank you very much. When I get to work I will look more in depth at this!
  22. S

    Multiple criteria RANK using dates

    I have attached a file with some notes. I don't understand RANK very well. Thank you for your help in this.
  23. S

    Multiple criteria RANK using dates

    vletm, Thank you for your help in this. based on the sheet you provided a solution, how can I add an additional column to add criteria for a tie breaker? Under the final rank column, there are still a few duplicate positions. These positions have a tie0breaker each year. Can you tell how to...
  24. S

    Multiple criteria RANK using dates

    Thank you so much! Seeing you used 'IF' and 'RANK', I will look at this when I am more awake to see how it works! Thank you for your help.
  25. S

    Multiple criteria RANK using dates

    Hello all, I am trying to rank people based on hire dates, including prior service folks. How do I use the RANK statement for multiple columns? If a person was hired the same day as another, I would want the prior service column to be the tie-breaker. I will also add an additional column to...
Back
Top