Aceman--Thanks for the info, at this point ANY news is good news. I'm at work at the moment, so I'll have to try what you suggested and continue reading. I'll let you know if that worked/helped. I appreciate all your help!
Deborah
I have a 2007 Access database to inventory my supplies. I was embedding pictures into the various forms and noticed that my database was exploding in size.In an effort to cut down on the size of my database, I followed the instructions on this truly incredible thread, wherein instead of...
Skip--Thanks for your reply. I guess, yes, that I mean I want to find the individual who is closest to "zero" on all three parameters, and if there isn't an exact match--zeroes on all parameters--who matches the model the closest.
Dallen/Deb--Thanks for this--I think this is exactly what I was...
I have a spreadsheet that holds information for over 1000 individuals. There are three scores per individual. We have a "model" individual and I want to find the individual that most closely matches the model. It doesn't matter if their scores are higher or lower, just closer.
Model Individual...
Thanks in advance for your help. My boss changed his signature and since then his emails do not reflect the font he has selected--Arial, black, 12 point. Instead, they are Helvetica, white, 10 point. He uses Word as his e-mail editor and he has no problems with Word. We have double-checked the...
Hi! I'm working with Excel 2002 and have a similar situation as 553, but instead of looking up a number, it looks up text. I'm wanting to find the average scores of different groups. The following formula is trying to give me the average of the test scores of individuals coded as Engineering...
Add on: On another site it was recommended that I remove the page of page code. When I did the report came up, BUT, now the Boys subject (which, again, only has 14 entries) is hundreds of blank pages long!!! Any new ideas? Thanks again! Deborah
I have created a report that lists quotations divided into subjects. An enter parameter box allows the user to determine which subject they want to see. Sometimes the report comes up with no difficulties. At other times, the bottom of the screen reads "Formatting page, press Ctrl+Break to stop ...
Ridge--Thank you for following up with me. I have been remiss in giving you kudos and I apologize for not thanking you for your help.
The big guy was unhappy with how the spread turned out, so we added another formula--the top 10 get the lion's share and the rest get what's left. So we used...
Thanks so much--and you're right! Either boss man has given me bad numbers or somebody's going to get a nice scholarship. I'd love to see the example. Let's drop total down to 10K and see how that works. Thanks!
Deborah
Thanks you're a lifesaver--dcspublicATSIGNattDOTnet
Trying to keep junk mail volume to a low roar. I'm getting e-mail for body parts I don't have!! LOL!! Hope you understand.
Deborah
This year there are 20 people. Next year there may be more. Points this year range from 22 to 100. Person with 22 points gets $500; person with 100 points gets $4,000. Is there some kind of sliding scale function in Excel that will appropriately allocate the rest of the funds?
I am working on a funding spreadsheet. We have applicants who have been scored "points". We have $100,000 to allocate to them. The person with the lowest points will receive at least $500.00 The person with the highest points will receive $4,000. We would like to distribute the remainder of the...
Thanks for trying. I must be typing something in incorrectly. When I try pwise's suggestion the total in the Billable Expense is always $15.00 regardless of which candidate I am viewing--some have no costs, others have hundreds of dollars.
When I try kewo99's suggestion, both the Total box and...
Good morning! I am a newbie, so please bear with me. I am creating a form that lists the costs associated with a candidate. Some of these costs we pass on to our clients, some costs we pay for. I have a subform that allows the user to list each item (travel, test materials, off-site office...
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.