Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Excel Questions | Forum profile

Forum profile page for Excel Questions on http://www.mrexcel.com. This report page is the aggregated overview from a single forum: Excel Questions, located on the Message Board at http://www.mrexcel.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Excel Questions" on the Message Board at http://www.mrexcel.com is also shown in the following ways:

1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.

Site: MrExcel Message Board - Excel Questions (site profile, domain info mrexcel.com)
Title: Excel Questions
Url: http://www.mrexcel.com/forum/forumdisplay.php?s...
Users activity: 49 posts per thread
Forum activity: 3465 active threads during last week
 

Posting activity on Excel Questions:

  Week Month 3 Months
Threads: 3,465 10,299 26,405
Post: 15,710 49,725 128,756
 

Excel Questions Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Andrew Poulsom
523
user's latest post:
Linking Cells between sheets
Published (2009-11-13 18:46:00)
Welcome to the Board. Type =, click the tab of the target sheet, point at the target cell and press Enter.
Norie
432
user's latest post:
Searching for a word or string...
Published (2009-11-13 23:55:00)
No problem. Perhaps you could share the solution to help others.
Peter_SSs
245
user's latest post:
Two Input Lookup but get result...
Published (2009-11-13 14:59:00)
Quote: Originally Posted by gmcasolini Peter Thank you for the reply. It is working fine. I have used offset & match formulas before. But never in this format. Thank you for expert input. GMC Not using OFFSET here.
jbeaucaire
229
user's latest post:
Call a macro when cell changes...
Published (2009-11-13 21:07:00)
http://www.excelforum.com/excel-gene...ous-value.html
Aladin Akyurek
218
user's latest post:
Formula Troubles
Published (2009-11-13 21:40:00)
Perhaps... =IF(COUNT(A1:B1)=2,IF(A1> B1,1,0),0)
Blade Hunter
218
user's latest post:
Sheet names
Published (2009-11-13 08:05:00)
Both of the above with exclusions for empty cells. Code: Private Sub WorkSheet_Change(ByVal Target As Range) If Target.Column = 1 And Not (IsEmpty(Target)) Then Me.Name = Target.Value End Sub Private Sub Worksheet_Calculate() If Not IsEmpty(Range("C3")) Then Me.Name = Range("C3").Value End Sub
VoG
195
user's latest post:
a friend told me this cant be...
Published (2009-11-13 22:52:00)
Try this: right click the sheet tab, select View code and enter Code: Private Sub Worksheet_Calculate() Application.EnableEvents = False Range("F4").Value = Range("F6").Value Application.EnableEvents = True End Sub Then press ALT + Q.
lenze
180
user's latest post:
Converting number of seconds to...
Published (2009-11-13 23:58:00)
Hi and welcome to the board For hours Code: =INT(A4/3600) For minutes Code: =INT(MOD(A4/3600*60,60)) For seconds Code: =MOD(A4/3600*60*60,60) HTH lenze
wigi
173
user's latest post:
transfer & delete
Published (2009-11-13 23:54:00)
Thank you for disregarding from the help I offered: http://www.mrexcel.com/forum/showthread.php?t=429357 Much appreciated.
mikerickson
164
user's latest post:
Conditional Format Problem -...
Published (2009-11-13 21:50:00)
If it isn't too large, it wouldn't hurt have you downloaded Jeanie's HTML maker
 

Latest active threads on Excel Questions::

