|
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,310
|
5,444
|
15,661
|
|
Post:
|
4,584
|
18,407
|
54,784
|
|
|
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:
Is there a way to mass...
Published (2009-11-07 18:27:00)
Sorry, yes, I should have been clearer... the variables are declared (so will not debug) but they're not being declared quite how you think... if you bring up the Locals window when you iterate your code you will see how i for ex. is being initialised as a Variant rather than an Integer (as I suspect you suspect it is). I will look into this thread again tomorrow in regard to your output question - if not resolved in the meantime by...
user's latest post:
Cancel Pushbutton on Dialogue Box
Published (2009-11-07 20:53:00)
A string variable is a 4-byte pointer. That pointer points to a location in memory that in turn contains a four-byte pointer to the first byte of a Unicode character string in memory. StrPtr returns the address of the pointer -- in other words, a pointer to the pointer of the memory address of the beginning of the string. If you dereference both pointers to the memory where the string resides, it is preceded by four bytes that specify the...
user's latest post:
Saving Notepad from VBA
Published (2009-11-06 11:18:00)
Your post does not comply with Rule 2 of our Forum RULES . Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
user's latest post:
VLOOKUP inconsistently returns...
Published (2009-11-06 08:44:00)
Quote: I've noticed that the spaces aren't preserved to maintain the setup of the table that I've illustrated in my previous post for you. If you use code tags, the result will be better. without code tags, HTML will by default trim spaces it deems unnecessary (ie more than two spaces in a row will be reduced to one space - and poooof, goes your layout). Best really is to post an Excel file.
user's latest post:
Modifier based sum
Published (2009-11-07 18:34:00)
Hi Janbi. Two questions: 1) What game is this for? 2) Changing C6 to YES is supposed to change what other formulas? If necessary, show two versions of the sheet in question...one showing value with YES in C6, the other showing the desired values when C6 is NO. Highlight the cells in question if not obvious. We can probably help with good examples.
user's latest post:
Insert rows with formula
Published (2009-11-05 16:43:00)
Welcome to the forum, Your post does not comply with Rule 2 of our Forum RULES . Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
user's latest post:
Plots: Can I have 2 series with...
Published (2009-11-07 07:45:00)
By default each series will be different. But once created you can format the series to have the same marker and colours. I just formatted the series and picked the same diamond marker to match all series to the first.
user's latest post:
Entering mathematical formula
Published (2009-11-07 18:06:00)
I've looked into the formula, and I found 1 error. I intailly was dividing 0.25 into Pi, whereas it should be timeds. This still didnt give the answer you were expecting. I then broke it down into parts. So doing each part of the equation as a sperate sum and the result was still incorrect...
user's latest post:
Roulette Win/Lose column
Published (2009-11-07 23:47:00)
All hail SloJoe, the man who has figured out how to predict random events! Can you tell me what the lottery numbers for this week are going to be? SPC is used when you can actually control, influence, or at least accurately measure the process producing the results. You won't even have access to the precise conditions of the process. Things that are random, like how fast the croupier spins the wheel and precisely when he lets the ball...
user's latest post:
Cancel Pushbutton on Dialogue Box
Published (2009-11-07 22:33:00)
Hello AccountantCost, If you or anyone else really wants to know the story behind the StrPtr function and learn about how VBA handles strings then have a look here . This is almost verbatim from Stephen Roman's book on Excel macro programming.
|
|
|
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 1 month, 2 weeks ago (2009-09-24 10:26:00)
by antoka05
Try to run macro 'Macro1' in attached file... I hope it can help you.
Regards,
Antonio
Started 1 day, 23 hours ago (2009-11-07 20:00:00)
by shg
First, split col C into two columns, with the start time in col C, and this formula in D4 and copied down:
=C4 + 9/24
Then in I4 (allowing for the inserted column) and copy down,
=SUMPRODUCT( ($C$4:$C$13<=G4) * ($D$4:$D$13>H4) * $B$4:$B$13)
Code:
---B---- -- C-- --D-- E F -G-- -H-- ---I----
3 Staffing In Out From To Staffing
4 1...
Started 1 day, 8 hours ago (2009-11-08 11:07:00)
by Krishnakumar
Hi,
See: http://www.ozgrid.com/forum/showthread.php?t=73749
Started 2 days, 20 hours ago (2009-11-06 22:22:00)
by darkyam
Perhaps =STEYX(edz!$G3:$G41,INDEX( dji!$G:$G,ROW()):INDEX(d ji!$G:$G,38+ROW()))
Started 2 days, 2 hours ago (2009-11-07 16:56:00)
by DonkeyOte
You need to SUM the range (H$10:H34).
On an aside... Brighouse... I think I've been to a car auction there... inane fact but there you go !
Started 2 days, 16 hours ago (2009-11-07 03:19:00)
by mikerickson
What kind of combo box is it? Userform, ActiveX or Forms menu?
Started 1 day, 8 hours ago (2009-11-08 10:58:00)
by DonkeyOte
Not sure why you need to know the address per se (it's rarely required in string form), however, if your range is a vector
=ADDRESS(ROW(),MATCH(MIN(A1:D1),A1:D1,0),4)
|
|
Hot threads for last week on Excel Help Forum:
Started 3 days, 9 hours ago (2009-11-06 09:43:00)
by drchris Registered User
Please Register to Remove these Ads
Guys,
I have problem which has been puzzling me today at work and I would like someones help please.
I have a sheet where you paste data in it, and by pressing a button sort_data it does a lot of sorting, filtering, deleting and so on. That works fine.
Then, I wanted to delete data according to a list and followed ...
Started 6 days, 9 hours ago (2009-11-03 09:24:00)
by NBVC
Judging by your samples, it really looks like you just want to keep what is in between brackets in tact.
If that is really the case, then try:
=LOWER(LEFT(A1,FIND("(",A1)))&MID(A1,FIND("(",A1) +1,255)
Where A1 contains first entry.
Started 5 days, 11 hours ago (2009-11-04 07:39:00)
by Mr D
Maybe if you should teach them. instead of giving them tasks you cant complete yourself. you clown
Started 6 days ago (2009-11-03 18:55:00)
by DonkeyOte
Either
a) add some code to the Workbook_BeforeClose routine to unload the reference(s) such that they are not missing on open
b) use Late Binding and avoid need for referencing libraries in first instance
(can make coding trickier and I would say it's not always possible pending the actions being performed)
Examples...
http://www.excelforum.com/excel-prog...ough-code.h tml
Started 4 days, 23 hours ago (2009-11-04 20:07:00)
by shg
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
myMacro
End Sub
Adding Code to a Sheet module
1. Copy the code from the post
2. Right-click on the tab for the relevant sheet and select View Code. This opens the Visual Basic Editor (VBE) and shows the object module for the selected worksheet.
3. Paste the code in the window
4. Close the VBE to return to ...
Started 4 days, 17 hours ago (2009-11-05 01:36:00)
by Leith Ross
Hello adamgrier,
I wrote a macro back in April that allows the user to add checkboxes to a selected range of cells and choose the macro to run and the linked cell, if one will be used.
What determines the date to placed in the cell to right of the checkbox? What colors do you want to use?
Started 4 days, 23 hours ago (2009-11-04 20:02:00)
by teshiburu1988
Bump - Hopefully Will Have A Reply in the morning
Started 4 days, 1 hour ago (2009-11-05 18:13:00)
by rwgrietveld
Have you tried the help on Lookup?
Quote:
If LOOKUP can't find the lookup_value, it uses the largest value in the array that is less than or equal to lookup_value.
If lookup_value is smaller than the smallest value in the first row or column (depending on the array dimensions), LOOKUP returns the #N/A error value.
As long as all the ...
Started 6 days, 10 hours ago (2009-11-03 09:15:00)
by royUK
You need to create Dynamic Ranged Names for the data - one for each relevant drop down - Data validation - http://excel-it.com/data_validation.htm . Combine that with VLOOKUP - see the example sheet provided
Started 6 days, 11 hours ago (2009-11-03 07:31:00)
by Cheeky Charlie
Hi, you can upload examples to the forum when editing a post (edit - go advanced - manage attachments is at the bottom of the edit window).
It's not easy to picture your problem, but:
(a) using different sheets in the same workbook makes them significantly easier to work with
(b) you can select the fill handle ( little black square on the corner of the active cell) and drag it to copy ...
|
|
Size: 155 bytes
