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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Filtering numbers in a column?12 May 2006 20:24 GMT4
I have a column within a spreadsheet that has sets of numbers in it. The
numbers are random. For example: 129 245 789 345. What I want to do is
filter these rows and pull out the rows that have just the number 245
in it or bring them to the top or seperate them in some way. Can
Finding duplicates in 2 worksheets12 May 2006 20:06 GMT2
I have 2 worksheets of data for a mailing list I'm doing.  The first
worksheet has criteria pulled from one set of software and the other is
from a separate system.  What I want to do is find which account numbers
from Sheet 2 appear on Sheet 1.  Those that match get deleted from ...
Right-click inside of a cell12 May 2006 19:28 GMT3
I can't right-click inside of a specific cell anymore so that I can format.
I can highlight an entire column and right-click and it gives me all the
format options then, but it won't work if I just right-click to a specific
cell. can anyone help?
Choosing data based on Match to several items12 May 2006 19:19 GMT5
I have a range of data that is organized based on 5 data points.  I would
like to develop a formula the chooses the proper data based on the values in
the five data points.  Is there an easy way to do that?  I have looked at the
Choose, Match, and Index functions and none seem to ...
Array formula using two columns and countif12 May 2006 19:02 GMT8
Having trouble getting Excel to compute a value based on two columns on
another sheet.  What I need it to do is see if column A has the value I
specify, then look in column B and see if that date figure is greater than
180 days, and then count it.  So I might have 45 that meet ...
Split 2 words12 May 2006 18:54 GMT1
I have 2 words I each cell, I would to put the 2nd word in a new cell, how am
I doing it?
Capital12 May 2006 18:47 GMT5
I would like that the 1st letter of each word should be capitalized, how am I
setting it up?
SUMIF with 2 conditions12 May 2006 18:39 GMT6
I am trying to use SUMIf with 2 conditions, I see someone else asked this
question before but I still can't get it to return anything other than #Value!
Can anyone help me?
=SUMPRODUCT(--('Raw Data'!F2:F60000="TEST");--('Raw
Validation List12 May 2006 18:33 GMT3
I have a column consisting of Weeks. like this:
A            |      B
===============
Week 1       5646.00
Find12 May 2006 18:29 GMT2
I have a worksheet with 100’s of names. The first & last names are on
separate cells (in the same row).
I am trying to find “JOHN DOE”, how do I search for it?
If's conditions about matching12 May 2006 18:27 GMT8
How can I code these if's conditions:
1)
If the first letter of the statement is "A" or number "2"
2)
Is it possible to merge data from two worksheets?12 May 2006 18:19 GMT2
I am wondering if it is possible to merge two worksheets, that have the exact
same column headings, into one document, eliminating duplicate data based on
a specific column. On a weekly basis I am required to run a report and
evaluate it for action items.  I am making notes on my ...
COUNT and OFFSET12 May 2006 18:10 GMT3
I have a range of Data: F8:CT8
I need to count the 1st column in this data range with there being 3
columns.
I just need to count if there is data in the cell excluding zeros.
Increasing values in Price column12 May 2006 17:46 GMT3
Hi,
I run a business and in my spread sheet I have a column for prices - Since
gold and silver have risen to all time highs I need to increase the prices by
20% - there are over 24,000 items - is there an easy way to do that ?
How do I create a formula that makes text in a cell = 012 May 2006 17:20 GMT1
I working on a complex spreasheet where some of the entries are NA.
I need the spreadsheet to perform numerous calculations (add, subtract,
multipy and divide).  
I want Excel to recognize that anytime it sees NA in a cell NA should equal
 
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.