|
More site info...
microsoft.public.excel.newusers | Forum profile
|
|
Forum profile page for microsoft.public.excel.newusers on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.excel.newusers, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
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 "microsoft.public.excel.newusers" on the Message Board at http://www.microsoft.com/communities/newsgroups... 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 microsoft.public.excel.newusers:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
34
|
139
|
394
|
|
Post:
|
65
|
300
|
955
|
|
|
microsoft.public.excel.newusers Posting activity graph:
|
Top authors during last week:
user's latest post:
CountIF on two criteria in...
Published (2009-11-23 05:46:00)
=SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT"),C1:C100) This will sum (total) every C value whose corresponding B value is CAT and corresponding A value is not O =SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT")) This will count how many B values are CAT with corresponding A values that are not O For more details on SUMPRODUCT Bob...
user's latest post:
add info to column in...
Published (2009-11-25 14:56:00)
I would say the easiest way to copy down is to double-click the fill handle if there is data in the adjacent column...........which there is in this case. Gord Dibben MS Excel MVP On Wed, 25 Nov 2009 13:53:02 -0800, Max <demechanik@yahoo.com> wrote: >> How do i copy down? >Easiest way is to drag the cell's fill handle down, ie point the cursor at >the bottom right hand corner of the...
user's latest post:
add info to column in...
Published (2009-11-25 14:00:00)
Oops, clarification ... The cell's fill handle looks like a solid little black square When you point at it the cursor changes into a cross
user's latest post:
Mark Rows for scrolling in...
Published (2009-11-21 17:06:00)
This seems weird! I mark row 4 and row 1 and click on Freeze Panes. Rows 1-3 become frozen. There's also a black line below Row 6 that acts like another Freeze (Rows 4-6!) Does anybody have an answer to this? Thanks, Doug .
user's latest post:
Macros for template in...
Published (2009-11-21 10:35:00)
I have a Template for the 52 Weeks that i created if i want to change something in Template is it possible to have the 52 other sheets change as well through Macro,s if possible How
user's latest post:
Mark Rows for scrolling in...
Published (2009-11-21 18:16:00)
I'm not sure what mark means here, but freeze panes will freeze rows above the activecell and to the left of the activecell. So if you meant that you selected rows 1:4, then it would only matter what cell was the activecell. If that activecell is in row 4, then rows 1:3 would be frozen. (You can select a multicell range and tab through that selection to experiment.) And you may be seeing Window|Split. You only get one...
user's latest post:
CountIF on two criteria in...
Published (2009-11-23 04:31:00)
quite a few items listed to count the cells that are NOT Equal to o =COUNTIF(C9:C28,"<>"&"o") > "1-2" > "3-4", and "5+". They are not numeric as far as the computer is > concerned. > I'm not sure how you are going to sum these values .. other than replacing them with numbers so something...
user's latest post:
data from many work books in...
Published (2009-11-23 05:10:00)
This can be done with VBA code (a macro). You haven't given enough information to provide a more detailed answer, but there is one command available that does allow you to browse and identify files to be worked with that will probably end up in the code: Application.GetOpenFilename will return a filename from a dialog box, and then the code can open that file and perform operations to copy information from that file into...
user's latest post:
add info to column in...
Published (2009-11-25 13:40:00)
How do i copy down? "John" wrote: > HI > Lets assume your list is starting at A1, just type in B1 =A1&"@gmail.com" > and copy down to A1000. > HTH > John > "jj348206" <jj348206@discussions.microsoft.com> wrote in message > news:E7E6911F-BE61-422D-BBA7-BCFB83A66656@microsoft.com... > >I have a...
|
|
|
|
Latest active threads on microsoft.public.excel.newusers::
Started 1 day, 6 hours ago (2009-11-29 00:46:00)
by Simon Lloyd
You need to add a macro buttons and assign these macros:
Code:
--------------------
Sub Shift_Right()
ActiveWindow.LargeScroll ToRight:=1
End Sub
Sub Shift_Left()
ActiveWindow.LargeScroll ToRight:=-1
End Sub
--------------------
bflorea;571482 Wrote:
> i am wondering how i can set this up so i can page left or right a set
> number
> ...
Started 1 day, 22 hours ago (2009-11-28 08:34:00)
by FloMM2
Ken,
If your formula is as follows:
"=A1-B1"
You would need to edit as follows:
"=IF((A1-B1)>0,(A1-B1),0)"
What this tells excel is, if A1-B1 is greater than 0 (True), then give me
that result. If A1-B1 is greater than 0 (False), then give me a 0.
hth
"Ken" wrote:
> If a formula gives me a ...
Started 2 days, 2 hours ago (2009-11-28 04:16:00)
by Andy Pope
Hi,
Check the Review tab, the worksheet may be protected.
Check you do not have multiple sheets selected, [Group] will be
displayed in the title bar is you have.
Cheers
Andy
Akcath wrote:
> I'm trying to do a " what-if analysis" for my beginning Excel class and when I
> click on the appropriate ...
Started 2 days, 16 hours ago (2009-11-27 14:16:00)
by T. Valko
See if this does what you want...
...........A..........B
1.......10...........
2......................
3........5............
4.......10.........X
5.......15.........Y
6....................Z
A1 = lookup value
=INDEX(B4:B6,MATCH(A1,A3:A5,0))
Result = Y
Started 3 days ago (2009-11-27 06:23:00)
by trip_to_tokyo
In EXCEL 2007 try this:-
Home group / Fornt - single left hand clik on the arrow in the lower right
hand corner / Format Cells should launch / Fill tab / Fill Effects . . . /
make your choice and hit OK / OK once more.
You should now have what you want.
Please hit Yes if my comments have helped.
Thanks...
Started 3 days, 7 hours ago (2009-11-26 23:31:00)
by Ed Ferrero
Hi Rohit,
> eg in cell A1, if i enter 1000,000 then the outcome should be 1,000.
Use a custom number format.
More number formats, then select Custom, then enter
#,##0,
including the trailing comma.
Ed Ferrero
www.edferrero.com
.
Started 4 days, 12 hours ago (2009-11-25 18:44:00)
by FSt1
hi
what have you tried so far???
seem like a simple add 45 days to previous date should do it.
with the data in c2, in e2, enter
=C2+45
regards
FSt1
"Nelson" wrote:
> I am trying to put together a simple three column spreadsheet. Column A is a
> tape number, column C is the date that the ...
|
|
Hot threads for last week on microsoft.public.excel.newusers::
Started 4 days, 17 hours ago (2009-11-25 13:26:00)
by John
HI
Lets assume your list is starting at A1, just type in B1 =A1&"@gmail.com"
and copy down to A1000.
HTH
John
"jj348206" <jj348206@discussions.microsoft.com> wrote in message
news:E7E6911F-BE61-422D-BBA7-BCFB83A66656@micros oft.com...
>I have a list of over 1000 names in my a column but need to add @gmail.com to
> the ...
Started 1 week, 1 day ago (2009-11-21 11:46:00)
by Bernie Deitrick
Mike,
Sorry, that just isn't clear. Perhaps a formula
=SUM(A1: A37)/A1
where A1 to A37 have your number 997?
Bernie
"Mike" <Mike@discussions.microsoft.com> wrote in message
news:FCCAEB85-AF11-4227-9A2F-E194408F5C2F@micros oft.com...
>I am trying to sum up 37 cells to = 1 each for each cell ...
Started 1 day, 22 hours ago (2009-11-28 08:34:00)
by FloMM2
Ken,
If your formula is as follows:
"=A1-B1"
You would need to edit as follows:
"=IF((A1-B1)>0,(A1-B1),0)"
What this tells excel is, if A1-B1 is greater than 0 (True), then give me
that result. If A1-B1 is greater than 0 (False), then give me a 0.
hth
"Ken" wrote:
> If a formula gives me a ...
Started 1 week, 1 day ago (2009-11-21 12:11:00)
by Gord Dibben
Best to stick with your original posting Mike.
See my reply there.
Gord
On Sat, 21 Nov 2009 10:36:01 -0800, Mike <Mike@discussions.microsoft.com>
wrote:
> I have a Template for the 52 Weeks that i created if i want to change
>something in Template is it possible to have the 52 other sheets change as...
Started 1 week, 1 day ago (2009-11-21 12:21:00)
by Gord Dibben
I see nothing specific at the Office Template Gallery but a 'net search for
"coupon database excel" turned up a few.
Download a sample workbook from here.
http://projects.newsobserver.com/tags/coupon_updat e
Gord Dibben MS Excel MVP
On Sat, 21 Nov 2009 11:26:01 -0800, katinsunlakes
<...
Started 1 week, 1 day ago (2009-11-21 18:16:00)
by Dave Peterson
I'm not sure what mark means here, but freeze panes will freeze rows above the
activecell and to the left of the activecell.
So if you meant that you selected rows 1:4, then it would only matter what cell
was the activecell. If that activecell is in row 4, then rows 1:3 would be
frozen.
(You can select a multicell range ...
Started 1 week, 1 day ago (2009-11-21 20:41:00)
by T. Valko
If this data is imported from another application is the date/time stamp a
true Excel date/time?
If C2 is a date/time stamp what is the result of this formula:
=ISNUMBER(C2)
Can you post a small example of your data with the expected result? Don't
really need the Device/SubDevice data. Just the date/time and the X/Y...
Started 1 week ago (2009-11-23 04:11:00)
by etaf
can you be more specific ....
However, assuming that you want to put the Value 1 to 5 in a cell where
another cell is grouped as percentages
try (I have assumed the cell is formated as %, hence decimal values)
=IF(D9=1,5,IF(D9>=0.75,4,IF(D9>=0.5,3,IF(D9>=0.2 5,2,1))))
--
etaf
...
Started 1 week ago (2009-11-23 05:46:00)
by Bernard Liengme
=SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT"),C1: C100)
This will sum (total) every C value whose corresponding B value is CAT and
corresponding A value is not O
=SUMPRODUCT(--(a1:a100<>"O"),--(B1:b100="CAT"))
This will count how many B values are CAT with corresponding A values that
are not O
For more details ...
Started 1 week ago (2009-11-23 05:10:00)
by JLatham
This can be done with VBA code (a macro). You haven't given enough
information to provide a more detailed answer, but there is one command
available that does allow you to browse and identify files to be worked with
that will probably end up in the code:
Application.GetOpenFilename
will return a filename from a dialog box, and then...
|
|