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 / January 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel # of Comlumns Extension31 Jan 2004 23:31 GMT1
Currently the maximum number of comumns of is IV.  Is
there a way to increase the number of Columns?
How might I do this31 Jan 2004 22:56 GMT1
I have a spreadsheet I use to calculate total hours worked per day, I then
record those hours in another column by date so I can track total hours by
week and still retain the hours each day.
    A            B
LastCellWithData31 Jan 2004 22:26 GMT1
The function, "LastCellWithData" shows up on my Excel list of functions
pulldown menu, though its original source is foreign to me.  And, there is
no "help" feature available to sort of educate me.
Well, on the built-in function box where one fills in the various
Count Functions across multiple worksheets31 Jan 2004 22:14 GMT5
I need some help.
I have a spreadsheet that has upto 30 worksheets in them.  
The data in each worksheet is the response from a person
on 60 questions.  Therefore for example, the cell B4 has
How to split cells into 2 in Excel 200031 Jan 2004 21:21 GMT5
Does anyone know how to
split cells into 2 or more cells in Excel 2000
If This - If That31 Jan 2004 21:07 GMT2
Excel 2000 Issue
This is what I want to accomplish.
I have two workbooks
Workbook A
countif function31 Jan 2004 20:54 GMT1
hi, i need to put .5<3.5 in the criteria of the countif function but i don't think you can do that, as the value i get is always 0..whereas if i put <3.5...it returns with the correct value...is there another function i can use that will let me count the no. of times data appears ...
Function not evaluated31 Jan 2004 19:37 GMT1
I created a simple function in a workbook using tools/macro/vb editor. When
I assign the function to a cell in the worksheet, instead of being evaluated
and returning the value, the function call appears text in the cell. My
function is as follows.
protect / unprotect multiple sheets31 Jan 2004 18:31 GMT4
Hi, I'm trying to protect and of course, unprotect multiple sheets at the same time, without using the Tools/Protection/Protect Workbook option - that option is not protecting the way I want.  I have many sheets in my file and would like to be able to select a range of them (I do ...
importing access data into excel31 Jan 2004 15:53 GMT1
I?m from Portugal and.
I would like you to help me to make a project that import records of
specific acess database into a excel sheet.
For example:
import pictures into excel31 Jan 2004 15:50 GMT1
I am creating a program in excel in which it is for a tile shop. i hav
a product list page which contains pictures of the tiles. i want
picture of the tile to appear on the quote sheet. how do i do this
--
Concatenate text with a carriage-return31 Jan 2004 15:28 GMT1
I have two cells with the following text;
A1 = "abc"
B1 = "def"
I want to concatenate these two text into C1 with a carriage-return
Probably Easy Answer!31 Jan 2004 15:22 GMT4
When I write my formula in the cell then enter to move out, instead of the answer being displayed I see the formula on the sheet.  What am I doing wrong.  I've tried everything I can think of!  Please help........
Help with countif function31 Jan 2004 14:50 GMT3
I've created a very simple formula using countif.
=(COUNTIF('Sheet1'!$D$4:$D$4000,1))
Adjacent to column A where "1" appears I have a another number which I would
like to find a total for.
Possible Concantenate31 Jan 2004 13:53 GMT2
Excel 200 Issue
I have 2 spreadsheets in the same workbook
Spreadsheet A
cell F9 value is 50
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.