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 / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
copying date from one sheet to another work sheet25 Sep 2006 22:56 GMT13
I have Date column on sheet1 and i would like Date Columns to propagate
on other sheets
when i enter this formula on the sheet2
=A1
mutiply by either REG or OT hours, and SUM!25 Sep 2006 22:34 GMT6
I am trying to figure out a way to quickly generate a gross payroll number
without the aid of a 'helper' row, which won't work this situation.  I have
about 60 employees.
Sample:
Last column entry lookup.25 Sep 2006 22:25 GMT1
Trying to bring the last entry made in column F (from a checking balance
workbook) The formula works OK for the first sheet but doesn't work when I
copy it another sheet.
=LOOKUP(9.99999999999999E+307,F:F)
How do I insert a drop down list button from an excel worksheet?25 Sep 2006 22:19 GMT2
I an revising a schedulig form and need to create some drop down menus on one
spread sheet from data on another worksheet.  How do I insert the drop down
button on the schedule from the list on the data sheet?
I created a list of time options and employee options and need to have ...
Pull last word from a text string in Excel25 Sep 2006 22:13 GMT8
Is there a way to pull just the last word from a text string in Excel?
I have a sheet with a column of text descriptions that are various lengths
and the last words in each cell are various lengths.  Basically I want
everything to the right of the last space.
Excel 2007 (Beta) Auto Filter25 Sep 2006 22:08 GMT1
When I had Office 2007 (Beta) installed, I did not like the new auto
filtering options. I was used to being able to customize my filter with the
"contains", "begins with" etc. options. With the new version, these are not
available. One must check mark every instance of what you ...
ADDING A PRINT CONTROL BUTTON25 Sep 2006 21:55 GMT1
I have a work book that i enter everthing on the first sheet and it puts
information in the other sheets in the work book.  how can i add a button to
the first sheet to make the other sheets print there are 7 sheets in total i
need for 6 to print when clicking on a button.  Could ...
if function and ifblank() function25 Sep 2006 21:47 GMT3
Hi List,
Here is what I am looking for:
             Column A      Column B          Column C
Row 1    1000             Blank(hasF)       100%
Formula not copying down25 Sep 2006 21:44 GMT6
I am currently trying to copy a formula down for a total of 734 rows and
across several columns.  For some strange reason it stops at 641 rows.  Once
I drag the formula in, the cell is just blank.  I have tried a new worksheet
and also tried retyping the formula.  Nothing works.
top ten customers by transaction count by product25 Sep 2006 21:31 GMT2
I have a data dump.  each row represents a single transation for a product by
a customer.  There are 15 products represented in the data dump. So product 1
could have 100+ transactions/rows by customer A.  And custmer A could have
bought all 15 products in multiple transactions.
Removing 1-2 caharacters25 Sep 2006 21:03 GMT1
I have a lengthy licst of names I need to use for a mail merge. The first
names are seperated from the last, that's great. however, many of the first
names have a mibddle initial and some have a period following the initial. Is
there a way I can remove the last 2 characters of a ...
ranking based on criteria25 Sep 2006 21:03 GMT1
I am creating a spreadsheet that shows the results of a marching band
competition.  The awards are given by class, 1st, 2nd and 3rd place.  I will
have the following:
Name         Class        Score
calculate the sum of characters in a cell25 Sep 2006 20:51 GMT8
calculate the sum of characters in a cell
How to calculate time after converting 12.22 to 12:2225 Sep 2006 20:37 GMT1
First I'm trying to enter time (Hours.Minutes) like 12.22 or 123.54 instead
of 12:22 and 123:54 for fast entries because I have many of them. Add all of
them after.
I use the formula in cell A2: =INT(A1)/24+MOD(A1,1)/14.4 to convert in time
Concatenate & Date25 Sep 2006 20:26 GMT2
I am trying to create a macro that saves a spreadsheet to a name based
on data in a few cells.
For example, if I have Date and ProjectName in two cells, I want the
macro to save the worksheet as DateProjectName.csv.
 
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.