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