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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
total Hours Worked for week PS thx for the formulars everyone!09 Sep 2007 06:36 GMT1
Mon           Tue          
A1             B1          
7:00          7:00        Start Time
A2             B2
Copy & Pasting Excel Spreadsheet to CorelDraw09 Sep 2007 02:58 GMT1
I have just upgraded to Office 2007 on my Dell Laptop from Office 2000.  I
have created invoices in CorelDraw 9 but have copy/pasted Excel spreadsheets
for numerical data on the CorelDraw pages for years with no problem.
Since the Office upgrade, the Excel 2007 spreadsheet data ...
change parameters of a range to be summed09 Sep 2007 02:34 GMT2
hi, I have a macro in a worksheet that selects the last populated cell in a
range (D18:V18), copies the formula from this cell and pastes it into the
next empty cell to the right. I wish to then create a formula in cell Y18
that will sum only the range from the newly populated ...
charting question08 Sep 2007 23:55 GMT3
I am charting cells formated as percentages in a pie graph using Excel
2003. Is there a way to not show the 0% values in the pie chart?
Thank you
David
Sliding scale commission percentages formulas08 Sep 2007 23:33 GMT7
How would I make this table apply to each cell that contains my different
sales % figures in order to see what my Rate Earned would be?  I am a total
novice. Thank you in advance.
Sales % Achieved       Rate Earned
IF statement pulling from Product List08 Sep 2007 22:09 GMT5
I'm trying to setup a simple tracking system with a product list. What I want
to do is have one sheet list all the product information (item name, number,
cost, etc), and have another that tracks each customer's order.
I want to input the product number on the customers order, ...
Excel applications for a Barcode scanner08 Sep 2007 19:34 GMT3
Currently, I am able to scan barcodes from a scanner which opens up an Excel
file and verifies the UPC code on the product. What I need to do is set up a
table that will then show the price equated with the UPC. I'm thinking a
VLookup would work since I have about 20 UPC I must ...
Excel 2003 Identify a single character in column08 Sep 2007 19:16 GMT2
I have a list of student usernames for our website. Generally the default is
firstname.lastname but some students have firstname1.lastname. I am trying to
identify all the students with firstname1.lastname and I would like to run a
conditional format that identifies all cells ...
Shared workbook08 Sep 2007 17:11 GMT1
I have a spreadsheet that is shared between 8 people on a network. Is it
possible to protect this so that each person only sees the parts of the
worksheet that is relevant to them, but have the whole thing available to
the administrator?
Designating color in one cell based on data entered in another cel08 Sep 2007 16:55 GMT3
I need a way (formula, format, etc) for the background color in one cell to
be determined by the data entered in another cell.  For example:  Cell C6
will have a number manually entered.  Cell D6 will have a single letter
manually entered into it.  Based on the letter entered in ...
IF function08 Sep 2007 14:48 GMT3
Hi - I have a spreadsheet which I record all my monthly outgoings in.
I put a tick in column E against each amount when it's come out of my
account.  Can anyone tell me if there is a way of getting column F to read £0
when I've put the tick in column E?
SUMPRODUCT to count items with duplicates where another column contains two defined items08 Sep 2007 10:33 GMT4
Ok,  I think this is a SUMPRODUCT delima.
A    B    C    D
z            1
q            1
How to create link b/n Excel worksheet (cell) and Word document?08 Sep 2007 07:22 GMT3
I need to insert a link into specific cell of an Excel worksheet to a
specific part of a word document. I have tried using Hypserlink - doesn't
work. I have tried using Copy, Paster Special as a link - doesn't work
either.
Deduct Months from a Date08 Sep 2007 04:22 GMT6
In Column 'D' I have a list of dates in the form MMMM/YYY
Column 'E' contains whole numbers which represent a no. of months
In column 'F' I wish to deduct the number of months in 'E' from 'D'
Can anyone help?
cell with static current time08 Sep 2007 02:42 GMT8
i would like a cells in a column to display the curent static time the cell
in the previous column is a certain value
ex:
if cell value is "out" or not "in" then next cell to display when value
 
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.