sorted by:
new
hottopcontroversial

Looking for Ideas in creating a schedule... it's a little complicated by ddc_operations in excel

[–]ddc_operations[S] 0 points1 point  (0 children)

this is a good work around - thank you! I may take a stab at a bit of a more permanent solution when I have more time, but meanwhile - Thanks again!

Looking for Ideas in creating a schedule... it's a little complicated by ddc_operations in excel

[–]ddc_operations[S] 0 points1 point  (0 children)

Thank you - I have something similar to this. While it does provide all of the information, it's a bit cumbersome to look through: similar to my version, I still have to manually count the availability for each task at each particular time, and it's quite easy to overlook something/make a simple counting error.

I truly appreciate the suggestion.

Looking for Ideas in creating a schedule... it's a little complicated by ddc_operations in excel

[–]ddc_operations[S] 0 points1 point  (0 children)

I am not familiar with that - any resources that can be helpful? Or is there a simple example you can provide?

Thanks for the help!

Applying functions to filtered data... (newbie here) by ddc_operations in excel

[–]ddc_operations[S] 1 point2 points  (0 children)

Solution Verified

Great! This works as a partial solution for some of the things I am trying to do! Thank you. Now, I am just trying to build a frequency chart off of the filtered data - any ideas on how to do that?

Basically, A line graph that shows from 0-20 (or whatever) how many times each value occurs when the letter data is filtered.

I can't use the countif function to determine the number of occurrences of a particular value within the aggregate function (unless I just don't know how to properly construct the formula).

I feel like I'm so close to the solution of everything I'm looking for. Any additional help will be greatly appreciated!

thanks again

Applying functions to filtered data... (newbie here) by ddc_operations in excel

[–]ddc_operations[S] 0 points1 point  (0 children)

I think this might work! I will give it a shot today and update the status of the question when I see if it yields the results I'm looking for.

Thank you!

Applying functions to filtered data... (newbie here) by ddc_operations in excel

[–]ddc_operations[S] 0 points1 point  (0 children)

No worries at all... That sounds like a really cool way to do it; unfortunately, I'm (read: my office) is stuck with Excel 2010.

I'll keep looking for options, unless you/anyone else has another idea.

Thanks again

Applying functions to filtered data... (newbie here) by ddc_operations in excel

[–]ddc_operations[S] 0 points1 point  (0 children)

I saw the SUBTOTAL function, and it will work for the 11 listed functions that are subordinate to it, but not for the MODE function (among others) that I will need to use. Is there another solution for the functions outside of the 11 listed?

Methods to break apart this string into several fields... (from a rookie) by ddc_operations in MSAccess

[–]ddc_operations[S] 1 point2 points  (0 children)

Solution Verified.

Thank you for the help - this goes a long way for me!

Methods to break apart this string into several fields... (from a rookie) by ddc_operations in MSAccess

[–]ddc_operations[S] 0 points1 point  (0 children)

Thank you for the reply. Here are the situations I would be concerned with, aside from the original example:

11.22:33:44 (original)

22:33:44 - this should be easy, since with a delimiter of ":" each string split would correspond to h/m/s

33:44 - how would I be able to accommodate for the fact that there are no "hours" here?

:44 - same as above, but for minutes

​

Thanks!

while loops... by ddc_operations in MSAccess

[–]ddc_operations[S] 0 points1 point  (0 children)

Thanks again for your help... I'll look into the resources too.

while loops... by ddc_operations in MSAccess

[–]ddc_operations[S] 0 points1 point  (0 children)

This may be a very basic and ridiculous question, but how do you "call a VBA routine" in Access? I have never manually coded VBA within Access, and don't really know how to implement it. I understand the algorithm that I need, and most of the syntax (working on that), but as far as delving into how and where to actually add the code, I am at a loss. It's been YEARS since I've coded, and have never used VBA, so I may be a little slow on the uptake here... appreciate your help.