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.
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!
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...
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?
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...
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
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"...
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...
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...
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...
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...
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...
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.
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...
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.
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 -...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.