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 / December 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
FIND DIFFERENCE BETWEEN >50 AND <6029 Dec 2005 01:09 GMT9
hi...
Sir,
For Eg: i have 1000 students...i entered marks to all the students now i
need to fine the total students who have score >50 and <60 in each subject..
How do I compare 2 text columns & show differences in 3rd?29 Dec 2005 00:42 GMT2
In Excel XP I'm trying to compare two columns and extract the differences in
the 3rd column. For example,
Column 1   Column 2   Column 3
ACD           ACDI          I
SUMIF exluding text29 Dec 2005 00:34 GMT10
Hello I am trying to sum data in a column based on the absence of a character
in a related column.
That is to say I need to be able to exclude rows that contain an "m" (there
may be multiple characters in the criteria cell)
Simple, but not for me...help29 Dec 2005 00:32 GMT9
Trying to set up a simple spreadsheet. Columns A, B, C are client information
Column D is Invoice (current one in dollars) Column E is to be total to date,
for all the invoices in Column D,
adding column D to E each time for a running total. I cannot get this to work.
Multiple Sums Depending on a description.28 Dec 2005 23:56 GMT9
I really don't know how easy or difficult it might be, but here it is:
I have something like this (example) :
--------------------------------------
|     A     |     B     |     C     |     D     |
I want to change the selected print area but it will not allow me28 Dec 2005 23:41 GMT1
was created by someone else.  I can edit like add numbers and information.
But it will not allow me to edit the print area, I get only the WHite plus
sign(like) as a cursor not the usual cursor to drag and change the print
area.
Macro VBA code to name Save-As file28 Dec 2005 23:24 GMT7
The following code works to name a Save_As file (but I want to add data from
two cells to the name of the file):
    ActiveWorkbook.SaveAs Filename:= _
       "C:\Filename.xls" _
Excel28 Dec 2005 22:39 GMT1
Is there anything that can be done for a workbook that stops printing the
font size chosen? I have a document, all text, that I have used numerous
times and now it will not print in 12 or 10 font but shrinks during printing
to say an 8 or less. I don't know what I did to the ...
Combo Box Properties28 Dec 2005 22:38 GMT1
When adding a combo box for example, to edit the data source you need to go
to properties. Somehow I've manged to change the format which I see the
properties appear in. Does anyone know where I might be able to change this
back? I think I might have put it into Lotus 123 editor ...
automatic underlining and blue color of email addesses28 Dec 2005 22:32 GMT1
How do I remove automatic coloring of blue for email address and underlining
of email addresses in a cell.  Also, how do I stop automatic signing on to
the internet address when I double click in a cell to revise an email address.
Week/month/year rollovers with PivotTable28 Dec 2005 21:25 GMT5
I have a pivot table that summarizes production data on a monthly and weekly
basis. I have generated another table that uses the getpivotdata and displays
data for current month-to-date, previous month, week-to-date, previous week,
and each individual day of the current week. It ...
excel function reduce and increase numbers28 Dec 2005 21:12 GMT1
I need to find out a formula that increases one number when the other
decreases, but does not decrease the number when the other increases.  
example
cell A1=30   B1=40
Concatenate or "&" problem28 Dec 2005 21:06 GMT6
I have tried to concatenate or use the "&" in my database with no luck so
far. I get either the #VALUE! or #NAME? result. I have addresses that are
separated into columns by number, direction, street, and suite. I want to
combine the numbers and text onto one line, in one column. ...
is it possible ot use two or more columns as criteria in VLOOKUP?28 Dec 2005 20:35 GMT3
I need to be able to use two colums (State (B2:C####), County(C2:C####)) to
match against corresponding columns 2 and 3 in a VLOOKUP (named FIPS_LOOKUP)
table and return data stored in Column 4 to WORKSHEET1!A2.  
The idea is that a user will populate WORKSHEET1!Col B and C and ...
How to delete rows using formulas28 Dec 2005 20:28 GMT1
have a spreadsheet of employees' names, #'s, etc.  I need to delete rows
and add new names, etc.  The formulas says =+SUM(A73+1) for example.  I can't
just highlight the row and delete because it gives me an error #REF!+1.  
Please help.
 
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.