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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Wildcard IF formula12 Apr 2006 18:22 GMT3
Help for the needy... please?
Am trying to make a wildcard IF formula to work. The sample below doesn't
work because IF formula can only match by one word and not a word within a
few. I'm looking for a formula to detect the keyword "yellow" in each row in
PHONE NUMBER formatting12 Apr 2006 17:44 GMT3
All I want to do is have my phone numbers appear (555) 555-5555, but
for some reason I keep getting all these weird -- in between the
numbers. I read that I should put
"(999) 999-9999"! as an input mask, but that didn't work. Does anyone
copying a reference12 Apr 2006 17:32 GMT1
I have 13 worksheets titled Jan - Dec and Total.  Each of the Jan - Dec
worksheets are set up identical but after each month, different data is
entered for that month.  The Total worksheet has 12 columns titled Jan - Dec.
Total!A1 = Jan!$A$1.  
Download An Open Letter From Al-RASHEDEEN Army To The American President12 Apr 2006 17:31 GMT1
Download An Open Letter From Al-RASHEDEEN Army To The American President
click on one from the links below for listening
http://rapidshare.de/files/16495134/bush64.rmvb.html
http://www.uploading.com/?get=216MX6C6
Address for Linked Files in Formula12 Apr 2006 17:19 GMT1
I don't know if this is an excel issue or a network issue.  With many of our
excel files that have links to other excel files across a network drive,
formulas within cells will point to the file location with the server name
and not the drive letter.  
what's the formula for finding 401(k)?12 Apr 2006 17:12 GMT1
How do you find 401(k) because I have a question asking, well saying, insert
a formula to calculate the 401 (k) contributions for each employee. The
formula should determine if the years of employed (4.17) is > or = to 1, then
the contribution is equal to the contribution ...
Convert Excel 4 formula to Excel 2003 format12 Apr 2006 17:07 GMT3
Got this formula defined as a name (Cell has formula):
=GET.CELL(48;INDIRECT("rc";FALSE))
Used it when I had Excel97
Now I have Excel 2003 and get an annoying message that I have an Excel 4 macro
When I open a workbook, how can I choose which worksheet opens?12 Apr 2006 16:59 GMT1
I want to be be able to set which worksheet opens when I open a specific
workbook.
how to freez more five columns without splitting the panes?12 Apr 2006 16:54 GMT1
please help, i can find a way to freez the columns without splitting both
rows and columns (panes).
thank you
Formula doesn't update when rows are inserted12 Apr 2006 16:53 GMT2
I have a formula that is simply adding cells E8:E184.  When I insert rows
(begining with E185) and populate those rows with data, the formula doesn't
pick these up.  In all of my other spreadsheets, the formula automatically
updates with the inserted rows, but this one doesn't ...
Linking sheets into one major sheet?12 Apr 2006 16:47 GMT3
I have a large workbook, split into sheets, with very complex formulas in it.
I want one sheet at the end of this workbook to reflect all the data from the
other sheets, if you know what I mean - so it is ALL the data from the
different sheets, in one "all info" sheet. I also ...
get text from another worksheet12 Apr 2006 16:27 GMT1
I am trying to get text data from one worksheet to copy to another worksheet.
For example, in column A in wkst1, I have a list of several customer numbers.
In column A in wksht 2, I have every customer number and their respective
names are in column B. I would like to have a ...
PIVOT TABLE12 Apr 2006 16:22 GMT1
I want to disable refresh options while working in PIVOt table since it is
disturing my own format while refreshing or adding my data... pl. advise...
Ranking within in ranges12 Apr 2006 16:22 GMT2
I need a formula that will allow me to rank one column of  numbers based on a
value in another column. e.g. If I have values in column A and countries in
column B. I want to rank the values by country in other words each country
will have a #1 etc. also the number of values by ...
Formula to add two cells when one or both cells are text12 Apr 2006 16:19 GMT2
I created a multi-page workbook to determine the sales bonus earned by
my employees.  The problem is that some of them forfeit their bonus if
they don't meet the minimum standards for quality, adherence,
retention, etc.  Also, if someone has not made a sale or attempted
 
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.