|
More site info...
Excel 2007 Help | Forum profile
|
|
Forum profile page for Excel 2007 Help on http://www.excelforum.com.
This report page is the aggregated overview from a single forum: Excel 2007 Help, 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 2007 Help" 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 2007 Help:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
102
|
312
|
694
|
|
Post:
|
297
|
1,038
|
2,098
|
|
|
Excel 2007 Help Posting activity graph:
|
Top authors during last week:
user's latest post:
Hypgeodist-entering values
Published (2009-12-21 09:27:00)
Quote: (HYPGEOMDIST(sample_s,number_sample,population_s,number_population) Sample_s is the number of successes in the sample. Which value from the table? Number_sample is the size of the sample. Which value from the table? Population_s is the number of successes in the population. Which value from the table? Number_population is the population size. Which value from the table? As I said before, I don't think you have all the numbers you...
user's latest post:
Compatability Mode in Excel 2007
Published (2009-12-15 22:17:00)
Thanks for your help. How can I get someone else to have a look - can you recommend someone?
user's latest post:
VLookup with Multiple Results
Published (2009-12-18 13:15:00)
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. If needed supply a before and after sheet in the workbook so the person helping you can see what...
user's latest post:
Help Creating a Loop
Published (2009-12-19 16:35:00)
Simple lookups like this don't really need macros. Just change the B1:P1 values to 1,2,3 etc...put 1,2,3,4 etc...down the A column starting at A2 all the way to 30. Then put this formula in B2 and copy it to the whole chart: =IF(ISNUMBER(MATCH($A2 & "-" & B$1, Input!$A:$A, 0)), INDEX(Input!$B:$B, MATCH($A2 & "-" & B$1, Input!$A:$A, 0)), "")
user's latest post:
Desperate
Published (2009-12-18 19:04:00)
Welcome to the forum. Please take a minute to read the rules and then update your title in accordance with rule 1. Thanks.
user's latest post:
Sum cells after searching for...
Published (2009-12-20 13:09:00)
Thanks Dave, that works great. Sorry if I wasn't very clear explaining. This stuff is so over my head, I don't always know how to describe what I'm trying to accomplish. Much appreciated E.
user's latest post:
subtracting time
Published (2009-12-18 03:51:00)
Scott, presumably duration of shift dictates break type - can you outline the "logic" ? In essence in XL time is simply a decimal value (ie 24hrs = 1, 12 hours = 0.5 etc) and as such you can add/subtract time as you would any other number, eg in basic terms: Code: E5: =MAX(0,D5-"00:30") copied down P.S. What's the weather like up there ? I'm meant to be driving up to Yorks today but with the snow...
user's latest post:
Protected Sheet using Domain...
Published (2009-12-19 00:32:00)
c'mon ..someone shd. have a clue? anyone? at least, tell me it is not possible? or don't think so...etc. i even did my best to follow 'Forum rule 1'
user's latest post:
if argument
Published (2009-12-19 15:58:00)
Ahhh ! That old method. Seriously, you people are geniuses, or genii, or something very similar. Thank you very much indeed for your assistance Scott
user's latest post:
Sum cells after searching for...
Published (2009-12-20 13:23:00)
Have a great day. If you are satisfied with the solution(s) provided, please mark your thread as Solved. How to mark a thread Solved Go to the first post Click edit Click Go Advanced Just below the word Title you will see a dropdown with the word No prefix. Change to Solved Click Save
|
|
|
|
Latest active threads on Excel 2007 Help::
Started 1 day, 21 hours ago (2009-12-21 14:09:00)
by greywolfst1
Try this link. Unfortunately it is not straight forward.
http://excel.tips.net/Pages/T003892_...n_Sorting.h tml
Started 1 day, 23 hours ago (2009-12-21 11:44:00)
by solnajeff
Hi
I have added a formula to your sheet, please have a look to see if it fulfills your requirements.
Regards
Jeff
Started 1 week, 1 day ago (2009-12-15 00:54:00)
by shg
Started 2 days, 2 hours ago (2009-12-21 09:04:00)
by arthurbr
Hi,,
you can replace your average formula with
=average(if(you_range<>0,your_range,false)) and enter as an array formula with Ctrl+Shift+Enter
As for the second part, is is based on values in col T which do not seem coherent
the COUNTIF part has ranges like $q1:$q4 but the range in the following cell is like $q1:q$5.
Could you correct these and see if it's OK ?
Started 2 days, 3 hours ago (2009-12-21 08:27:00)
by arthurbr
Your post does not comply with Rule 1 of our Forum RULES . Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less ...
Started 5 days, 21 hours ago (2009-12-17 13:38:00)
by JBeaucaire
In Excel 2007, .xlsx means "macro free".
To save with macros, change the file type to *.xls m .
Started 2 days, 15 hours ago (2009-12-20 20:08:00)
by ConneXionLost
Hi Richard,
Welcome to the forum!
Have a look at the INDIRECT and ADDRESS functions. They should satisfy your requirement.
Cheers,
Started 3 days, 22 hours ago (2009-12-19 13:11:00)
by Huron
Are you trying to look up the ID or the number? On your worksheet the ID that you're searching for is shown in the number column on the next sheet.
|
|
Hot threads for last week on Excel 2007 Help::
Started 1 week ago (2009-12-15 21:26:00)
by teylyn
Try to Save As with a different file name and set it to XLSX file type.
Started 1 week ago (2009-12-15 16:11:00)
by NBVC
What formula got you the red/green conditions?
Started 1 week ago (2009-12-16 00:09:00)
by JBeaucaire
Put this formula in D3 and copy down:
= (B3>C3) +C3-B3
The red part added is basically a TRUE/FALSE statement, and anytime the answer is true, 1 gets added to the result making the math correct.
Started 1 week, 1 day ago (2009-12-15 00:54:00)
by shg
Started 1 week, 1 day ago (2009-12-14 15:43:00)
by NBVC
Something like:
=if(rows($A$1:$A1)>$X$1,"",Index($E$1:$E$100,smal l(if($A$1:$A$100=Today(),Row($A$1:$A1)-Row($A1)),R ows($A$1:$A1))
where X1 contains your Countif formula
E1:E100 is the column to extract data from and A1: A100 is the column containing dates to find Today() in...
Formula must be confirmed with CTRL+SHIFT+EnteR and not just ENTER... then copied down.
Started 6 days, 15 hours ago (2009-12-16 19:28:00)
by JBeaucaire
I don't know of a native function for that, perhaps someone else will. Here is a User Designed Function (UDF) that can accomplish it for you.
Code:
Option Explicit
Function ADDRESSIF(RNG As Range, VAL As String) As String
'JBeaucaire (12/16/2009)
'List cells containing VAL from RNG
Dim cell As Range, buf As String
For Each cell In RNG
If cell.Value = VAL Then
If buf = ...
Started 3 days, 20 hours ago (2009-12-19 14:41:00)
by shg
How about posting some example results?
What is Windpanel? What is Meter? What's in col A? In col B?
Cater to the fact that we have no idea what you're trying to do.
Started 5 days, 7 hours ago (2009-12-18 03:51:00)
by teylyn
Started 1 week, 1 day ago (2009-12-14 22:18:00)
by davesexcel
Do you know what a column is?
Started 1 week, 2 days ago (2009-12-14 10:26:00)
by martindwilson
no idea.if we cant see it we cant fix it! post an example
|
|
Size: 306 bytes
