|
More site info...
Excel General | Forum profile
|
|
Forum profile page for Excel General on http://www.excelforum.com.
This report page is the aggregated overview from a single forum: Excel General, located on the Message Board at http://www.excelforum.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 General" on the Message Board at http://www.excelforum.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 General:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
733
|
2,267
|
5,888
|
|
Post:
|
2,761
|
8,275
|
22,219
|
|
|
Excel General Posting activity graph:
|
Top authors during last week:
user's latest post:
Computing with last 252 rows of...
Published (2009-11-26 15:30:00)
Re: use of 9.99999999999999E+307 - see XL Help re: calculation specifications & limits (the number used is in essence the biggest number allowed in XL ... the use of E+307 is Scientific notation) Regards obtaining final number in a column / Average: Code: =LOOKUP(9.99999999999999E+307,E:E)/AVERAGE(....) For more info. re: last values see: http://www.xldynamic.com/source/xld.LastValue.html
user's latest post:
IF? Function to choose a list to...
Published (2009-11-26 23:31:00)
Gimme a bit. I need to get my motorbike home before the rain clouds open. I'll have a look tonite from home, where I also have 2007. cheers
user's latest post:
changing cells in a column to...
Published (2009-11-26 17:12:00)
Assuming your original range is in Sheet1!J31:J58 then =INDEX(Sheet1!$J$31:$J$58,COLUMNS($A$1:A$1)) copied across
user's latest post:
Calculating between two times
Published (2009-11-25 21:32:00)
DLL is the formula meister for dates and times, and most things else. I commend his sans testing.
user's latest post:
Non-maximized window problem
Published (2009-11-26 19:18:00)
or try window /arrange and select a different option tiled/horizontal or what ever ,making sure workbook is not protected first.
user's latest post:
timecard
Published (2009-11-26 16:23:00)
Teylyn's approach is efficient in that it requires no helper columns. Bear in mind if you use it, though, that the underlying value of D8 will still be 8.15. You'll have to subtract E8 for any math you want to do on it or otherwise round down to the nearest hour.
user's latest post:
Use Drop menu to control data
Published (2009-11-26 18:05:00)
You can use the worksheet_change event to write the values to the Audit Trail sheet as they are entered. Here is the beginning of the code and it should be enough to get you going in developing the rest of it. This code is in the sheet module of the "Operations Manager"worksheet. Code: Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet, iCol As Integer Set ws = Sheet3 With Me If Not Intersect(Target,...
user's latest post:
Time Picker
Published (2009-11-25 20:23:00)
Hi, How about a couple of drop down boxes with the numbers 1-24 in 1 and 1-60 in the other, then use the selections to create a decimal time number. HTH
user's latest post:
Combining two unrelated...
Published (2009-11-25 17:11:00)
Hehe...yeah, it takes a village! If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED] . (Also, use the blue "scales" icon in our posts to leave Reputation Feedback , it is appreciated)
|
|
|
|
Latest active threads on Excel General::
Started 1 day ago (2009-11-27 15:13:00)
by shg
Set the min and max values to 0 and 100, and then compute the offset in a separate cell: =A1-50
Started 1 day, 2 hours ago (2009-11-27 13:37:00)
by DonkeyOte
Welcome to the Board... you can upload the file here directly - people are generally disinclined to download from other sites.
Regards your question... ape the Conditional Formatting logic in your summation formulae.
Started 1 day, 3 hours ago (2009-11-27 12:57:00)
by Richard Buttrey
Hi,
Yes of course it's possible to copy a workbook.
If behind your question is the desire to keep the second sheet hidden even when it is copied or used by someone else, then in the Visual Basic Environment (VBE), set the Visible property of the sheet to be xlVeryHidden. This will prevent it being unhidden from Excel itself. To prevent someone going into the VBE and unhiding it, ...
Started 1 year ago (2008-11-06 13:03:00)
by Andy Pope
Correct you can not turn off the warning is using outlook.
Perhaps this method would work for you
http://www.rondebruin.nl/cdo.htm
Started 1 day, 6 hours ago (2009-11-27 09:32:00)
by JeanRage
Hi,
Ideally a sample worksheet would allow forum participants to write the exact formula needed for your problem ...
HTH
Started 1 day, 3 hours ago (2009-11-27 12:30:00)
by SamuelT
Hi there,
You can use the ISTEXT (the cell contains a text value) or ISNUMBER (the cell contains a numeric value) functions. This returns a boolean TRUE or FALSE. So, if your data is in column A, just do =ISTEXT(A1) (or =ISNUMBER(A1) dependent on which you prefer then drag down.
If you want something more than TRUE and FALSE - e.g. "Yes","No" - then do: =IF(ISTEXT(A1),"Yes","No").
HTH,...
Started 1 day, 3 hours ago (2009-11-27 12:33:00)
by DonkeyOte
Brenda,
Your post does not comply with Rule 3 of our Forum RULES . Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Please edit your prior post in accordance with above.
Started 1 day, 3 hours ago (2009-11-27 12:08:00)
by Ron Coderre
Please change your thread title to something more appropriate.
"Quick Question!!!" does not indicate anything about your Excel issue.
Started 1 day, 4 hours ago (2009-11-27 11:42:00)
by DonkeyOte
Quote:
If A1 is earlier than 1/12/2009 then return number in D1 otherwise leave blank
in which case reverse the logic:
=IF(A1<0+"01/12/2009",D1,"")
Note syntax re: date ... you could replace 0+"01/12/2009" with DATE(2009,12,1) if you prefer.
Started 1 day, 5 hours ago (2009-11-27 10:45:00)
by teylyn
Hi
In the second, dependent sheet, you would need at least one field per client as an absolute value, say, client ID or name. Then fill the required columns with VLOOKUP based on data from the first sheet
=VLOOKUP( name,Sheet1!A1:D1000,4,False) or similar
If you then sort Sheet1, Sheet2 should be unaffected.
if this does not help, post a small data sample so we can have a look.
|
|
Hot threads for last week on Excel General::
Started 3 days, 13 hours ago (2009-11-25 02:04:00)
by excelmaster5000 Registered User
Hello,
I posted this earlier, but was unable to get my answer I needed. Attached is a spreadsheet that I need to turn in to my work. The red cells need formulas to calculate numbers in those boxes.
Here is what I need for the red cells.
In the Processed section, anytime a loan officer is selected in cells B:13 - B74 B4-B9 reflects the proper # of loans ...
Started 3 days ago (2009-11-25 15:17:00)
by Sibrulotte Registered User
My vlookup fonction fell in a black hole after the november 23rd 2009.
What would you reckon?
Started 1 week, 1 day ago (2009-11-20 07:47:00)
by zoolander_10 Registered User
Please Register to Remove these Ads
Just wondering if I can lock a worksheet to display the content within the window only. Eg 22 Rows by 6 Columns? Therefore stopping people tampering or moving objects?
Thanks
Started 1 week, 1 day ago (2009-11-20 05:17:00)
by Julie Parker Banned User!
Please Register to Remove these Ads
Hi,
sorry if I put this in the wrong part of the forum but wondered if anyone could help me.
I have a large quite complicated spreadsheet which works fine when there are numbers in the relevant cells. However the blank sheet (which is going to be given blank and filled in weekly) creates the #DIV/0! in empty total boxes ...
Started 5 days, 5 hours ago (2009-11-23 10:06:00)
by NBVC
If you used named ranges in the reference sheet, then you can use conditional Formatting over the 2 sheets.
Started 4 days, 15 hours ago (2009-11-24 00:31:00)
by JBeaucaire
Can you mockup a sample sheet with about 10 rows of sample data, then show a manual representation of your goal, the desired results, based on that sample data?
Click GO ADVANCED and use the paperclip icon to post up your workbook.
Started 6 days, 9 hours ago (2009-11-22 06:54:00)
by chen2401 Registered User
Please Register to Remove these Ads
Hi guys,
im on excel 07 and my columns are pretty simple, like below,
model-------color-------price
a-----------blue-------- 7
b-----------red---------8
c-----------green-------9
what i nd to know is what is the formula for: if column price = 7, autopopulate model with "a" for that particular row.
also,...
Started 4 days, 11 hours ago (2009-11-24 04:43:00)
by lbuch79 Registered User
Please Register to Remove these Ads
Sorry if the answer is here somewhere i can't seem to find it..
Ok i have a list of unique values in column J.
I would like to check column B and if any of these values match values in column J hightlight the cell on the same row as the match on column E green. I don't know much about excel but this would be a tremendous ...
Started 1 week, 1 day ago (2009-11-20 10:40:00)
by PVR Registered User
Please Register to Remove these Ads
Hi,
Can anyone help me how to assign conditional formula in excel 2007. Its like i've variables viz., 1.2, 1.5, 0.7, 0.9, 1.1 & 0.8 in column A (A1-A6) and in column B (B1-B6) i should get the same values if it is <1 and if it is 1 or >1 it should come as 1. Finally the values will be 1.0, 1.0, 0.7, 0.9, 1.0 & 0.8.
Started 1 week, 1 day ago (2009-11-19 19:15:00)
by shg
Welcome to the forum.
Please take a few minutes to read the forum rules, and then amend your thread title accordingly.
Thanks.
|
|
Size: 176 bytes