MrExcel Message Board
Started 5 hours, 1 minute ago (2009-11-15 10:46:00)  by Norie
Nicole I'm sorry but that makes no sense at all.
Thread:  Show this thread (2 posts)   Thread info: Convert VBA to Visual Basic .NET. Size: 158 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Convert VBA to Visual Basic .NET. :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 1 day, 10 hours ago (2009-11-14 05:25:00)  by #NAME?
Try this... In the formula: Table refers to your 5 row x 8 column table Result refers to the column of results =INDEX(Result,MATCH(1,MMULT(--(Table=A2),{1;1;1;1 ;1;1;1;1}),0)) Copy down as needed.
Thread:  Show this thread (5 posts)   Thread info: Array lookup for text field when lookup value can be in one of many columns Size: 266 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Array lookup for text field when lookup value can be in one of many
columns :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 5 hours, 35 minutes ago (2009-11-15 10:12:00)  by VoG
Try Code: Sub Concat() Dim LC As Long, LR As Long, j As Long LR = ActiveSheet.UsedRange.Find(what:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row LC = ActiveSheet.UsedRange.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column For j = 2 To LC Range(Cells(1, j), Cells(LR, j)).Cut Destination:=Range("A" & Rows.Count).End(xlUp).Offset(1) Next j ...
Thread:  Show this thread (4 posts)   Thread info: multi columns to one Size: 699 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: multi columns to one :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 5 hours, 8 minutes ago (2009-11-15 10:39:00)  by dsgsandman
http://www.mrexcel.com/forum/showthread.php?t=8935 6
Thread:  Show this thread (3 posts)   Thread info: Copy Paste from Excel in to a post Size: 135 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Copy Paste from Excel in to a post :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 4 days, 13 hours 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 ...
Thread:  Show this thread (83 posts)   Thread info: Faster Way to Delete Rows? Size: 3,577 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Faster Way to Delete Rows? :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 4 hours, 28 minutes ago (2009-11-15 11:19:00)  by wigi
Hello You forgot the ' in the formula: Code: "=Vlookup(A3,'" & CustomerSummary & "'!$A$3:$B$65536,2,0)" (after the first comma and in front of the double quote ". I also had to add a space in front of "Summary" in: Code: CustomerSummary = Left(ActiveSheet.Name, Len(ActiveSheet.Name) - 7) & "Summary" By the way, do you really need such long ranges in your lookup?...
Thread:  Show this thread (2 posts)   Thread info: VBA Vlookup Variable Sheet Reference Size: 1,011 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: VBA Vlookup Variable Sheet Reference :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 6 hours, 38 minutes ago (2009-11-15 09:09:00)  by Peter_SSs
Quote: Originally Posted by mucah!t Range C6:AJ6 will be a little bit more complicated it should place a 2 in each cell, starting from 10 cells prior the 3th last number in range C5:AJ5. That would be impossible (not enough columns) if that 3rd last number was in the range C5:J5. What should happen in ...
Thread:  Show this thread (7 posts)   Thread info: Looking at 10 cells prior one containing a number Size: 1,049 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Looking at 10 cells prior one containing a number :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 3 hours, 18 minutes ago (2009-11-15 12:29:00)  by wsjackman
look at vlookup using the part number as the lookup value
Thread:  Show this thread (2 posts)   Thread info: Excel Merge Newbie Size: 57 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Excel Merge Newbie :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 20 hours, 46 minutes ago (2009-11-14 19:01:00)  by xld
What help procedure did you try?
Thread:  Show this thread (7 posts)   Thread info: Sheet names at the bottom disappeared Size: 86 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Sheet names at the bottom disappeared :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 20 hours, 59 minutes ago (2009-11-14 18:48:00)  by Anthon
Help; I have a (work sheet) that contains two "name" cells, and I need to gather that information into one cell on the mailing list (work sheet.) How? Anthon
Thread:  Show this thread (6 posts)   Thread info: Combining two cell with information to another cell Size: 316 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Combining two cell with information to another cell :: Excel Questions :: MrExcel Message Board"
 

Hot threads for last week on Excel Questions::

Excel Questions
Started 4 days, 13 hours 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 ...
Thread:  Show this thread (83 posts)   Thread info: Faster Way to Delete Rows? Size: 3,577 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Faster Way to Delete Rows? :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 1 week, 1 day ago (2009-11-06 16:42:00)  by mikerickson
How about =AND(MOD(INT(A1)/100),100) < 35, ISEVEN(INT(A1)/100))
Thread:  Show this thread (50 posts)   Thread info: Data Validation: This could get messy... Size: 71 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Data Validation: This could get messy... :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 1 week 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
Thread:  Show this thread (46 posts)   Thread info: functions and formulas for Dummies Size: 1,411 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "functions and formulas for Dummies :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 3 days, 15 hours ago (2009-11-11 23:53:00)  by BrianB
Re: Excel called from VBS does not fully exit Your code looks ok to me. Although you do not seem to be doing it, the only other time I have seen problems is when something has been selected, when this is required before the shutdown :- Code: Application.CutCopyMode = False You can get your Sort code by ...
Thread:  Show this thread (46 posts)   Thread info: Excel called from VBS does not fully exit Size: 1,406 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Excel called from VBS does not fully exit :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 4 days, 9 hours ago (2009-11-11 06:03:00)  by uniquo
HOW TO stop #NA appearring in index and mATCH function? Hi I have this equation =(INDEX(abc!B8:D18,MATCH(Sheet1!C39,abc!A8:A18),M ATCH(Sheet1!D39,percentiles,0))) it gives me this #N/A. I'd rather have it show $0.00. Can someone help ?
Thread:  Show this thread (45 posts)   Thread info: HOW TO stop #NA appearring in index and match function? Size: 648 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "HOW TO stop #NA appearring in index and match function? :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 1 week, 2 days ago (2009-11-05 21:29:00)  by Irish_Griffin
First you need to create the DAO database ( similar to access .mdb file ) Don't forget to: - Dim your database and recordsets ( record sets are individual tables within the database ) - VBA Window -> Tools(TAB) -> References -> Checkbox "Microsoft DAO 3.6 Library" - VBA Window -> Tools(TAB) -> References -> Checkbox "Microsoft Access 11.0 Object Library" Code to place in ...
Thread:  Show this thread (62 posts)   Thread info: BEST PRACTICES -> SQL with DAO Size: 1,387 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: BEST PRACTICES -> SQL with DAO :: Excel Questions :: MrExcel Message Board"
Excel Questions
I need a pro!!!!!! - 44 new posts
Started 5 days, 21 hours ago (2009-11-09 17:59:00)  by bpgolferguy
I need a pro!!!!!! Hello, I currently have this code that allows me to print a word document on one of my drives with the click of a button in excel. I need to modify it because one of the files I want to print as well is a pdf file. Does anyone know how to modify it so I can do that? Thanks! Set appWrd = CreateObject("Word....
Thread:  Show this thread (44 posts)   Thread info: I need a pro!!!!!! Size: 919 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "I need a pro!!!!!! :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 6 days, 5 hours ago (2009-11-09 10:30:00)  by chuf
VBA - Change posting to diff worksheet.. Hi All. nice easy one for the start of the week Please would anyone be able to adjust this code to output the differences in WS3 instead of WS2. I'm having trouble changing the worksheet in the code. Ta in advance. Chuf Code: Sub CompBelowCol() Dim ...
Thread:  Show this thread (36 posts)   Thread info: VBA - Change posting to diff worksheet.. Size: 1,687 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "VBA - Change posting to diff worksheet.. :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 1 week, 5 days ago (2009-11-02 20:28:00)  by Domenic
Can you clarify Step 1?
Thread:  Show this thread (54 posts)   Thread info: Formula HELP please. Size: 23 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Formula HELP please. :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 3 days, 17 hours ago (2009-11-11 22:03:00)  by PoggiPJ
Proper Syntax to delete non-contiguous rows? I am drawing a complete blank. If in a macro I have determined and built a string list of non-contiguous rows that need to be deleted (e.g. rows 3, 5, and 7) from a range of rows named "Prices", what would be the correct syntax? For example, I know it isn't.. Code: Prices("3...
Thread:  Show this thread (36 posts)   Thread info: Proper Syntax to delete non-contiguous rows? Size: 1,294 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Proper Syntax to delete non-contiguous rows? :: Excel Questions :: MrExcel Message Board"