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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
max of average28 Nov 2006 21:58 GMT5
how would you take the max of an average in a situation such as this:
1 2 3
3 4 2
2 3 4
Cell address28 Nov 2006 21:46 GMT6
Hi all,
I am trying to find a cell adress in a table sized 7 * 53, i am totally
stumped please help before my brain explodes
Password Access to certain sheets28 Nov 2006 21:39 GMT2
I have a workbook with several sheets. I use this for several offices and I
want to set it up so that the user can only view the sheet that pertains to
them.
Adding hours to a date28 Nov 2006 20:50 GMT6
I want to add a number of hours to a date and a time and have Excel give me
the resulting date and time.  The hours that I will want to add to the date
could be
anything, including part days, eg 3.25 hours, 92.4 hours, and so on.
VLookup returning more than one Row of information28 Nov 2006 20:09 GMT1
I know this has to be easy but for the life of me I can't figure it out.  I
have a Vlookup statement...IF(ISNA(VLOOKUP($A2,COREDB,8,False)),"
",VLOOKUP($A2,COREDB,8,false))...it works but it only returns information
from one entry.  The number in cell A2 appears in the database ...
Exporting Time Formatted Numbers inside Macros28 Nov 2006 19:56 GMT4
I have a Macro that exports certain pieces of data into a ".TXT" file.  
Everything is working well, but today, I am trying to add to columns to the
export file, both of which are stored as Custom "h:mm" time values.
Currently, for example, the following values are in the ...
SaveAs28 Nov 2006 19:51 GMT5
this might be an easy one for someone in here , i have a short script that
saves a file in 2 places by over writing the exsisting files, when i run the
script i get a box that requires me to click on it to overwright the file....
how can i get the script to do this without asking ...
Find Variance28 Nov 2006 19:30 GMT2
Ok.. don't know if the terminology is correct, but basically what I need to
do is... I have found all of the manufacturer's products where they have
charged us different unit prices.  I will need to prioritize them so that we
work on the items with the most significant difference ...
duplicating worsheets28 Nov 2006 19:11 GMT2
I have created a template that I would like to duplicate to other worksheets
in the same workbook. When I copy and paste the font size and column widths
do not stay the same. How do I fix?
VLOOKUP puzzle ??28 Nov 2006 18:54 GMT7
getting a little frustrated with what I though would be a simple VLOOKUP
formula, so turn to you for help.
Cells C6:G80 are populated with data
I want the whole of column G to be searched for the exact code FQR and when
when doing a grade book how do you drop the lowest grade28 Nov 2006 18:54 GMT2
I am trying to do a grade worksheet. I am looking for the formula for
dropping the lowest grade
How can I use autosave from excel2000 in excel200328 Nov 2006 18:50 GMT14
I have just upgraded from excel 2000 to excel 2003 I have always set autosave
to 5 minutes in case I press the wrong button as I did tonight. I also had
autosave set to save all open workbooks
I am a heavy user of excel and often have many workbooks open at the one time
Finance functions discrepancy28 Nov 2006 18:24 GMT4
Note: I have previously posted this in NG
microsoft.public.excel.worksheetfunctions (note the lack of a 'dot'
before functions). I've had no response, and it looks like a very
queit NG, so have posted here. Hopefully someone can help . . . .
Spreadsheets--Adding Quantities28 Nov 2006 18:15 GMT4
If I have two different worksheets, lets say spare mechanical parts, that
list the part number in 1 column and the quantity in stock in another column.
Is there a way to bring them together so that the quantities of any
duplicate part numbers will add up?  For instance if on 1 ...
Subtotaling of hours28 Nov 2006 18:03 GMT2
Example:
A       B        C
TIMESHEET
In      out     Hours
 
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.