Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gymnast14

    Excel: Can't select table array for VLOOKUP. Help!

    Kristal - You are a genius. This is exactly what was causing the issue. I had search all over and couldn't find anything. Thank you SO much for answering! We are happy campers here.
  2. Gymnast14

    Excel: Can't select table array for VLOOKUP. Help!

    Hmm, interesting. I do know for a fact that she did have two instances open. I will go over to her computer later today and try your suggestion! I'll let you know what happens. Thanks!
  3. Gymnast14

    Excel: Can't select table array for VLOOKUP. Help!

    My co-worker is trying to do a VLookup between two spreadsheets. When she does step 2 of the formula, table array, she clicks over to the other worksheet to try to select the range of cells. However - nothing happens! She doesn't get the blinking "Selected" indicator. I emailed myself the same...
  4. Gymnast14

    PS_Genl_Deduction table not pulling all employees

    I'm trying to run a report of all employees with certain deduction codes. The PS_Genl_Deduction table is not pulling all employees. I look in Enterprise and I can clearly see that a certain employee has a certain deduction, but they will not pull in on my reportsmith report! Any ideas?
  5. Gymnast14

    Pull only most recent record where Job.Change_Pct <>0

    Hello everyone, I'm trying to write a report that pulls an employee's most recent pay change only. The problem is, some of our data entry folks don't always use an action of PAY - I had one example this morning where they used "Promotion" with a reason of "Normal Step Progression". So, I...
  6. Gymnast14

    Word: Formating Merge Field - TIME!

    Yeah, the excel spreadsheet just has 8:44 as the value. Here are some screenshots of what I'm working on. Excel Document (using the "Distance" field) Word mail merge - how the value comes across
  7. Gymnast14

    Word: Formating Merge Field - TIME!

    I have an excel document with data in time format. For example, 8:44. When I click on the cell, Excel shows it as 8:44:00 AM I'm merging into a Word document. I cannot find a good switch to format the time correctly. I just want it to show "8:44". Right now I am trying: { MERGEFIELD "Distance"...
  8. Gymnast14

    Excel: Nested IF statement with INT formula within

    The "WHAT???" will be a 0. Sorry I didn't specify that. THANK YOU so much for your help! The formula works perfectly.
  9. Gymnast14

    Excel: Nested IF statement with INT formula within

    Hi, I need help writing a nested IF statement with a formula within the statement...if that makes sense. Here is what I'm trying to do, in english: If cell = 0, then calculate =INT((Date2-Date1)/7), if the formula result is greater than 25, then 1, else 0. Is this even possible? Thanks in...
  10. Gymnast14

    HTML Editor removing my "getdocument.axd" link

    I'm not sure if this is an HTML issue, or just an issue with the portal website I'm using. Long story short - I'm trying to link to some files on another server. The files have the "getdocument.axd" type links. Here is a censored version of my link...
  11. Gymnast14

    How can I pull future New Hires?

    I'm trying to pull a list of new hires, and some have a future hire date (3/24/08). The future dated employees are not showing up on my report. Any suggestions? I'm using some very simple simple selection variables: Job.Action = HIR Job.EffDt >= 2/29/08 Here is my SQL: SELECT DISTINCT...
  12. Gymnast14

    Excel: Only allow one checkbox to be checked per section?

    I have an unofficial "form" in excel. I have a group of five statements under a category, like "Motivation". I have a checkbox next to each statement. I only want to allow one checkbox to be checked per category. How can I do this?? To clarify, I haven't done anything to make this an official...
  13. Gymnast14

    Word: Assign numerical values to checkboxes, and then add them up?

    Ha. Fair enough. I think I'll save myself the frustration and just go straight to Excel.
  14. Gymnast14

    Word: Assign numerical values to checkboxes, and then add them up?

    One more thing: It doesn't HAVE to be a checkbox. It could also be an Option Button or Radio button, etc.
  15. Gymnast14

    Word: Assign numerical values to checkboxes, and then add them up?

    Hello again, I have to design a performance review form and I want to try to use Microsoft Word. However, I have a sticky situation: I have a category: Appearance. Then I have descriptions like: A. Carless about appearance B. Acceptable appearance C. Neat and tidy The manager would check a...
  16. Gymnast14

    Excel: Change the font of the data validation dropdown?

    Ok, thanks for the reply!
  17. Gymnast14

    Excel: Change the font of the data validation dropdown?

    The font in my data validation list/dropdown menu is too small. Can I change the font somehow? To clarify, I want to change the font of the actual list values, when you are looking at the dropdown list...not after you tab off of the cell.
  18. Gymnast14

    SUMPRODUCT with 3 conditions?

    I figured it out. UGGGHH. How frustrating. One person was missing a term reason, and so my Vlookup formula was displaying #NA for her "Voluntary/Involuntary" designation. She was halfway down the list so I didn't even notice it. I hate it when it's something so STUPID like that! Thanks for your...
  19. Gymnast14

    SUMPRODUCT with 3 conditions?

    I keep getting the #NA error. I think you guys are right, it's something wrong with my values in column S. I'll keep trying and let you know if I can get it to work.
  20. Gymnast14

    SUMPRODUCT with 3 conditions?

    After pouring through threads about Sumproduct, all of the examples seem to only have two conditions. Can you have three? Because I'm having a doozy of a time trying to get this formula to work: '=SUMPRODUCT(('Turnover - Terms'!H2:H1249<=DATEVALUE("01/31/07"))*('Turnover -...

Part and Inventory Search

Back
Top