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 / August 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Row Sequencing18 Aug 2005 18:33 GMT8
I have done a number of sorts and filters and rows now skip the numbers that
are hidden.  Now I am satisfied with the rows showing and I want a straight
numerical sequence of the rows shown, without any numbers skipped.  Can I get
this?
Selecting Random Data18 Aug 2005 18:26 GMT2
I have a spreadsheet that has data in A1:J4163 but the size is not always the
same.
My question: Is there a way that I can make a formula, VBA or Contitional
formating to select rows randomly and color fill the rows
How do I print two sheets in same workbook duplex?18 Aug 2005 18:24 GMT1
I am trying to print two sheets in a workbook duplex.  It worked yesterday
but today for some reason it has stopped working.
Can the =CELL formula be used to determine the worksheet tab name.18 Aug 2005 17:41 GMT4
The tab is named '522' and I want '522' to show up in a cell in the worksheet
such as A1.  I know that =CELL can be used to get the filenam, but can it be
used to get the tab name?  If not, is there another function that will?
Linking spreadsheets18 Aug 2005 17:30 GMT2
Not sure if this can be done but this is what my boss is trying to do:
Have two worksheets.
Worksheet A is a shared worksheet.
Workshop B has cells linked to figures in worksheet A.
subtotal - multiple criteria18 Aug 2005 17:20 GMT7
i have a sheet, which i want to sub total on two levels..
for example, i have a product number, country code, and value.  Th
sheet is sorted by product number then country code.
i require totals for the value of the product (which i can acheive b
Linking arrays and Worksheet names18 Aug 2005 16:55 GMT2
Doozie of a question - workbook, formula linking
Hey guys,
So I have this workbook with tons of different worksheets, with
different names. I also have a summary page with summaries of the
Setting Purely BLANK Cell18 Aug 2005 16:43 GMT4
I am using an IF function that states as the following
[in Cell B1]
=IF (A1="ABC","","ELSE")  
When this IF statement is TRUE, I want B1 to be a blank cell, hence the
Formula to combine text?18 Aug 2005 16:29 GMT5
Greetings.  I need a little help.  Is it possible to combine text from to
different cells together with a formula?  Example:  A1 = My name  B1 = is
Will, and I want C1 to say My name is Will.  Is this possible?  Thanks in
advance for any help.
Need help adding :18 Aug 2005 15:59 GMT2
I need some help, desperately.  I was sent a spreadsheet with several
thousand entries, and all of the dates reported as (example) 1015.  Is there
a function that I can go into the next column and say " take value in A1 and
move over two places, add a ":", in theory converting ...
Simple selection, but hey, I'm no guru!!18 Aug 2005 13:56 GMT1
I have a small table of data ranging from column A to column D runnin
from cells 5 to 11. Lower down the sheet I need to select from th
items in column A and I am currently using a "Validation" drop down bo
to do this. I would like to populate another cell with the data on th
Performing a convolution in a worksheet18 Aug 2005 13:28 GMT2
I have data in the first two rows of my spreadsheet.
In the third row, I would like to compute a convolution:
   X(3,j) = sum for i = 1 to j of  X(2,i)*X(1,j+1-i)
where X(i,j) is the data in the ith row and jth column of the spreadsheet.
How to make the cell or font color red if the number is negative?18 Aug 2005 13:28 GMT6
I'd like to make a cell change color or the cell's font change color as the
number in the cell changes from negative to positive or vice versa?
WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8.18 Aug 2005 13:22 GMT3
TRYING TO CALCULATE 8 HRS STRAIGHT TIME, IN ADDITION TO ANY HOURS OVER 8
MULTIPLY BY 1 1/2 IN THE SAME CELL
Can I Somehow load a Spread Sheet thru a Scanner18 Aug 2005 13:11 GMT1
I am wondering if you guys may be aware of a hardware or a software
product that can provide me the capability to put scanned table data
in
a spread sheet format. For example, I make a Xerox copy of a data table
 
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.