Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.04 seconds.
Search: Posts Made By: shades
Forum: Excel 08-10-2009, 07:47 AM
Replies: 1
Views: 1,981
Posted By shades
Re: help with INDIRECT

My guess is that it is beginning to treat like a date. It might be better to label the worksheets with 200901, 200902, etc. That way they can be sorted as needed and fulfill the date requirements.
Forum: Excel 12-08-2008, 09:04 PM
Replies: 17
Views: 2,520
Posted By shades
Re: Sum data based on month

Howdy. Sounds like maybe a lookup table for dates might be a starting point; makes life much simpler to expand.
Forum: Excel 12-02-2008, 03:53 PM
Replies: 5
Views: 1,226
Posted By shades
Re: How to call a function in an addon

If the add-on is provided by someone, perhaps even free, it may still be a protected VBA project, and so you wouldn't be able to access that add-on. Thus, if you contact the developer, ask about...
Forum: Excel 12-02-2008, 03:50 PM
Replies: 2
Views: 931
Posted By shades
Re: Conditional Formatting

Although you will want to select A2:A10 based on OP requirements. ;)
Forum: Excel 11-28-2008, 09:01 AM
Replies: 4
Views: 1,025
Posted By shades
Re: Values do not update

Sometimes an inadvertent key combination can turn it off.
Forum: Excel 11-26-2008, 03:14 PM
Replies: 6
Views: 3,507
Posted By shades
Re: Vlookup vs. Index/Match

Yes, I think that is what he means.
Forum: Excel 11-26-2008, 08:31 AM
Replies: 6
Views: 3,507
Posted By shades
Re: Vlookup vs. Index/Match

Howdy, Ed. As noted on another thread, with my new position (since April) I don't get here often, but I occasionally miss the work in Excel. Then I sit down, and it passes... ;)
Forum: Excel 11-26-2008, 06:56 AM
Replies: 6
Views: 1,099
Posted By shades
Re: Conditional Sums?

A solution from almost a year ago. Wow, the last time I was called a "kid" was about a half century ago. :D

You are right, Mike. I seldom get by here with my new position (seminary president). But...
Forum: Excel 11-26-2008, 06:51 AM
Replies: 6
Views: 3,507
Posted By shades
Re: Vlookup vs. Index/Match

Howdy. With VLOOKUP the column on the left has to be sorted for it to work properly. For INDEX/MATCH, there is no need to sort, and you can use any column to do the lookup. INDEX/MATCH is much more...
Forum: Excel 10-30-2008, 10:28 AM
Replies: 4
Views: 1,037
Posted By shades
Re: Charts - Lining up one data series with another

Howdy. Make that a second axis.
Forum: Excel 09-28-2008, 06:48 PM
Replies: 1
Views: 1,202
Posted By shades
Re: Chart with VBA

Howdy. Check out Jon Peltier's VBA approach to charts (http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html) dealing with series.
Forum: Excel 09-12-2008, 07:18 AM
Replies: 4
Views: 1,083
Posted By shades
Re: Help with compacting & optimization

Howdy. A little further explanation might be in order. :)
Forum: Excel 08-28-2008, 09:11 AM
Replies: 6
Views: 879
Posted By shades
Re: Using the answer from a formula

Well, up to three conditions. :D

Anything more and then you need code.
Forum: Excel 08-22-2008, 02:39 PM
Replies: 2
Views: 1,136
Posted By shades
Howdy. For conditions above three, use VBA. Check...

Howdy. For conditions above three, use VBA. Check on the forums for VBA conditional formatting.
Forum: Excel 08-13-2008, 05:26 PM
Replies: 5
Views: 1,025
Posted By shades
Howdy. Assume duty is in Col A and StaffNo in Col...

Howdy. Assume duty is in Col A and StaffNo in Col B and each starts in row 2. In Col C2, put this formula:

=A2&","&B2

Copy down as appropriate.

Is that what you are wanting?
Forum: Excel 08-11-2008, 06:18 AM
Replies: 6
Views: 1,465
Posted By shades
Another reason to have your data on one (or more)...

Another reason to have your data on one (or more) worksheet, your setup on other worksheets, and your display on still other worksheets.
Forum: Excel 08-09-2008, 08:02 PM
Replies: 6
Views: 1,465
Posted By shades
Yes, you would need to have another column for...

Yes, you would need to have another column for each blank space in the data. Be sure to look at the options after the chart is made, so that empty cells are not plotted (uncheck the check box to that...
Forum: Excel 08-07-2008, 06:12 AM
Replies: 7
Views: 4,019
Posted By shades
Will that eliminate the issue though, because the...

Will that eliminate the issue though, because the average is still counting number of cells? (I don't have Excel currently, so can't check).
Forum: Excel 08-05-2008, 09:08 PM
Replies: 7
Views: 4,019
Posted By shades
Howdy. You could use an IF statement combined...

Howdy. You could use an IF statement combined with COUNTIF and then use the average based on that.
________
Stobart motorsport (http://www.ford-wiki.com/wiki/Stobart_Motorsport)
Forum: Excel 07-24-2008, 03:41 PM
Replies: 7
Views: 10,220
Posted By shades
That's good. But be sure everything works as you...

That's good. But be sure everything works as you intend in several scenarios, because in some contexts, ISERR (and other error functions) can obscure future problems.

(Note that ISERROR was the...
Forum: Excel 07-03-2008, 12:14 PM
Replies: 8
Views: 1,243
Posted By shades
If you created the Pivot Table with VBA right...

If you created the Pivot Table with VBA right after opening, then you could have it built in.

I don't have time to look for the code, but again, check chapter 12 of VBA and Macros for MS Excel for...
Forum: Excel 07-02-2008, 02:47 PM
Replies: 8
Views: 1,243
Posted By shades
Howdy. :Pivot Table caches tend to stay put. You...

Howdy. :Pivot Table caches tend to stay put. You might be better off deleting the Pivot Table and starting over, so that all "old" data setups can bee deleted and you only have the latest data. That...
Forum: Excel 07-02-2008, 08:11 AM
Replies: 7
Views: 1,083
Posted By shades
Howdy. UDFs are not automatic. So you need to...

Howdy. UDFs are not automatic. So you need to write some VBA code (probably one line would do it) to be triggered with any change in the worksheet.
________
CHRYSLER RFE TRANSMISSION SPECIFICATIONS...
Forum: Excel 07-02-2008, 06:35 AM
Replies: 3
Views: 1,372
Posted By shades
I checked in that book I mentioned in the post...

I checked in that book I mentioned in the post above. If you look at pages 256-257 and modify the setup you will get exactly what you want. I had setup something like that about a year ago. Note,...
Forum: Excel 07-01-2008, 04:50 PM
Replies: 3
Views: 1,372
Posted By shades
John Walkenbach has some samples in his book...

John Walkenbach has some samples in his book Excel Charts, chapters 7 and 8. You might want to look there.
________
New Yorker (http://www.dodge-wiki.com/wiki/Chrysler_New_Yorker)
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:31 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World