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 / General Excel Questions / August 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How to put a formula in a column25 Aug 2008 18:06 GMT6
the formula a1*b1 is in C1 and i need to place that same formula in every
cell in the c column example: a200*b200 in c200 (the information in each cell
is different) I just don't want to put the formula in each cell help
How do I disable a SORT25 Aug 2008 17:58 GMT4
I opened up a previous Excel doc and it was inexplicably sorted by the data
in one particular column. I don't want any sorting at all on the document,
yet when I go to Data > sort > none, it returns an error message saying that
the field cannot be none. How can I take OFF the ...
Help needed with cell reference25 Aug 2008 17:41 GMT6
I am trying to piece together info from three cells in an effort to reference
another cell.
EXAMPLE
A1 = 2008   (This is a hyperlink that links to worksheet('2008')
I want to create a calculated item based on a calculated field25 Aug 2008 17:30 GMT1
Dear
I want to create a pivot table as below to compare sales numbers by product
with 2 years in the columns, and for each year the kg sold, the margin and
the margin/kg. Furthermore I want to calculate the difference between the 2
Group cells during sort25 Aug 2008 16:48 GMT1
I have a sheet that has column A marked with a priority level. A, B, C and
so on down the sheet. Across from that I have colum B with the project it
applies too.
In column C I have the details of each project listed down about 4 cells
Remove Email View on spreadsheet25 Aug 2008 16:21 GMT1
This is such an easy questions no one has asked it on this board. My
predessessor created a spreadsheet which shows an email address (like
Outlook) at the top of the page.  I can't figure out how to take it off.  Any
ideas?  This is driving me crazy especially because when I hear ...
How to list items instead of counting them with Pivot Table25 Aug 2008 15:42 GMT2
Under Excel 2003, I have a worksheet with several columns. When using the
Pivot Table I am able to select count, sum... possibility for the data part
of the Pivot Table Layout Wizard. It works great and I am happy.
However, I would like now to list the items instead. How can I do ...
Adding columns25 Aug 2008 15:42 GMT1
my problem is my totals on my invoice are cents off. Some totals are right to
the penny, while others are short by several cents.
Copy from one sheet to another using VBA25 Aug 2008 14:54 GMT2
Hello I am currently retreivng a list to which I add a sequence number and
from which Max() gives me the last record in the list.
Name         Country    Code    Amount Sno
Mr x           MRU         M01       10.00     1
Find and Replace Troubleshoot25 Aug 2008 14:40 GMT6
When I find and replace using an *, it replaces the actual text with an *
instead of replacing with the text that is already there.  I can't figure out
what I am doing wrong.
Cell= 22-SRH059
Excel 2002: Max, Min and Average formulas25 Aug 2008 14:32 GMT3
I need to compute the average, maximum and minimum values fore items with
identical codes as illustrated below:
    A    B    C    D    E
1    Code    Weight    Average    Max    Min
If(and statements using data in an array25 Aug 2008 14:30 GMT5
I would love some help with the following statement.  {=if(and(b2='DBP -
09'!D:D,C2='DBP - 09'!E:E),'DBP - 09'!K:K,0)}.   I've previously used excel
97 and am now using excel2000, so not sure if something has changed from that
version to this.  The formula returns a #Num error.  ...
Excel 2002: How to compute average, min and max figures?25 Aug 2008 14:30 GMT3
I need to compute the average , maximum and minimum price in Table 2 from
raw data in Table 1:
    Table 1           
    A    B    C    D
Validation Problem25 Aug 2008 13:50 GMT3
To simplify the spreadsheet, I have Users listed across Row1 from B to G; and
Activities listed down ColumnA. Each User has to enter their time against an
Activity. The total time allowed for all Users per Activity is shown in
ColumnH.
why would a excel file sent with data open as grey screen25 Aug 2008 13:15 GMT1
Sent a excel file (.xls) containing data via email.  Other contact opened
file sent and stated it opens as a grey screen, contains no data.  This file
is updated and sent on a weekly basis, and this week he cannot successfully
open file.
 
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.