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 / New Users / December 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Left Lookup Custom function27 Dec 2006 18:51 GMT2
Hello all I am trying to write a custom function to do the work of my
current function, so that all I have to do is type the custom function
name in and select the cell.  This is what I have so far, but is not
working for me.  As I am new to Custom Functions some help would be
Parsing Names in Excel27 Dec 2006 16:16 GMT3
I have a list in Excel from A1:A100 with names like the ones mentioned
below:
     Michelle Fooo (michelfoo@exchange.SASMOM.com)
     Myhaass Smith (mysmith@exchange.SASMOM.com)
Web Query Help27 Dec 2006 14:56 GMT4
I'm having a difficult time with Web Queries. I have set up a web query
that automatically updates every 10 minutes. I would like to save the
data from each of the updates in a separate sheet. So far I have had no
luck. Can anyone point me in the correct direction?
HELP Please -urgent27 Dec 2006 14:49 GMT3
Hello every one,
May be this is very simple question for every one, but i am stuck up
and can not proceed because of this simple query.
I have an Excel sheet with results.  the following is final X
Is there an array formula for text?27 Dec 2006 14:34 GMT4
By using the following array, I can call up the sum of corresponding
numbers in column B as a result of conditions set in column A:
{=SUM(IF(A1:A100=1,B1:B100))}
However, I need to call up text instead of numbers in column B.  For
Caught out with cheating by using conditional formatting <g>.  How to deal with via formula instead?27 Dec 2006 10:49 GMT5
Cell C5 is a value from another sheet in the workbook.  However, I set
conditional formatting to blank out B5 if B1, which is on the same sheet C5
is on, is blank.  Now that I have added a formula that will use the value
from cell C5, this workaround isn't working because C5 is ...
How to add and remove spredsheets27 Dec 2006 06:34 GMT2
I need help
how do i add or remove spredsheets from excel workbook with visualbasic 6.
thanks
A Drop down menu that eliminates selections27 Dec 2006 03:40 GMT3
 I've been reading lots of posts and groups.  And I can't find one
describing how to do what i want.  I have a list of options.  Apple,
orange, grapes.  And i want to place one item in each cell in a column.
I also want to eliminate the option as they are placed so that once
Conditional formatting does not work with MATCH / VLOOKUP27 Dec 2006 02:08 GMT4
I do have two sheets and use conditional formatting.
One sheet works fine.
When I get a value on that sheet the other sheet with MATCH and
VLOOKUP, and use the same conditional formatting on that sheet, CF does
finding new template26 Dec 2006 21:19 GMT1
where can i find a gas station templates.  templates that i can use for
daily cash flows, register balance, end of day sales, and other templates
that can help me better run my business better.
i would appreciate it if anyone gives me a tips on how to approach this.
automatic sorting in excel26 Dec 2006 20:35 GMT1
I would like to be able to have a column sorted alphabetically contiuously.
In other words, whenever data is entered, the whole column gets arranged
alphabetically without having to "click' on the sort function.
I am not a power user of excel, but I now understand the basics of ...
sumif vs sumproduct question26 Dec 2006 20:25 GMT4
I have a simple spreadsheet with column B containing all dates, and column D
containing all numerical values. The dates range throughout a year. At the
bottom of the sheet I've entered January through December in another column.
To the immediate right of the month named, I have a ...
Less points in graph26 Dec 2006 20:05 GMT1
Is there a way to lessen the number of data points on the graph?
I would like to pick the entire column for the function, but to see in
the plot only part of the point.
Is it possible?
Conditional Locking Of A cell26 Dec 2006 19:12 GMT2
Is there a method either within excel or or via a VBA macro to
conditional lock cells in a excel spreadsheet
The proble we are having is that we have a template spreadsheet and
people are accidentally changing historical data.  We would like to
Data validation listbox still not working after troubleshooting26 Dec 2006 16:49 GMT1
The list box in each cell in ranges I've named are not working--only
the top cell or record in the list box can be used for some reason.
The list box, when clicked, does not even show the top value--just a
blank field.  Does anyone know why this would happen?
 
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.