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 / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Converting time from text to numeric21 Mar 2008 19:56 GMT4
I have a column of time logs ranging from:
1:00:00:00
to
0:01
How do I pull certain data out of spreadsheet and import into another?21 Mar 2008 19:12 GMT5
I am attempting to pull data that meets certain criteria out of
spreadsheet and have it imported into a blank spreadsheet.
I have 5,000 records in Excel 2003 with fields for the Company Name
Address, City, State, and Zip.  
How do you have the cells highlight changes? (no track changes)21 Mar 2008 18:29 GMT1
I have a speadsheet that will require many people to review and make changes
to it.  I need to be able to know what those changes are.  Without using
track changes, is there a way to format the cells in such a way that will
either highlight the cell and/or change the font color ...
Compare Col A and Col M, if Match, Copy Col N to Col E21 Mar 2008 17:57 GMT1
I'm trying to get this macro to compare values in Column A and Column M,
starting in Cell(2, 13), and if there is a match, copy the value from Column
N (that  corresponds to Column M) into Column E.  For instance, 4/1/2008 is
in Cell A1 (and the dates go down consecutively).  I ...
macro for inventory/shipping labels21 Mar 2008 17:56 GMT1
I have seen alot of posts for address labels & mail merge (which I have been
frantically using), but I have been trying to (unsucessfully) merge inventory
descriptions and amounts to make inventory labels. Any help would be
appreciated.
return maximum text "value"21 Mar 2008 16:24 GMT1
Is there a function to get in a cell the maximum text "value"  of a list
(e.g. T1, T2a, T2b).
Like MAX for numbers, part of this functionality is embedded in the
sort/filter commando's.
macros with functions21 Mar 2008 15:00 GMT3
I am using excel 2000.  I have created a macro that will clear my "Invoice"
and post pertinent information to the first row of an "Invoice Log" that I
have created in the same workbook, but on another tab.  I would like to have
the macro do a "VLOOKUP"? or some other function to ...
Solver problem21 Mar 2008 10:05 GMT4
Hi, I am playing with learning solver and using a test case that I found I
think on the MS Site
A company produces Radios, CD Players and Speakers. These products are made
from common parts: speaker cones, power supplies, electronics, laser parts
Divide month into two payroll periods21 Mar 2008 08:06 GMT5
I am trying to display rows by pay period. The dates would be from the 1st to
the 15th or 16th to the end of the month.
I am using a calendar control to select the start date. The calendar control
inserts the pay period start date into A11. Then
MS Excel Data Validation, Ignore Blanks in List21 Mar 2008 03:44 GMT4
I have a problem utilizing the Data Validation tool in Excel.  If I
have a list in one column with the following, for example:
-----------------
Dog
How do I sort the whole row at once in Excel?21 Mar 2008 03:30 GMT2
Here's what I have.  I have a document used to record and track dog licenses
in my city.  There are 11 columns in the document.  One column contains
numbers as currency (not set up as text).  I want to sort the document in two
ways.  I want to be able to sort so they are listed ...
Complicated lookup/match formula help needed!21 Mar 2008 01:39 GMT2
Hi--
I have a sheet called "ClientList" where column A has a list of ID
numbers.  In another sheet called "Clinicians", these ID numbers are
in columns BA:BJ.  There is other information (for example # visits
TIME SHEET21 Mar 2008 01:29 GMT1
Can anybody help me out to manually create a time sheet using the cells to
calculate the time?  I any samples, I greatly appreciate it.
Thanks
Julian date - find next highest date/number21 Mar 2008 00:38 GMT1
Hello,
I need a quick answer,
i have cells with dates as numbers next to a number as below:
A      B
Blank Row20 Mar 2008 23:23 GMT9
I need to paste data from one worksheet into another. The copying of the data
is not the issue. How do I determine the location of the first blank cell in
a Column A to paste the data?
 
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.