Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do i repeat dates monthly over the year20 Nov 2006 18:23 GMT2
1 Feb Youth Leaders Meeting
9 Feb Specific Meeting
TBA Serving & Leading Seminar
23 Feb Social or Youth Activity
Working with data from two worksheets20 Nov 2006 17:42 GMT1
Can some one help me, please?
I am working with two worksheets - one a Summary Page which is a Pivot Table
and the other the data page which contains the information for the pivot
table.
count articles of a column that the result is between an intervall20 Nov 2006 16:03 GMT3
I need to count the diferent articles of a column where the result its
between an interval (the criteria is defined in two cells).
in my datasheet its possible that the same article has different results.
example:
When in filter mode status bar doesn't show range of cells filted20 Nov 2006 15:18 GMT1
I am working with a large excel sheet of data but when I wish to know the
range of data within this for instance when I filter out specific data, it
doesn't show me on the status bar how many cells have been selected, it
simply states FILTER MODE.   I need the status bar to tell ...
How to display >123 by ">" + if(true,1+1,2+2)?20 Nov 2006 14:18 GMT2
Does anyone know how to code following into >123
by ">" + if(true,1+1,2+2)? which display a string plus an integer into a cell.
Thank you for any suggestion
Eric
Code to Unhide Rows using Macro20 Nov 2006 14:08 GMT6
I’m using Excel 2003, what I intended to accomplish to create a macro to
unhide row (By default few rows will be hidden) based on the drop down list
value of a Cell.
Say I have created a dropdown list in F2 cell using Data>Validation>List
formulas will not compute20 Nov 2006 14:02 GMT1
I have a worksheet with some simple formulas, 1 for aging and another to
compute a cell * a fixed number.  one is today()-H1, the other is G4*78.  The
formula works fine for existing data that is in the spreadsheet.  Now for
some reason, when i open the spreadsheet and enter in a ...
Wildcard in Excel20 Nov 2006 13:27 GMT4
hi, I am trying to search for 10070162*** as a whole string text, the
asterisks do not represent wildcard characters.  When I use 10070162*** as
the lookup value in vlookup, it brought back results for 10070162001,
10070162002 etc.  Is there a way to disable Excel from treating ...
Is there a way to prevent pasting data into an Excel worksheet?20 Nov 2006 13:01 GMT16
I work in a correctional centre.   Some of the correctional officers have
little training to use Excel or other programs, but are required to complete
spreadsheets on line.   Although we have heavily protected the worksheets and
locked cells, we find that in some cases the staff ...
Flashing cell20 Nov 2006 12:47 GMT1
If Cell a1 > 50 Then Cell a1 must flasher a different colour
How do I combine text and a calculation in the same field?20 Nov 2006 11:37 GMT5
I am trying to do a calculation and have text follow that in the same field.  
An example might be as follows :  =(H30/4) per week
I want the calculation to be there, be a space and then the words "per week"
in the same field.  I do not have room for another column just for those ...
Sorting a Column and taking row information with it.20 Nov 2006 10:54 GMT2
Please help.
In Column "A",   I have number 4567 with information pertaining to 4567 in
row A5.
When I try to sort Column "A" by numbers the information does not move with
Text=Number20 Nov 2006 10:17 GMT6
I have an Time and Material Calculator that I have made.  I would
like to be able to asign a number to a letter.  Example if I enter "C" into a
column I would like it to represent .001.  If I enter "M" into the same
column I would like it to represent .0001, and if I enter "E" it ...
how do i insert rows in a cell20 Nov 2006 10:15 GMT1
I have a s/sheet which has a large cell and i need 5 rows within this
cell..but not the adjoining cells. There must be a way of just inserting rows
into a cell?
Thanks
random number20 Nov 2006 09:05 GMT1
Can somebody tell me how to do this in Excel
I wish to create random number between 1 to 64 with reset value 0,
when  a submit button is pressed a random single number is generated
between 1 to 64  and when reset button is pressed it goes back to 0 or
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.