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 / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Finding a future date15 Sep 2006 11:12 GMT12
I need to find the date when several events occur forward from today.
Typical would be the Wednesday in the second week of next May.
Given:
A1 = 2 (second week of the month)
Sort Alphabetically15 Sep 2006 09:41 GMT2
I have six columns of entries. Each column of entries has several headings.
Under each heading the entries are sorted alphabetically but not the
headings themselves.
All is fine except for one list of entries that will not sort correctly.
Stopping spreadsheet save15 Sep 2006 09:19 GMT2
We have a spreadsheet that we share among users by keeping it on a shared
location on server. The problem is that we want everyone to be able to
modify the sheet but we want to stop users making copies of the sheet to
avoid versioning issues. Is there a way to do that?
Putting a word into a cell.15 Sep 2006 08:03 GMT2
I would like to put a word into a cell depending on the value in another
cell.
Example:
Cell A1=399
Find replace15 Sep 2006 03:59 GMT5
Here's an easy one for you clever people, how do I find and replace on a
single sheet or column? please.
D R
Assign Values to String Value15 Sep 2006 02:43 GMT1
I am trying to assign a numeric value to cells with string/text variables.  
For instance, 10-2 would signify 4 hours... so the value I would like to
calculate would be 4.  Is there an easy way to do this?
Thanks
Conditional Formatting with Arrays15 Sep 2006 02:36 GMT2
Hi, I have a question regarding arrays and conditional formatting. I
have two columns. One is my master list which contains the numbers that
I need. The other column has numbers that may or may not be inclunded
in the Master list. Is there a way I can create a new column that would
Lottery check15 Sep 2006 02:13 GMT13
We buy 35 tickets twice a week and always the same numbers. Can I make a
spreadsheet that will check our tickets against the winning numbers?
Two excel problems15 Sep 2006 02:09 GMT5
I am using Excel 2000, I have two problem, one small, one big
Small problem
I have a worksheet with just under 5000 rows and half a dozen columns. Two
of the columns contain telephone numbers. Unfortunately in the conversion
Consolidating Rows based on Cell Numbers15 Sep 2006 02:07 GMT5
I have rows cells that I need to consolidate to another page by a
reference number found within the list. For example:
Sheet 1
A                          B                        C       D               E
Using VLOOKUP to display required information15 Sep 2006 01:55 GMT1
Hey all,
I'm trying to create a spreadsheet that references an existing Excel file that contains data in the following format:
Supervisor    Name    Email    Phone #
Bob           Joe     a@b.com  555-555-1234
Problem Importing Fixed Width Data15 Sep 2006 01:42 GMT7
I have a data set of about 700 entries from an old Pascal program that
was exported to a text file in this fomat:
ID # : 10106
 Sex : Female
How do i set up a budget with self totalling column15 Sep 2006 00:40 GMT2
I have made a basic budget with columns
Date, Money in, Money out, Balance
what I want to know is if there is a way for me to put a formula in the
Balance column which will recognise if there is a number in the in r out
Pivot Tables: Locking Certain Features15 Sep 2006 00:30 GMT1
I'm looking for a way to prevent users from both adjusting pivot
filters or refreshing the pivot.  Does anyone know a way to lock these
features, but still alllow users to move/add/remove fields from the
table or select data within the fields?
Using formulas for pivot table15 Sep 2006 00:28 GMT1
I know you have the count field but is there away to input a formula?
For example customer ordered 25 cases and each case weighs 4 lbs and
the end result would need to be total pounds ordered.
Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.