|
More site info...
MrExcel Message Board - www.mrexcel.com | Site profile
|
|
Site profile page for http://www.mrexcel.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.mrexcel.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.mrexcel.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 MrExcel Message Board:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
2,747
|
9,858
|
28,097
|
|
Post:
|
10,427
|
45,945
|
132,912
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for MrExcel Message Board (http://www.mrexcel.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.
|
|
|
|
|
MrExcel Message Board posting activity graph:
|
|
http://www.mrexcel.com Alexa graph:
|
Top authors on MrExcel Message Board during last week:
user's latest post:
Changes in excel 2003
Published (2009-11-08 22:16:00)
John Glad you got it fixed. Looking back at my post I see it wasn't too clear. I blame the fact that was the Sunday morning(ish) after the Saturday night and I was also listening to the football on the radio.:eekL
user's latest post:
vba shade a cell once its moved...
Published (2009-11-08 18:51:00)
Possibly challenge of the month or VoG is Excel-challenged Anyway. please note my new location - I won't be able to post during UK office hours.
user's latest post:
Excel Macro
Published (2009-11-08 16:48:00)
Re: Excel Macro Try (after activating the workbook): Code: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 31/10/2009 by dharmesh t ' ' Keyboard Shortcut: Ctrl+l ' With ActiveWorkbook With .Cells .Locked = True .FormulaHidden = False End With With .Range("L8:L69,N8:N69,U8:W69,AA8:AE69") .Locked = False .FormulaHidden = False End With End With ActiveSheet.Protect DrawingObjects:=False, Contents:=True,...
user's latest post:
Separating multiple values out...
Published (2009-11-08 13:48:00)
Actually, you shouldn't have to enter the 'bc' number, the code should be able to work that out from row 1. Change the first part of the code to Sub Text_To_Rows2() ? Dim myRange As Range, c As Range ? Dim tmp ? Dim rws As Long , nr As Long , i As Long , p As Long , fCol As Long ? Dim bc As Long ? Dim mpt As Boolean ? ?Application.ScreenUpdating = False ? With Sheets("Text to Rows")? '
user's latest post:
Data Consolidate
Published (2009-11-08 20:44:00)
Re: Data Consolidate Welcome to the Board! Quote: Originally Posted by varun3010 how do I attach the sheet? See: http://www.mrexcel.com/forum/showthread.php?t=89356 __________________ Smitty Every once in a while, there's a sudden gust of gravity... Microsoft Excel MVP
user's latest post:
User Defined Functions and...
Published (2009-11-08 23:24:00)
You could write UDF's like Code: Function Cur_G(ByVal Total as Double) as Double Cur_G = ConverttoCur(Total).g Exit Function
user's latest post:
Disappearing Balloons - Page 2 -...
Published (2009-11-08 02:31:00)
NEITHER!! When you create the DV on a cell, and use an InPut Message (2nd tab) these are filled in. What the macro is doing, is going to each cell with DV and removing the text that is there and replacing it with a Null. You don't have to do anything but RUN the macro. Try it out on a new workbook. On sheet1 add 2 or 3 cells with DV, using an input message. Then paste the code in a regular module and run it. The Messages will disappear,...
user's latest post:
Formula help needed
Published (2009-11-08 21:15:00)
Quote: Originally Posted by tchalker Hi, I need help with the following formula. If A = 8 or greater than 8 the cell needs to be 8 times 45 but if A is greater than 8 the difference needs to be multiplied by 60 Thanks for any help you can give me Trace Care to help with: Which cell needs to be 8 times 45? The difference between what?
user's latest post:
wild card comparing two data...
Published (2009-11-06 03:59:00)
As luck would have it I was perusing these forums looking at sections I had never seen and I came across a section for awards. Apparently there is an award for "Alan's UDF" You might want to check it out here: http://www.mrexcel.com/board2/viewto...=974873#974873 it will give you vlookup functionality where you can accept values that are "close"
user's latest post:
randomise formula---help
Published (2009-11-07 21:43:00)
Re: randomise formula---help Have you tried the solution offered by Richard? It should return the desired result. For a formula approach, with B2:B16 containing the names, try... D6: =COUNTIF(B6:B25,"?*") E6, confirmed with CONTROL+SHIFT+ENTER, and copied down: =IF(ROWS(E$2:E2)
|
|
|
Top 10 active forums on MrExcel Message Board during last week:
|
|
Top 10 forums on MrExcel Message Board:
|
|
|
|
Latest active threads on MrExcel Message Board:
Started 2 days, 22 hours ago (2009-11-07 05:13:00)
by Jaafar Tribak
AFAIK? there is no way to assign a Macro to an ActiveX control via the OnAction Property which i believe only works for shapes.
However you can assign a Macro by using either the VBIDE or a Class module. I prefer the latter method.
Place this code in the WorkBook module :
Code:
Public WithEvents CommandButtonEvent As CommandButton
Private Sub CommandButtonEvent_Click()...
Started 17 hours, 1 minute ago (2009-11-09 10:38:00)
by Andrew Poulsom
Started 1 day, 21 hours ago (2009-11-08 06:08:00)
by michals
Sport Stop Watch With Laps and Total
Hello, I have seen many threads about the stop watch but have problem to figure out which one will be best for me. I would like to create the stopwatch in excel where I can time single athlete (unlimited number) and check their splits/laps as well to get their total time. I would like to be able ...
Started 5 days, 10 hours ago (2009-11-04 17:30:00)
by needexcelhelp
How can I create a form from data that I have in an excel sheet? Would I need to import it into access or can I do it from excel?
Thanks much.
Started 9 hours, 21 minutes ago (2009-11-09 18:18:00)
by Domenic
Is this what you mean? Assuming that Column C contains the corresponding date (true date values), try the following formula that needs to be confirmed with CONTROL+SHIFT+ENTER...
=AVERAGE(IF(WEEKDAY( INDIRECT("C"&K701&":C"&L701) )=2,INDIRECT("D"&K701&":D"&L701)))
Here's an alternative, which avoids the volatile function INDIRECT...
=AVERAGE(IF(WEEKDAY(INDEX($C:$C,K701):INDEX($C:$ C,...
Started 11 hours, 40 minutes ago (2009-11-09 15:59:00)
by Domski
Try:
=ROUND(IF(OR(LEFT(D25,1)="Z",LEFT(D25,2)="OC"),( H 25-F25),0),2)
Dom
Started 9 hours, 34 minutes ago (2009-11-09 18:05:00)
by taigovinda
Was there a problem with using the formula provided in post #2 of this thread? http://www.mrexcel.com/forum/showthread.php?t=4278 25
If you provide the name of the sheet that contains the data (e.g., sheet1) and the row range that contains the data (e.g., row 1 thru 15), then I can help you adapt that formula so that you can paste it onto the other sheets.
Started 9 hours, 58 minutes ago (2009-11-09 17:41:00)
by Norie
That code does not open a file.
Sure it gets a filename but it definitely doesn't open a file.
Perhaps you want something like this, which would come after that code.
Code:
Set wbOpen = Workbooks.Open(FileName:=FileToOpen)
That should open and create a reference to the file chosen using GetOpenFileName, and you can use it in any subsequent code.
Started 9 hours, 35 minutes ago (2009-11-09 18:04:00)
by schielrn
How many buttons are there?
|
|
Hot threads for last week on MrExcel Message Board:
Started 1 week ago (2009-11-02 12:52:00)
by ROKYD
MOD 10 calculting
Dear all,
I have that formula on excell to calculate the MOD 10 value for a DIGIT CHECK.
BELOW THE FORMULA.
=10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9,11,13,15,17 },1))+
SUMPRODUCT(--MID(A1,{2,4,6,8,10,12,14,16,18},1)*3) ,10)
It works for a number but it is not working for the other.
Please;...
Started 1 week, 1 day ago (2009-11-01 15:27:00)
by ROKYD
Please, who can provide me a full formula enabling me to calculate the check digit(MOD 10) of the a given number?
PLEASE HELP ME . I NEED THE INFORMATION AS SOON AS POSSIBLE.
IAM RUSHING AND I DO NOT KNOW HOW TO OPERATE?
Started 4 days, 4 hours ago (2009-11-05 22:53:00)
by BC...
I haven't worked with subtotals in a while, but when you set your subtotal to every change in col D there is a check box for all the other fields you want to subtotal. Select a cell in the table and then Data-Subtotals menu and check all the columns you want subtotaled in the Add to Subtotal section.
Started 5 months, 3 weeks ago (2009-05-16 16:15:00)
by Bonkers Bill
Thanks for the VBA which works, its taken time to finalise the layout of my sheet so now the formula is incorrect, i had a go at changing it but i got dates on 4 colums when i wanted them on 2?
if you could further help me out i would be greatful, i would like the dates in columns A,B,C from row 8 down to correspond with G,M,O
A-G
B-M
C-O
Cheers.
Started 6 days, 3 hours ago (2009-11-04 00:38:00)
by devintaylor
Excel Question
Hello,
Last week i posted on here and got some great help. I have one more question.
I have sucsessfuly been able to link my Stock trading platform to Excel.
I was told to use this formula =SUM(a1:a10,1038.25,b1:b10).
This worked great. (Thanks again Gerald) Its telling excel to look at all the cells in the ...
Started 1 day, 23 hours ago (2009-11-08 03:40:00)
by sponger
functions and formulas for Dummies
This formula is functional , provided by a programmer
for a charting program written on Excel Worksheets.
I copied it directly into my Excel workbook and it obtains an
error message.
=AND(C
Started 1 week, 2 days ago (2009-11-01 00:48:00)
by hjscm
Help with time in excel for mac
OKay so i am new to excel for mac. i used to be pretty good on the pc but for some reason mac is really hard for my in ms office. i am trying to to a timesheet. i want to be able to just type say 3p and have 3:00pm come up. now for time out would be say 6p. then formula for 3-6 which says 3 hours...
Started 1 week, 1 day ago (2009-11-01 14:16:00)
by MyExcel
Indirect Error
Sheet1 A B C D E F G 1 #VALUE! Jan 2 Feb 3 Mar 4 Apr 5 May 6 Jun 7 Jul 8 Aug 9 Sep Excel 2007
Array Formulas Cell Formula A1 =SMALL( IF( ...
Started 5 days, 5 hours ago (2009-11-04 22:31:00)
by Firecop1348
log in using vb
I m looking to create a log in form for Excel with different user names and passwords. I found this code From LENZE when I open the workbook It goes right to the "OOPS" and I have to exit the book. I also used this form from PXSPORTZ http://www.spudsbar.com/pw.xls
It works but I dont know how to add user names. ...
Started 5 days, 16 hours ago (2009-11-04 11:36:00)
by Bonkers Bill
Re: most consecutive problem
Sorry for the delay in getting back.
the mistake i made was i only gave the formula for one row and not two, the one row formula works perfect but when i add a second row (formula below) it will count either the 1st or last W which is in the same column as an L, i only want to count the most ...
|
|
Size: 1,741 bytes
