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 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how could I import a text file with comma separated values into ex15 Sep 2005 11:27 GMT1
how could I import a text file with comma separated values into excel?
Thanks in advance
What is wrong on the fomular: Offset(MIN(A1:A10),,-1)?15 Sep 2005 11:19 GMT4
I have a huge spread sheet, in which I need to extract the value from the
cell, which sits right to the lowest value in the whole row. E.g.:
Example row: 2|4|7|3|0.3|10
Expected extract value: 3
Adding Cells15 Sep 2005 10:37 GMT4
I have cells that are different colors ( to represent differnt items).  If i
want to make a fomula that added on the cells that were a certian color, how
would i be able to do that?
Thanks
Formula error in merged cells15 Sep 2005 10:36 GMT1
Help! I recently discovered an error in my shipping worksheet. I
sometimes need to merge certain cells when I am combining items from
different purchase orders into the same shipment. However, when I
totaled the column (SUM) containing the merged cells, it delivers a
combining 2 pieces of text from 2 columns15 Sep 2005 10:36 GMT3
Column A has first names, and B second names.
I want C to list the 2 names together, how do I do this?
thanks, Alex.
How do you add a-z (alphabetically) to your toolbar in micr works15 Sep 2005 10:04 GMT3
I can't find excel. I need the a-z added to my tool bar. I am trying to log
in about 4,000 videos in alphabetical order. I am trying to start a home
business of video rentals and sales. I need the a-z for my inventory. Please
help me, I am desperate.
Arrays15 Sep 2005 07:37 GMT3
I have an interesting situation, would like some input.
I have a set of values on a sheet which have one similarity which is the acct#
now i want excel to copy that data to an appropriate tab which is numbered
with that specific acct#, i want it to copy all the activity that is in ...
Linkage data between two spreadsheet15 Sep 2005 06:50 GMT2
Can anyone help to solve the follow problem:
Spreadsheet A has the follow column:
-PartNo
-VendorCode
Formula Assistance Required15 Sep 2005 05:10 GMT4
I'm trying to create a formula that if (f3)*1.14 minus (h3) minus (k3) is
greater than or equal to zero, response would be "0" but if the response is
less than zero, response would be "Error" or some other message as a visual
marking that  (f3)*1.14 minus (h3) minus (k3) is less ...
Filtering Columns to Align Matching Data15 Sep 2005 04:48 GMT4
If I have a list of data in column A,  ie: phone numbers, and I also have a
list of similar data in column B.
Some, but not all numbers in column B match numbers in column A.
Is there a way to filter the two columns so that matching data from columns
Make boxes apear on paper?15 Sep 2005 02:09 GMT1
How do I make the cells apear on the printed page?
HELP!
Can't get list in Document Contents for workwheet14 Sep 2005 23:54 GMT1
In any given worksheet, in File -> Properties, there is a Contents tab.  On
this tab is a list of the worksheets within the workbook.  Is there any way
to get a list of these without having to do a manual copy/paste from each
tab, or scroll through the tabs to get what the names ...
How do I define "contains' as the default custom filter?14 Sep 2005 23:35 GMT2
How do I define "Contains" as the default custom filter criteria or make it
fist in the pulldown choice?
Need to compare 2 tables to generate 3rd table14 Sep 2005 22:50 GMT1
I have a table with a list of items and another table that explains what each
item is.
How do I have excel compare the 2 tables and generate a 3rd table with the
items and description matched up?
change case in excel14 Sep 2005 22:31 GMT9
can someone tell me where to find the "add in" that converts the case text
from lower to upper in excel. i've already downloaded this before but can't
remember where from and it is much easier than creating a formula or a macro
 
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.