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 / November 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Adding time28 Nov 2007 15:36 GMT2
I want to add 847 minutes to 7:31 AM and get 9:53 PM. I have several rows of
data :
Start Time - formatted as 7:31 AM
Duration - formatted as a number that equals minutes
Lookup, match?28 Nov 2007 15:19 GMT6
I have a value in column A on sheet 3, I want it to match a value in column A
in sheet 1, then I want the corresponding number from column c on sheet 1 to
populate column c on sheet 3.
lookup and sumproduct28 Nov 2007 15:13 GMT3
We have a data base that has columns such as start point, load point and
unload point with the distance between each in a separate column.  We want to
create a column that will look up the load point and unload point and give us
the distance.  The problem is that the load point ...
Excel28 Nov 2007 15:10 GMT4
I have a column of scheme codes, with the same codes repeated through the
list eg. 123, 456, 123, 678, 456, 123 and a column of rateable values.  I
need to work out the average rateable value for same group of codes e.g. for
all the 123 codes.  Can you help please if this is ...
Formulas-Making a number a standard amount of digits28 Nov 2007 14:58 GMT4
I am wondering how to make cells in a formula automatically 4 digits long?
The actual formula I am using is "=$B$6 & "-" & A15 & "-" & B15 & "-" & C15".
If the C15 cell is say, "003", in the formula it comes out "3". I need 3
digits for the last part of the whole formula in the ...
Links are different depending on how you open file.28 Nov 2007 14:44 GMT3
In Excel, using worksheets that are on the server and linked together, when
is file is open, any file linking to it recognizes that it is open and drops
the server name from the linked cell and refers just to the folder the file
is located in.
Adding a time stamp28 Nov 2007 14:38 GMT2
I would like to add a field that would state the time an action happened in
another cell...  ei.  tell me the time a field went from 0 to 1
a static time...
thanks
How much I hate the ribbon28 Nov 2007 14:23 GMT6
There's an 'insert' command, and an 'insert', um, subribbon. The
insert command is not on the insert subribbon. How does that even get
through UAT?
adding columns on different worksheets28 Nov 2007 14:15 GMT3
okay i have a workbook saved as "Bluesheet.xls."   The first worksheet
is titled "1" and the second worksheet is titled as "2."
I need a (sum) formula  that will add the totals on sheet 1 cells M41
to M54 & the totals on sheet 2 cells M13 to M54.
IF, COUNTIF & AND STATEMENTS28 Nov 2007 14:08 GMT3
I have a COUNTIF formula which is searching for the number of activities
which occur between 2 dates. This formulae works but I need to add to it.
I have a reporting date (which is variable), I need the addition to only do
the existing COUNTIF if the date above it it equal to or ...
Copy Up until Non-Blank Cell encountered28 Nov 2007 14:02 GMT6
I need a procedure that will start with say cell L300 (which has a text
value) and
Copy it into cells L299-L250 that are blank; L249 has a different Cell value
and I need to copy it into cells L248-L150 that are blank, etc until Row 2.  
Excel, Macro, Drop down list28 Nov 2007 13:15 GMT10
I have a list that I want to make into a drop down list that when each
individual item is selected, cause a macro to run.  Can anyone assist?
How do I insert a spinner (spin box) in Excel 2007?28 Nov 2007 13:05 GMT1
I am familiar with spinners and their use in Excel 2003 but can not find
ANYTHING in Excel 2007 re. 'forms toolbar' 'spinner' or 'spin box'.
Can anyone guide me to this little gem or is it lost and gone forever?
2007 - Column unhide in Excel does not work i.e. "Ctrl+shift+)"28 Nov 2007 12:42 GMT3
I would like to use this keyboard short cut as I did in previous versions of
excel - help!
Adding months to date at end of month28 Nov 2007 12:30 GMT4
I have searched but can't see this specific question.
Basically the question is how to add moths to a date, i need to have a
column that has column F's dates + 10 months.  However, the column F dates
are all month end days, so 31/8/07 or 28/02/06 or 30/06/07.
 
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.