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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How can I change default row numbers in Excel ?27 Aug 2006 18:52 GMT4
I wanted to change/modify the default row numbers in Excel but was unable to
do it.Actually I have inserted logo which covers row 1 to 8 and then my
actual data starts.But what I want is the actual row which is showing row
no.9 shoudl be as row no.1 .Can anybody give a solution ...
INDEX function multiple columns & rows27 Aug 2006 17:41 GMT2
I am trying to put together a formula that will take the column value from
one cell and the row value from another cell and go to this table and enter
the number that corresponds with where the two values meet.  Keep getting
#VALUE! error when I use the index function
AutoSelect? in Drop Down List Box27 Aug 2006 16:31 GMT1
I am trying to create an invoice template and added a drop down list
box in the description field to provide valid available product
description to select from to avoid typing.
Problem that I am having is that this only allows me to select
Count occurences in array with condition27 Aug 2006 16:22 GMT2
Experts! See if you can help
Column I, range I200:I800
Column J, range J200:J800
I'm trying to count the number of occurences when number in column J is less
multiple condition lookup and match cell format27 Aug 2006 15:56 GMT3
Sheet 1:  A 35 cell column, each with user intials "XXX", each cell is
formatted with font and pattern choices.
Sheet 2:  Cells A1:M15.  If the contents of a cell matches one of the cells
in Sheet 1, match the contents and the format of that cell.
How can I track numbered inventory?27 Aug 2006 12:32 GMT6
I cannot find a formula to give me a figure for exact # in a numbered
inventory.  For example:  My items are numbered 800 to 819  if I just
subtract it gives me an answer of 19 when I actually have 20 items.   I need
a formula that is inclusive.   I tried subtracting with +1 but ...
Help with function on LOOKUP with Text27 Aug 2006 12:25 GMT2
I'm trying to run a few simple functions, but I can't seem to find any
information on what I'm doing wrong.
1.) Based on a range of inputed data (i.e., <5, >80) in cell BN171, cell
BO171 displays the text "GO" or "STOP".  This repeats itself down the column,
condition formating27 Aug 2006 11:09 GMT2
I have more than 50 columns, how I can make each column condition is column
dependent ? instead do column by column. I try use the paste special , it
doesn't work, it just copy all formula over from the first column.
Crazy Question here27 Aug 2006 08:31 GMT3
I want to give a visual demonstration to those who are going to be joining
our team - of how to use Excel to do our job. I was thinking Power Point
could some how record the use of Excel but I couldn't find any way of doing
this WITH Excel.
Formula to open an Autoshape27 Aug 2006 07:03 GMT3
Hi guys...Is there a way I can open up a textbox/Autoshape using a
formula? I want the cells to check for a condition and if it is
satisfied I want to print a value in a textbox or autoshape. I really
appreciate your help!
copying info from one cell to another, changing the format, but leaving the number27 Aug 2006 06:13 GMT1
I would like to transfer a number from one cell to another... problem is
that after I do calculations in one format, I need the number to perform
another calculation in another format... for example, I calculate time
to get my total time (in minutes), lets say the number is 231 ...
Weight tracking formula?27 Aug 2006 04:07 GMT2
I am attempting to keep track of my weight loss/gain and don't know how to
write the formula so that I can tally each week the total loss/gain.
Change Cell background color by selection27 Aug 2006 02:13 GMT1
Excel 2003
I have a table of data, and I would like to have a section of it highlighted
with a different background color when the user selects the first cell in
the row (selecting this cell also drives a couple of other functions as well
Counting cells that don't contain certain text26 Aug 2006 23:39 GMT4
Is there a quick and easy way of counting the number of cells that don't
contain certain text strings
For example
Column A
How do I choose first value greater than 0?26 Aug 2006 22:18 GMT2
I have a worksheet with data by month in columns.  I want to look
through the data consecutively and find the first value greater than 0
in each row.
I can do this with an imbedded if statement, but I did not know until
 
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.