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 / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
filter the rows which is having the colored text10 Mar 2008 13:43 GMT1
I have a set of 310,000 rows which I recieved from somebody and I want to
delete the rows which is having colored text
Can I filter the rows which is having colored text and then delete it
completely??
Filter / Drop Down Menu10 Mar 2008 13:21 GMT1
I'm hoping you can help;
I'm trying to create a function I have seen on other worksheets; basically
when a cell in clicked on, a small drop down menu will appear to the right
hand side with pre-determined text of the aurthers choice. e.g. if I had a
Help with averages revisited10 Mar 2008 13:20 GMT6
I had posted a question about averages earlier and received a helpful reply,
but after trying it the suggested solution did not work.  So after thinking
for a bit this is what I came up with:
I have a series of times in cells B3 through F3, some of which are values of
SLOPE,  (error in b if y= a+ bx)10 Mar 2008 13:13 GMT1
So I did my regression analysis using the SLOPE function,  the number I'm
interested in however is the error in the result of SLOPE (b if y = a + bx).
What Excel function to use here ?
Formula to calculate the difference in weeks between two dates10 Mar 2008 12:50 GMT3
I' am hoping you can help with what might seem a basic query.
I have a row of dates in one column for which I want to find the difference
between the earlist and latest date i.e. =max(A1:A10)-=Min(A1:A10); however I
cant get the cell to calculate the number of weeks difference as ...
Find Method problem in Excel VBA....10 Mar 2008 04:49 GMT7
I have a problem about using find method in Excel VBA.
Here is my program:-
_________________________________________________________________
Private Sub CommandButton2_Click()
Multiple Criteria for lookup array10 Mar 2008 04:19 GMT3
G'day there everyone,
not sure if this is possible.
I understand the row v column principal for a lookup array:
Ideally what I need is this
Text and defined name result in same cell10 Mar 2008 02:41 GMT2
I am trying to create a schedule for several teams.  Each team has a defined
name (Team1, Team2 etc). I want a spreadsheet something like this:
A1: Week 1 Games
A2: Team1    B2: at Team2
how to use date in if fxn10 Mar 2008 01:42 GMT2
I would like to have my condition be a date in my true/false part of my IF
function.  Is this possible?
How to use Excel for Kolmogorov-Smirnov test10 Mar 2008 00:19 GMT2
Has anybody used Excel for the Kolmogorov-Smirnov test?
Bold font if statement09 Mar 2008 22:01 GMT3
A column of numbers is calculated in if statements based on other column
numbers is same row. Want to bold the font if a number is greater than 4 in
excel 2002. How can I do this?
Count the number of appearance within a cell09 Mar 2008 21:56 GMT13
In cell A1, I put text "Apple"
How can I count the number of appearance of letter "p" within one cell?
I would like the answer come out as numeric "2"
Thanks.
Adding a calculated field to a pivot table09 Mar 2008 21:22 GMT4
I have a pivot table that includes these fields:
1. A count of "Traffic types" (which are text)
2. A count of "Sales Dollars" (which is in currency)
I want to add a calculated field that will take #2 above and divide it by #1.
Get multiple answers from a table09 Mar 2008 21:06 GMT4
I have two columns, one (Column A) that repeats and the other (column B) that
has a none repeating number.  I need to have a formula that will give me
result in column C that will display all the results from column B when
searching for a number is column A.  Like when looking ...
average of sumed data in pivot tabel09 Mar 2008 20:33 GMT3
In a pivot table, I would like to have the average of the sumed data, and
make the average update automatically when the table size expends.
Qtr           Sum of Sales Amount
Qtr1    28,441.99 |
 
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.