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
Want to display financial formula result... not the formula05 Sep 2007 09:26 GMT2
When using the Financial Functions, I bring up the function pop-up box, type
in my number or cell addresses and hit enter... well I get the result within
the pop-up box, but then when I close it all I see for that cell in my
spreadsheet is the formula.  How the hec do you make ...
How to read the value of a cell05 Sep 2007 09:10 GMT17
Is there a way to read the value of a cell that has a formula in it?  I have
one cell who's formula reads the value of other cells, but some of those
other cells would have formula's in them.  Is this possible?  Thank you
vLookup from 2 different lists05 Sep 2007 09:02 GMT3
I have a pallet of product to be disposed of and I need to check whether its
serial number appears on a "Approved" list or a "Not Approved" list (2
different sheets both lists named). I have currently have 2 colomns (1 for
each list) but would like to have only 1 colomn to show ...
auto SUM bottom page05 Sep 2007 07:19 GMT2
on updating microsoft, i lost the auto SUM function that shows up on the
bottom of excel page (when you highlight a column or cell and then the total
appears in the bottom right hand corner on the tool bar). Also lost the
filter indicator on the bottom left side of the screen. I ...
find first and last in row of numbers05 Sep 2007 07:04 GMT2
I have a sequence of up to 4 numbers in a row (Column A to D).  Sometimes
there are #'s in all spots, sometimes in just the first one, any combination
of a random # or blank is possible.  Only rule is that there must be a number
in the first position (column A).
Date Conversion dd.mm.yyyy to dd/mm/yyyy05 Sep 2007 06:42 GMT1
I have a proprietary program which exports date time values to a text file
in this format dd.mm.yyyy and i would like to be able to work with these
values in excel, but of course excel likes dates to be in dd/mm/yyyy format.
Any ideas on how to go about converting them?
concatenation05 Sep 2007 05:36 GMT2
hi,
i would like to have filtered output in concatenate, i don't know how i can
do this :(
col A has make of Car's and col B has Models and i would like to
formula question05 Sep 2007 04:18 GMT5
I have 5 combo boxes, their default value is blank with a reference of 1.
The user selects a size from the list in the combo box. Ie. 11oz 14oz 16oz
etc... I want to, lets say the first box they select 11oz which is reference
2 they go onto the second size combo box 2 and select ...
Adding values from a different worksheet05 Sep 2007 03:17 GMT2
I have a budget workbook that includes a breakdown of expenditures (checkbook
register style) in one worksheet (worksheet(1)).  Each breakdown item
includes a location number.  There are a total of 20 location numbers.  
In another worksheet (worksheet (2)) I have a total amount ...
counting the number of times a word appears05 Sep 2007 02:49 GMT5
I have over 1000 entries where one colum contains cells with multiple info
such as:
Provide professional development opportunities, Subsidise the cost of
training courses, Organise social events, such as presentation nights,
How do you truncate 2.22 to just 0.22?05 Sep 2007 01:14 GMT6
Say I have a list of cells with numbers, some even some odd and some
with trailing decimals like so.
2
2.33
how do i put color in a cell based on data in a second cell05 Sep 2007 00:32 GMT5
Cell A1 has 8 digit number manually entered each day.
Cell B1 has a single letter manually entered each day (same time as A1 entry).
The background color of cell A1 will be determined by the single letter in B1.
I've looked at conditional formatting, but haven't had much luck.  I'm
Time and lunch breaks04 Sep 2007 23:42 GMT5
Is it possible to subtract two times and automatically have it subtract .5
hours for a lunch break if it is over 5 hours? I'd like to do this all in one
cell. Any suggestions would be helpful!
click on one cell to locate another cell04 Sep 2007 23:12 GMT3
I want to click on one cell to fine another cell in the same worksheet, like
a hyperlink within the worksheet
how do i transfer necessary rows/data from a master sheet04 Sep 2007 22:52 GMT1
i have downloaded a master sheet with info for 10 specific groups.  now i
would like to set-up a macro in a different sheet to pull only the data
related to one particular group.  it seems like a easy macro but i can't
figure it out.  can someone 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.