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: 3381 active thread during last week
 

Posting activity on Excel Questions:

  Week Month 3 Months
Threads: 3,381 10,354 26,778
Post: 16,392 50,063 132,260
 

Excel Questions Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Andrew Poulsom
484
user's latest post:
How to keep cells together when...
Published (2009-11-20 19:12:00)
You can use COUNTIF to return the position: http://www.sulprobil.com/html/sorting.html
Peter_SSs
320
user's latest post:
Find last cell in the Range and...
Published (2009-11-20 23:48:00)
Re: Find last cell in the Range and sum it via vba From what I can make of your sheet, Excel's built-in Subtotal feature should do what you want. Have you tried that? __________________ Hope this helps, good luck. Peter
VoG
302
user's latest post:
Rows and Columns
Published (2009-11-20 22:26:00)
Re: Rows and Columns Tools > Options > Somewhere, untick R1C1 __________________ HTH, Peter
jonmo1
251
user's latest post:
How to use Conditional...
Published (2009-11-20 23:52:00)
Re: How to use Conditional Formatting. Red, Yellow and Green Cells Quote: Originally Posted by lenze Jonmo's formulas work perfectly. You don't even need the helper column "B" lenze Yeah, I guess that was a little confusing. I only suggested the formula in column B as an example of how PercentRank worked. That was not meant as part of the conditional formatting solution.. __________________ The more we learn, and the...
Norie
249
user's latest post:
Number of days question
Published (2009-11-20 20:09:00)
If the date is in A1 try this. =DATE(YEAR(A1),MONTH(A1)+1,0)-A1
lenze
246
user's latest post:
How to use Conditional...
Published (2009-11-20 23:49:00)
Re: How to use Conditional Formatting. Red, Yellow and Green Cells Jonmo's formulas work perfectly. You don't even need the helper column "B" 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
wigi
224
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.
Aladin Akyurek
216
user's latest post:
Help in extracting text from a...
Published (2009-11-20 23:27:00)
Re: Help in extracting text from a string Quote: Originally Posted by djsing Thanks! It's not quite working for me though. Is the function looking in A2 for the text to search and then is keyword list in cells A9: A11? Yes... Quote: It's giving me results, just not the ones that you posted on your reply. Did you try the example set I posted?
Blade Hunter
164
user's latest post:
Eliminating spaces in formula...
Published (2009-11-20 07:10:00)
Quote: Originally Posted by cpansewicz Yes. I can see how impossible it would become. Thanks again for your help! No worries, happy to help.
mikerickson
163
user's latest post:
How to change OptionButton...
Published (2009-11-20 21:40:00)
Use code to get the number from ThisWorbook.Colors and copy that number into the Properties window.
 

Latest active threads on Excel Questions::

