|
More site info...
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.
|
|
|
|
|
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:
|
Top authors during last week:
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
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
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
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...
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
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
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:
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?
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.
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::
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)
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 ...
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)
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?
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 ...
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 ...
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.
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
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).
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 ...
|
|
Hot threads for last week on 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 ...
Started 2 days, 2 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, 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 ...
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:...
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, 1 day ago (2009-11-14 00:44:00)
by jgthtrotih
Cindy,
Quote:
=IF(R8="","",SUM(1*(R8
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...
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...
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,
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 ...
|
|
Size: 489 bytes
