|
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,918
|
10,544
|
28,545
|
|
Post:
|
12,858
|
49,438
|
136,855
|
|
|
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:
This one is a doozy!
Published (2009-11-19 23:38:00)
Re: This one is a doozy! Chuck It really isn't necessary to use Select and you can't have just Sheets("Sheet2"). That really means nothing. I tried 'fixing' your code but due to the use of Select and the unreferenced ranges I just couldn't. Perhaps it was me but I just couldn't understand what the code is meant to do. As for the Long/Integer thing I think you might find some...
user's latest post:
Sum of first n from m cells
Published (2009-11-19 23:11:00)
Re: Sum of first n from m cells Quote: Originally Posted by jshah Hi peter, Thank you very much, i agree the original answer suggested by Aladin Akyurek is not correct as the per the question. Is there a way I can getting the answer without creating the "D" column in your answer. My spread sheet has over 1000 rows and I would like if possible, to find answer which does not involve creating of extra row for every row I have in the...
user's latest post:
value of data by date range
Published (2009-11-19 23:36:00)
You appear to have the data there (i.e. dates) to add either or both the quarter (how is this defined?) and week number (how is this defined?).
user's latest post:
Setting Objects To Nothing
Published (2009-11-19 22:43:00)
Re: Setting Objects To Nothing You release a (tiny) spot of the PC's memory. __________________ . Greetz Wigi -- TOPICS WITH A USELESS TITLE HAVE FAR LESS CHANCES FOR A SOLUTION -- http://www.wimgielis.be . Excel (VBA code + example files), sports and music.
user's latest post:
Countif Formula not working, why?
Published (2009-11-19 23:56:00)
I would now be checking if the values of the numbers are what you think they are. Maybe there is some special format on the cells that makes it look like 4000, when it really isn't... Try copying the f column, paste specail values onto another column. format that column as General does that reveal anything?
user's latest post:
Update Data Validation Entry...
Published (2009-11-19 23:50:00)
Re: Update Data Validation Entry Automatically I'm not familar with 2007, but I've heard it makes a difference how the file is saved!!File type. Check the help files for Event Procedures and Macros lenze __________________ If you have to tell your boss you're good with Excel, you're NOT!! All I know about Excel I owe to my ignorance! Scotch: Because you don't solve great Excel problems over white wine
user's latest post:
1st occurance of non blank cell...
Published (2009-11-19 16:53:00)
Re: Last occurance of non blank cell Quote: Originally Posted by Danny_1952 Hi, And what could we do to find the last occurance of a non blank cell? The content should be alphanumerical. Danielle =LOOKUP(REPT("z",255),Reference) returns the last text (alphanumeric) value, even if that's a formula blank. Reference can be a definite range like A2:A100 or indefinite like A:A. BTW, for a definite range.......
user's latest post:
summing values in column C based...
Published (2009-11-19 21:05:00)
Maybe this: Code: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Cells(Target.Row - 1, "A") = "Employee" Then Exit Sub If Not Intersect(Target, Range(" B11:B " & Rows.Count)) Is Nothing Then Application.EnableEvents = False If Cells(Target.Row, "A") = "" Then Cells(Target.Row, "A") = Cells(Target.Row - 1, "A") Application.EnableEvents = True...
user's latest post:
VLOOKUP to return image based on...
Published (2009-11-19 23:58:00)
Put all 3 images on the sheet in the same place, Set the visible property to false. Using worksheet level code monitor the cell and set the corrosponding image's visible property to true and the other two to false. If you are unsure how to do this, upload your images somewhere, I will pull them down, build a working model and send it back to you.
|
|
|
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 1 day, 3 hours ago (2009-11-20 19:30:00)
by Akashwani
MrExcel charity!
Good day,
I'm not sure if I am posting this in the correct place, so if it should be somewhere else could someone move it and let me know where it is please?
I have been using Excel and MrExcel for around 9 months now.
When I first started, I'm embarrassed to say that I didn't even know the difference ...
Started 5 hours, 1 minute ago (2009-11-21 17:47:00)
by tinkythomas
Hi,
A memo field is 255 character in length, so what your experiencing is normal.
Regards,
Started 6 hours, 56 minutes ago (2009-11-21 15:52:00)
by wigi
That's true.
Where do you put the declaration? In a standard Module?
Started 5 hours, 9 minutes ago (2009-11-21 17:39:00)
by wigi
The syntax is OK, hence it will be in your data...
Started 5 hours, 33 minutes ago (2009-11-21 17:15:00)
by phear_me
I think I fixed it:
=IF(D5 8,D5 12,D5
Started 23 hours, 43 minutes ago (2009-11-20 23:05:00)
by sijpie
Re: Conditional formatting
It is not completely clear to me which cell needs to change color - the one with the X in it or the cell that looks up the X.
Let's assume it is the latter. Then for conditional formatting you need to set it to 'Formula equals'
end then
offset(W4,0)="X"
as the formula
Started 2 days, 2 hours ago (2009-11-19 20:24:00)
by mojo249
Re: Copy Information into a template
Emma
Can you post a copy of the workbook? It'll make it easier to understand what you're trying to do.
Dion
Started 6 hours, 5 minutes ago (2009-11-21 16:43:00)
by jrb
I would maybe opt for sumproduct...
Try...
Code:
=SUMPRODUCT(--(V5:V246> =K1),--(V5:V246 =225000),--(X5:X246
|
|
Hot threads for last week on MrExcel Message Board:
Started 1 week, 3 days ago (2009-11-11 02:09:00)
by PoggiPJ
Faster Way to Delete Rows?
My spreadsheet is a contract file that includes a list of part numbers being sold. Each part number refers to a lookup table of ALL about 20,000 valid part numbers and prices. Once the contract is finalized, I want to make the contract sheet smaller by deleting all rows in the lookup table that are not ...
Started 1 day, 13 hours ago (2009-11-20 09:17:00)
by chuf
slow spreadsheets... replace sumproduct or other.. advice please
Hello All.
Ive got an organisation / layout problem Im hoping you can help me with. I REALLY need to get this to work…
I have a workbook which has a summary worksheet, 12 monthly data worksheets.. and a lookuplist worksheet.
The 12 monthly ...
Started 1 day, 8 hours ago (2009-11-20 14:48:00)
by AndrewKent
Which Variable to use?
Hi there,
On my last few threads I have been asking questions about how to best declare variables. After reading through the excellent content on C Pearsons website I now have a better understanding of how to declare a variable.
What it doesn't give me however is a list of what variables to use in ...
Started 1 day, 14 hours ago (2009-11-20 08:37:00)
by PATSYS
How to make Excel recognise that the "" is blank?
Hi all,
I have a formula in A1:A10 that returns either a value or a "".
The result will be copied paaste special values in another cell, B1;B10.
Then I will copy B1 and paste specia, value and SKIP BLANKS in C1:C10
Problem is that excel pastes all the cells in C1:...
Started 1 week, 1 day ago (2009-11-13 17:03:00)
by Phox
Need a little more information in order to help. How do you want to determine the start, end, and increment? From cell values or an input box? Also please demonstrate a sample sequence of numbers, I'm not sure how exactly you intend the numbers to be sequenced.
Started 1 week ago (2009-11-14 00:44:00)
by jgthtrotih
Cindy,
Quote:
=IF(R8="","",SUM(1*(R8
Started 6 days, 14 hours ago (2009-11-15 07:54:00)
by foverman
Hi Cairo95,
I've looked at this off and on through the evening, and don't know that I've got a "clean" answer for you.
Based on what I understand of your data and process, I made this test data in column A
Sheet8 A B C D 54 13863883 59139 -11 59128 55 13863894 11 -11 0 56 13863905 11 -11 0 57 13863916 11 -15 -4 58 13863931 15 -55...
Started 5 days, 14 hours ago (2009-11-16 07:53:00)
by jayoharae
24 hour timesheet problem
I am having trouble with this formula
=IF(E4-D4 < 1/24*7.1,E4-D4,E4-D4-1/24)*24
it works well unless the staff member works past midnight. I get a negative hours worked value returned.
for eg
E4=8AM and D4 is 5PM i get an answer of 9 hours in F4, this is all good but if the start time E4...
Started 1 week ago (2009-11-14 03:00:00)
by Smitty
Try using a helper column to concatenate T3:X8605. You can then use INDEX/MATCH to get the corresponding match (if there is one).
Barring that, try posting more detail.
HTH,
Started 1 day, 22 hours ago (2009-11-20 00:26:00)
by kosmokramer
Filter data to show only employees who are TRUELY tardy
I have an excel sheet with over 4,000 rows of records regarding our 80+ employees clocking in. There are three columns:
A: Date (MM/DD/YYYY)
B: Time ( HH:MM:SS)
C: Employee Name
Our employees are expected to be at work (and clock-in) at or before 8am.
At first, I ...
|
|
Size: 2,348 bytes