MrExcel Message Board
Started 2 days, 16 hours ago (2009-11-19 19:22:00)  by doofusboy
Code: =IF( AND( List!S2> List!Y$15 ,List!S2 is less than YourOtherValueHere)
Thread:  Show this thread (9 posts)   Thread info: if between values Size: 489 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: if between values :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 1 day, 6 hours ago (2009-11-21 05:00:00)  by fatnhappy
Greetings Board..... I am still learning VBA, so any help will be appreciated. Since I can't get the HTML maker I DL'd a year ago to work, I will try to explain what my data looks like. Row 1 is a "header" row. I have a workbook that has Site codes in column A and a City Name in Column B. The next columns have a combination of blank cells and numbers. I would like to write a macro ...
Thread:  Show this thread (3 posts)   Thread info: Macro to extract data into new form Size: 1,367 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Macro to extract data into new form :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 14 hours, 32 minutes ago (2009-11-21 21:27:00)  by Aladin Akyurek
Sheet1 Code: =SUMPRODUCT( --(Sheet2!$A$2:$A$400=A2), --(Sheet2!$B$2:$B$400=B2), Sheet2!$C$2:$C$400)
Thread:  Show this thread (2 posts)   Thread info: sumif / sumproduct ??? Size: 472 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: sumif / sumproduct ??? :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 14 hours, 58 minutes ago (2009-11-21 21:01:00)  by HimThruMe
There are five buttons in this particular page that all have macros attached to them to run if clicked on... could this cause it to lag? This is the only real difference from this page to the others... anyone else ever have this problem?
Thread:  Show this thread (5 posts)   Thread info: one worksheet page really lagging.... Size: 238 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: one worksheet page really lagging.... :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 1 day, 19 hours ago (2009-11-20 16:32:00)  by sabraham
Hyperlink to the CD drive I use the Hyperlink to open PDF files that are on the CD drive from my spreadsheet. I am on Windows XP and the CD drive is the D drive. In Vista the CD drive is the E drive. When I take the spreadsheet to a Vista machine the link fails as there is no D drive. Is there any to code the path of the ...
Thread:  Show this thread (9 posts)   Thread info: Hyperlink to the CD drive Size: 809 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Hyperlink to the CD drive :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 1 day, 11 hours ago (2009-11-21 00:27:00)  by Jobowo
Re: SumXmY2 in VBA Hmm. Your strategy would be to create output results on a second sheet (Sheet2), with data on Sheet1. Set it up on a matrix of n x n where n is the number of columns. You now need to complete only the left hand of the diagonal area. I'll quick code this, skipping variable definitions assuming that you have ...
Thread:  Show this thread (16 posts)   Thread info: SumXmY2 in VBA Size: 1,416 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SumXmY2 in VBA :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 2 days, 12 hours ago (2009-11-19 23:58:00)  by Blade Hunter
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.
Thread:  Show this thread (31 post)   Thread info: VLOOKUP to return image based on if statement Size: 380 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: VLOOKUP to return image based on if statement :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 1 day, 8 hours ago (2009-11-21 03:23:00)  by mpfx
Sorry have never bumped a post before but I am still stuck with this. Any help would be invaluable..........Thanks
Thread:  Show this thread (14 posts)   Thread info: Help finding active cell after blank Size: 122 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Help finding active cell after blank :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 14 hours, 54 minutes ago (2009-11-21 21:05:00)  by PCRIDE
Or the results could open in another excel work book but I would want to have it open a template so the formatting would be report like (i.e no headers, formula bar).
Thread:  Show this thread (2 posts)   Thread info: Reporting with Excel (HTML export) Size: 219 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Reporting with Excel (HTML export) :: Excel Questions :: MrExcel Message Board"
MrExcel Message Board
Started 17 hours, 27 minutes ago (2009-11-21 18:32:00)  by Vixus
Let me explain some more... I would like to run some sort of macro trigered by button after primary program finishes his calculations. So that macro checks column A and look for values "0" and when it finds it then it shud check in corresponding cell in B column to see if there is allready a date. If there is some date then just skip and proceed further and if there is no date ...
Thread:  Show this thread (10 posts)   Thread info: Help with cell value timestamp Size: 668 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Help with cell value timestamp :: Excel Questions :: MrExcel Message Board"
 

Hot threads for last week on Excel Questions::

Excel Questions
Started 1 week, 4 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 ...
Thread:  Show this thread (113 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 2 days, 2 hours ago (2009-11-20 09:17:00)  by chuf
slow spreadsheets... replace sumproduct or other.. advice please Hello All. I’ve got an organisation / layout problem I’m 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 ...
Thread:  Show this thread (48 posts)   Thread info: slow spreadsheets... replace sumproduct or other.. advice please Size: 4,085 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "slow spreadsheets... replace sumproduct or other.. advice please :: Excel Questions :: MrExcel Message Board"
Excel Questions
Which Variable to use? - 46 new posts
Started 1 day, 21 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 ...
Thread:  Show this thread (46 posts)   Thread info: Which Variable to use? Size: 982 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Which Variable to use? :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 2 days, 3 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:...
Thread:  Show this thread (46 posts)   Thread info: How to make Excel recognise that the "" is blank? Size: 1,073 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "How to make Excel recognise that the "" is blank? :: Excel Questions :: MrExcel Message Board"
Excel Questions
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.
Thread:  Show this thread (44 posts)   Thread info: Macro to number rows Size: 261 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Macro to number rows :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 1 week, 1 day ago (2009-11-14 00:44:00)  by jgthtrotih
Cindy, Quote: =IF(R8="","",SUM(1*(R8
Thread:  Show this thread (41 post)   Thread info: Another If And Or Statement Size: 1,693 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Another If And Or Statement :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 1 week 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...
Thread:  Show this thread (40 posts)   Thread info: sequential check digit validation Size: 8,718 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: sequential check digit validation :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 6 days, 4 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...
Thread:  Show this thread (39 posts)   Thread info: 24 hour timesheet problem Size: 923 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "24 hour timesheet problem :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 1 week, 1 day 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,
Thread:  Show this thread (38 posts)   Thread info: If 1 Row x 5 columns matches with another 1R x 5C Size: 299 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: If 1 Row x 5 columns matches with another 1R x 5C :: Excel Questions :: MrExcel Message Board"
Excel Questions
Started 2 days, 11 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 ...
Thread:  Show this thread (38 posts)   Thread info: Filter data to show only employees who are TRUELY tardy Size: 1,844 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Filter data to show only employees who are TRUELY tardy :: Excel Questions :: MrExcel Message Board"