|
More site info...
Excel Help Forum - www.excelforum.com | Site profile
|
|
Site profile page for http://www.excelforum.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.excelforum.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.excelforum.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Excel Help Forum:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
1,693
|
5,934
|
16,138
|
|
Post:
|
5,676
|
19,995
|
56,474
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Excel Help Forum (http://www.excelforum.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Excel Help Forum posting activity graph:
|
|
http://www.excelforum.com Alexa graph:
|
Top authors on Excel Help Forum during last week:
user's latest post:
Color Blank cells
Published (2009-11-21 17:00:00)
not really - this did not start as a VBA post - the other is in the programming forum, I do believe however this thread should be marked by OP as solved.
user's latest post:
Drop Down List Formatting...
Published (2009-11-21 13:10:00)
Not without VBA, unless you just use a fixed-pitch font and adjust the column with appropriately.
user's latest post:
Do spreadsheets auto save during...
Published (2009-11-21 20:39:00)
Did you save the document in an earlier stage? CTRL-S should become your favourite keyboard shortcut. After a system crash or restart with open files, Office applications will try to recover documents and show them in the auto recover task pane. If the file does not show up there, you're probably out of luck
user's latest post:
Combine vlookup and if
Published (2009-11-20 11:54:00)
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED] . (Also, use the blue "scales" icon in our posts to leave Reputation Feedback , it is appreciated)
user's latest post:
How to use sheet names in formulas
Published (2009-11-21 18:10:00)
Hi If sheet name in A1 then Code: =INDIRECT("'"&A1&"'!A"&200) Rgds
user's latest post:
Changing lowercase and UPPERCASE
Published (2009-11-20 11:12:00)
Have a look at the LOWER(), UPPER() and PROPER() functions in excel help files.
user's latest post:
building a chart to display time...
Published (2009-11-21 07:31:00)
The value for the time bar is too large. You need to calculate the time between start and finish. M21: =TIME(MID(B7,6,2),MID(B7,8,2),0)-TIME(LEFT(B7,2), MID(B7,3,2),0)
user's latest post:
Color Blank cells
Published (2009-11-21 11:07:00)
Get Around Excels 3 Criteria Limit in Conditional Formatting
user's latest post:
Way to check whether any cost...
Published (2009-11-21 01:03:00)
Not really, at least not that I can think of. There are two reasons for this: 1. No formula could take into account your N/A errors. You would have to fix those on VC DESC first. 2. Your data isn't in order according to AZ. If it can be put in order, then perhaps something can be worked out, but it would still have to be reordered after you've manually dealt with all your N/A errors.
|
|
|
Top 10 active forums on Excel Help Forum during last week:
|
|
Top 10 forums on Excel Help Forum:
|
|
|
|
Latest active threads on Excel Help Forum:
Started 22 hours, 13 minutes ago (2009-11-22 16:50:00)
by daddylonglegs
So if somebody was born on 10th July 2000 then the formula should show 8 right now (because as of 1st July 2009 age was 8) and will only change to 9 on 1st July 2010?
With DOB in A2 try this formula
=DATEDIF(A2,DATE(YEAR(TODAY()+184)-1,7,1),"y")
Started 22 hours, 17 minutes ago (2009-11-22 16:46:00)
by zbor
Started 1 day ago (2009-11-22 14:58:00)
by ConneXionLost
Hi Bob,
This approach doesn't involve any VBA, but it does provide a solution. Hope it works for you.
Cheers,
Started 1 day ago (2009-11-22 14:22:00)
by Richard Buttrey
Hi,
Can we start from the basics since there seems a lot of repetition and holding the lap ranges as say '1-7', '8-26' etc. only complicates any subsequent formulae.
Also I don't fully understand what the Lap Leaders column means. What happens if D Green also leads on a later lap than lap 7? or am I misunderstanding thi?
How do you enter your data. that's the first thing to ...
Started 22 hours, 46 minutes ago (2009-11-22 16:17:00)
by zbor
Started 23 hours, 17 minutes ago (2009-11-22 15:46:00)
by martindwilson
its in options,show formulas
Started 1 day, 21 hours ago (2009-11-21 17:10:00)
by davidmarlow
Apologies - ignore 1st file uploaded and see attached.....
This is also a growing table (i.e. can be adding extra columns and rows) so any solution needs to be flexible and easy to update.....
Thanks again
Started 3 weeks, 1 day ago (2009-11-01 12:28:00)
by Richard Buttrey
Hi,
It seems to work fine for me with the two files you attached. The only reason I can see that would make the macro start at row 37 is if B36 of the relevant Warehouse sheet was non blank.
As an aside, it may be more appropriate to use Data Filter Advanced and filter the Delivery Status workbook using a Criteria where Status = "Arr" and Destination not blank, and have the data output...
|
|
Hot threads for last week on Excel Help Forum:
Started 6 days, 22 hours ago (2009-11-16 16:21:00)
by daddylonglegs
Not sure what you mean by "find the next number". Do you want to find a number that's actually in the list or one that isn't? Perhaps you can give an example, sample data with expected result......
Started 3 days, 23 hours ago (2009-11-19 15:14:00)
by losmi8
Also, IF A=Mike and B=Tel instead, then I wouldn't want to multiply C and D. I would like the code to skip that row and continue searching for where A=Mike and B=Fax and only then do the =C*D.
And of course, I need to add up all of the results (so all the C*D's).
If anyone needs further explanation of what I need, please say so. I know I am explaining this in a very confusing way. ...
Started 5 days, 6 hours ago (2009-11-18 08:08:00)
by zbor
Go to Value field settings and change sum to average
Started 5 days, 4 hours ago (2009-11-18 10:46:00)
by martindwilson
Started 3 days, 14 hours ago (2009-11-20 00:33:00)
by Nigel Registered User
Please Register to Remove these Ads
I have a workbook with around 350 worksheets. A column in the main sheet contains a list of part numbers which correspond to the names of the worksheet tabs. When a cell on the main sheet containing a part number is selected I would like a macro to find the corresponding worksheet, move that worksheet to the end of the row of tabs...
Started 1 week, 1 day ago (2009-11-15 02:12:00)
by bong25 Registered User
Started 3 days, 7 hours ago (2009-11-20 07:47:00)
by zoolander_10 Registered User
Please Register to Remove these Ads
Just wondering if I can lock a worksheet to display the content within the window only. Eg 22 Rows by 6 Columns? Therefore stopping people tampering or moving objects?
Thanks
Started 3 days, 9 hours ago (2009-11-20 05:17:00)
by Julie Parker Banned User!
Please Register to Remove these Ads
Hi,
sorry if I put this in the wrong part of the forum but wondered if anyone could help me.
I have a large quite complicated spreadsheet which works fine when there are numbers in the relevant cells. However the blank sheet (which is going to be given blank and filled in weekly) creates the #DIV/0! in empty total boxes ...
Started 3 days, 18 hours ago (2009-11-19 20:45:00)
by davesexcel
Can you supply a sample workbook, so somebody can help you?
Started 1 week, 6 days ago (2009-11-10 13:30:00)
by StephenR
I think you'd need VBA to do that. Though perhaps not if the font colour is determined by conditional formatting?
|
|
Size: 342 bytes
