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 / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Time conversion & adding29 May 2008 13:00 GMT5
Hi there,
I have a stats sheet that records how many minutes a basketball player plays
during a game.  This same sheet also tracks each game, so I have a column
that shows playing time for numerous games:
How to create a form on one sheet that enters data into another29 May 2008 12:58 GMT4
Hi - new to VBE & macros, otherwise comfortable with Excel.
I'd like to create a form on sheet1, which will resemble a paper form that
is used to gather info.  I'd like for this info to be entered into a row on
sheet2, and eventually have some totals and other summary info ...
how do i draw up a table to do my own 5 generation dog pedigree29 May 2008 12:32 GMT1
i need to draw up a 5 generation dog pedigree and i cant do it.does anyone
know how i would do this by knowing what one looks like in the first place?
Converting comments attached to cells into data29 May 2008 11:30 GMT2
I thought I'd try again to get an answer to this problem. I have a
spreadsheet set up and in one particular column, each cell has a comment
attached. Is there some way that I create a new column and copy each of those
comments into the cells so that they become part of the data ...
Converting comments to data29 May 2008 11:25 GMT5
I have a basic spreadsheet set up and in one particular column, each cell
has a comment attached. Is there some way that I create a new column and copy
each of those comments into the cells so that they become part of the data in
the spreadsheet? I don't want to cut and paste ...
Automatically Highlight every 22nd row29 May 2008 10:37 GMT2
I have a sheet of over 750 rows of data and need to pick out every
22nd row for an audit. Is there a way to get Excel to highlight every
22nd row in steed of manually counting every 22 row and highlighting
Thanks,
averaging formula from three cells29 May 2008 10:03 GMT2
i must make a formula to average a column of numbers but only the numbers
which are narrowed down from two other columns.
for example:
Production Calendar (sheet 1)
Search and Replace Entire Cell Content29 May 2008 09:37 GMT4
I want to search for text within a cell, and if that text is found anywhere
within that cell, replace the entire cell with a given text string
Signature

JerryG

character map29 May 2008 09:27 GMT1
I have a spreadsheet that has tick boxes in them that I cant delete or cut.
Please can anyone tell me how to do this and they are no longer required.
Fill repeating Numbers29 May 2008 09:27 GMT8
Is there a way to fill a repeating set of numbers. I have students listed by
their daily schedule. 1st period - 8th period.  I want to create a period
column and have it fill in 1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8,1,2,3,4,5,6,7,8
all the way down the column to the last student.  I ...
how can you let macro determine to where to copy29 May 2008 08:15 GMT1
I've got several sheets with the same info but in a different layout
in columns.
The column headers are identical. The sheets have a different number
of rows.
count text appear how many times & put in respec col??eg 1st times29 May 2008 07:53 GMT3
Need to found out the text eg Movie appeared how many times in a worksheet.  
If 1 time = 1R , 2 time = 2R, 3rd times = 3r etc
IF blank!!29 May 2008 06:03 GMT9
I have an IF statement which I want to identify if it has a blank cell or not.
So I do one formula if it is empty and one if it has a value
I have managed to do it with multiple columns using =istext but I want the
formula all in one cell. I have tried if cell=null and variations ...
Limit on number of comments in a worksheet29 May 2008 06:02 GMT2
Good day!
I've written a macro that validates the cell values in a worksheet, and
writes the error messages as comments in each cell. The problem I'm having is
that if there are too many rows (at least 2000) and too many errors, writing
Need magic Excel formula for Date calculation29 May 2008 05:08 GMT2
Problem:
Need to determine the total number of days to process a product, including
the number of days each section took to do their part.
Column "D" is actually one cell providing a SUM of C1:C4.  
 
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.