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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
copy cell difficulties19 Feb 2007 07:07 GMT1
Example ....
Sheet 1, [cell]A1 = Snoopy
I want "Snoopy" to be copied to Sheet 2, [cell]K7, so if I change "Snoopy"
(on Sheet 1, A1) to "Woodstock", it will change Sheet2,K7 as well.
challenge! javascript function into excel function19 Feb 2007 06:35 GMT2
Hello,
I am sending again my question or problem to you. i am not able to do so.
please help me.
I have one columen witch contain Ids 11 sifer in excel. i have one formula
Hyperlinks19 Feb 2007 05:48 GMT3
Hello from Steved
I have a worksheet in excel that I use to link to Paragraphs in Word
CitySchools.doc#027^t3.35
A question please Can I in Excel spreadsheet put the a list off links as I
cell referencing18 Feb 2007 22:57 GMT2
I fill out missing information letters and often required material is missing
from more than one field. I want to be able to fill in the explanation for
missing information in field 1 and field two into the same cell, which
content will be merged into a letter.
count how many groups have been completed.18 Feb 2007 21:08 GMT1
I have my last answer, ty to the person who answered it.  Here is my
current answer.
Again in groups of 6 rows in a column, numbered 1-6, i need to make a
total of the number of groups that have an entry in adjoining cells.
Average Daily Balance18 Feb 2007 20:02 GMT5
I have a spreadsheet that lists checks and deposits in chronological sequence
and keeps a running balance of  the account. Is there a function to calculate
the average daily balance for a selected range of dates?
adding rows depending on cell value18 Feb 2007 16:18 GMT1
i hope someone can help with my problem, im an excel dufus.
i have 3 colums, first column numbered 1-6, secong column with various
bits of data, third column i am using to help me add rows.  if a "1"
appears in any cell in the 3rd column, i need it to add a row, and the
Count Unique Values with a Criteria18 Feb 2007 15:40 GMT2
I have 2 columns of data...as follows
Col A     Col B
0001      123
0001      123
Conditional Formatting Cells/Shapes18 Feb 2007 14:58 GMT4
Hi Each and All,
This is what i'm trying to achive,
I'm trying to create a kind of traffic light type of status indicator,
If cell AI7<0 then cell A1 fill red, if cell AI7=0 then cell A2 fill Amber &
linking a text with a date and can't remember the format18 Feb 2007 14:55 GMT5
I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3.  
When I
input in a3: =a1&a2  I get  Sam's Birthday is 39130. I know this needs
something like m/d/yy with the A2 but can;t remember what format it needs.
Extract data in put in a new column18 Feb 2007 12:10 GMT5
I have a problem is which I would like to extract the data in Column A
dependant on the value of column B.
Column A3:A22 contains unique names column B3:B22 contains the
numerical value. In this example I would extract the if the value of
Sorting a range of worksheet tabs A-Z18 Feb 2007 09:47 GMT2
Greetings to all,
My aim is to sort into A-Z order a range of worksheet tabs,
I have a tab named 'A' and a tab named 'Z' and various tabs in between, that
I would like to automatically sort A-Z, I also have some tabs prior to tab
I created a Formula, OK, but can't get the results in the right ce18 Feb 2007 06:59 GMT8
Created Formula for G7
=SUM(G4:G6)
and have copied it to other cells, i.e.
G11
SUMIF for an AVERAGE18 Feb 2007 05:09 GMT2
I have a rather complex (at least to me) question...  My worksheet has column
D with agent initials and column AE with a score. I'm trying to figure out
the formula to calculate an average score for each agent in column D based on
amount in AE?
WEEKNUM and SUMPRODUCT18 Feb 2007 03:08 GMT4
Can they be used together?  Excel 2003 is my version.  I want to count the
number of transactions per week for each of my offices.
Basically, I am not trying to make this fancy at all.
Offices are listed in rows and the weeks are in the columns.
 
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.