Recent content by will.b

  1. W

    Excel Any excel Wizards? Please help, can't find answer in any threads

    If you know the criterion that you're searching for (i.e. the word "Missy" somewhere in the column or column heading) and you know what column to find your values in, I would highly recommend using either COUNTIFS() or SUMIFS(), depending on what you want. Could you provide a small clip of...
  2. W

    Excel Solved - Using Excel 2007 Large()/Small() function without duplicate values!

    This solution also functions in Excel 2010 as well, now that I have it.
  3. W

    Excel Solved - Using Excel 2007 Large()/Small() function without duplicate values!

    Hello everyone! I have been working with a data set of mine that needed this issue resolved, and I think I got it. I seem to have resolved it in a very roundabout (and still somewhat unstable, I know - but bear with me) fashion, but it works :D. Let me give you my reasoning. My goal is to...
  4. W

    Excel Counting unique values in Excel, based on criteria.

    Thanks for your help everyone - still plugging away at it. Stoneboysteve- The problem with my data set is, yes, it only changes once a month. However, the unique values that I will be counting must be represented in dozens of different areas. I currently do exactly as you say, by using pivot...
  5. W

    Excel Counting unique values in Excel, based on criteria.

    I'm sorry, I forgot to mention that. I must do it for every month, which does not seem so bad when faced with using a pivot table. However, the data set I am applying it to not only must take into account 12 months at a time(it's going in a self-generating graph, which is easy - 200701,200702...
  6. W

    Excel Counting unique values in Excel, based on criteria.

    Hello everyone - i have been working with this for a while now, and I haven't made the kind of progress that I would like. I'm in Excel 2007, and i'm looking for a way to (using cell logic) to count a list of unique values in a column, based on a column with a month key (like "200702" means Feb...
  7. W

    Limiting Decimal Places in Report

    Depending on your application, this may be a quick fix as well: If you know that none of your resulting values (or the ones you intend to augment) will be negative, refer to it in your expression as Abs(Date1-Date2 or whatever), and now in the properties pane you can select "Fixed" - it will...
  8. W

    Decimal places and formatting within query! aargh!

    Well, with a bit of aimless perusing on the web, I have figured it out! Regardless of how it was formatted, it decided that it was going to stick to the full length of significant figures with no input from the "Decimal Places" tab. So, to combat this- I switched it to this- Expr1...
  9. W

    Decimal places and formatting within query! aargh!

    Hello everyone! I'm new to the forum, but I've been lurking about for a few weeks yet. I am having a recurring problem that I would like a little insight on. I have a database that is utilizing a query; this query is pulling two date ranges from a table. I want to find the difference...
  10. W

    Inserting attachment, as opposed to attaching with VBA Module

    Hello everyone - I have another question I would like some input on. I'm currently setting up an emailing system through the use of Access macros linked to VBA modules. I would like the emails with attachments to come up with the attachment inserted into the body of the text, instead of attached...
  11. W

    Sending email to a distribution list specified in Outlook

    Hello everyone! I'm new to the community, but have been lurking for a while. Here's my current issue, that I would like a little input on. I'm attempting to set up a macro coupled with an Access VBA module. Once you click a button that says "Email Reports", it will call up six different...
Top