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 / July 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
formula to find all possible combinations12 Jul 2007 22:22 GMT2
Is there something in Excel 2003 to find all possible combinations of a set.
For example if I have:
Employee
Spouse
Inserting Buttons as Hyperlinks12 Jul 2007 22:19 GMT3
I need to create buttons on a spreadsheet that will be hyperlinks to email.  
But I need the spreadsheet to be sent as an attachment to the person from a
list.  So in short I need a button that will look at the name of the person
and put in their email address and then email them ...
find and replace units of a formula12 Jul 2007 21:02 GMT3
hopefully this is simple.  I often want to preform a find and replace
sections of a formula, say I want to change the reference column form A to D
or something..  
currently I have hundreds of formulas that are sum(G11:AD11) and I'm trying
Making two lines into one12 Jul 2007 20:22 GMT3
Is there a way to combine row A and B into one row?  For example, I have
data in both rows.  Both rows are for the same borrower.  I am trying to
combine row A and B into one row that has all the data both A and B had.
I know I can cut and paste each line, but the spreadsheet is ...
RANDBETWEEN in a conditional format gives error12 Jul 2007 20:02 GMT5
When I try to use the RANDBETWEEN function in a condional format (e.g., cell
value = RANDBETWEEN(1,100)), I get the error message "You may not use
references to other worksheets or workbooks for Conditional Formatting
criteria."  Why is it telling me this, and how do I get it to ...
Macro that Finds the First Value in a range using a Combobox (drop down menu)12 Jul 2007 19:50 GMT2
I have a long list of countires and some info attached to them in a
spread sheet.  I want to add a drop-down menu at the top of the spread
sheet that will go to the first cell in the column that contains that
text.  E.G.  If I choose Peru from the menu I want it to go to that
How do i display a negative time as a res of distracting 2 times?12 Jul 2007 19:37 GMT2
In a sheet about working time i want to extract two times.
1 is the normal working hours for the day
2 is the actual worked hours on a day
If 2 < 1, the result is negative - I worked not enough hours on that day.
If - then help.12 Jul 2007 19:32 GMT6
this one is too complicated for my brain, so I need help...  I'll do my best
to explain:
I have 4 cells (A1, A2, A3, A4)
A1 is a total dollar amount of a small section of a group of amounts
Turn around Time12 Jul 2007 19:16 GMT2
Good morning,
I have a workbook and my goal is to see when a number is no longer on the
sheet.
My workbook looks like this
Using a single cell refernce to change multiple formulas12 Jul 2007 18:29 GMT5
I have created a table of suvey results listing multiple businesses each on a
separate line with data from each business in columns to the right of each
business name.
For example:
Dragging formulas12 Jul 2007 18:04 GMT7
Hope someone can help out here, please...
Excel 2003:
I have a list of columns (i.e. B8, C8, D8, E8 etc) that I want to copy down
a row on another sheet.
Conditional Format Formula Issue12 Jul 2007 18:01 GMT7
I am trying to use CF on a non-contiguous range of cells. I'm basically
trying to tell it to place a top border on the cell if it is NOT the same as
the cell above it. I have also tried only contiguous cells, with no luck
either(and would certainly have no problems applying it ...
How i display True/Fale in one or two colum12 Jul 2007 17:42 GMT2
How I can display True/Fale  in a one or two colum, if colum A1 to A500 and
C1 to C5000 have same amount. With a formula or Micro
Converting embedded objects in excel versus word12 Jul 2007 17:34 GMT2
In Office 2000 SP3 there appears to be the functionality of being able to
right-click on an embedded object in a word document and having a Convert
option appear that will let you convert the file type, however this function
does not appear to be available in Excel, is this the ...
Nested IF Functions with OFFSET12 Jul 2007 16:18 GMT3
I am trying to use the following formula as an array (entering using
CTRL+SHIFT+ENTER):
=(SUM(IF('working sheet'!$B$4:$B$59998=$C14,IF(working sheet'!$J$4:$J
$59998="D",OFFSET(working sheet'!B4,0,VLOOKUP(Summary!F12,working
 
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.