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 / New Users / January 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How? compare two worksheets and identify rows of data that appear on both.10 Jan 2008 21:16 GMT9
Ok,
Suppose I have 2 worksheets.
Sheet 1 has 1000 lines of data spanning xNumber of columns.
Sheet 2 has 500 lines of data, also spanning the same number of columns.
Tooltips with OptionButtons in worksheets10 Jan 2008 18:43 GMT1
Excel 2003, sp2
Hi,
I have inserted several optionbuttons, grouped together in groupboxes, in a
worksheet.
Can I get Excel to automatically BOLD dates 30d before expiration?10 Jan 2008 17:35 GMT12
I am new to Excel (obviously), and I have created a simple worksheet that
contains numerous dates.  I wish to have the dates become bold when they are
to expire within 30 days.  Is there a formula for that purpose?
Thanks...
How do you password protect a single cell or column of cells10 Jan 2008 17:30 GMT2
I am trying to password protect a column of single cells but it keeps
protecting the whole work sheet can ant one help?
Automatic Adding10 Jan 2008 16:29 GMT1
Not sure if i used the right formula to begin with to calculate the sum of 7
different cell ( D5-J5 ) ...i just went to Math , sum, then typed in
D5+E5+F5....and so on.
But now i want to have the total amount figured out automatically as hours
Combining worksheets10 Jan 2008 15:29 GMT1
I have a large number of worksheets, all with the exact same format. I would
like to be able to have them all in one one worksheet, without having to
spend a large amount of time using the copy and paste functions. Therefore,
is there anyway of combining a number of worksheets ...
Vlookup and min formula10 Jan 2008 15:02 GMT3
I have a worksheet that has dates in column B and file # in column A. In cell
J12, i have this formula =min(B2:B100), in L12, I have a vlookup to return
the information in column A that matches the date =vlookup(J12,A2:B100,1,0).
I receive a #name error.
VLOOKUP in a macro10 Jan 2008 14:57 GMT4
In Excel 2002 using and an InputBox I want to input an ID#, then find that
ID# in a VLOOKUP table, then using the InputBox, enter a score (Points) in
the cell next to (right of) the ID# in the table.
I am trying this to no avail:
Window 2 open automaticly10 Jan 2008 14:52 GMT3
When I open a normal workbook (without VBA) a second, same workbook
opens automaticly. Named xls:2.
How can I get rid off this?? Has it something to do with my settings?
Usually it works fine.
Need to convert the numbers with tolerances10 Jan 2008 12:37 GMT4
I have a column of numbers in teh format 0.45+_0.23   . +_ is a
character plus or minus .
How can I convert the number before and after +_ into mm
automatically  ? Any formula ?
What is meant by "Standard Colors" in Excel 2007?10 Jan 2008 12:15 GMT1
What is really meant by "Standard Colors" when you use the shading paint
bucket in Excel 2007?  Are all of these colors supposed to be
backward-compatible with Excel 2003?  (They're actually not... the "light
green" from Excel 2007's "Standard Colors" gets permanently converted ...
Referencing cells10 Jan 2008 12:00 GMT4
I've got two workbooks linked together. Workbook A gets information from
workbook B by referencing cells. This works well until someone enters a
column into the middle of workbook B and workbook A picks up the wrong
information from workbook B. Is there anyway to get workbook A ...
change from dollars to pound sign on balance sheets10 Jan 2008 11:51 GMT1
trying to change dollar sign on balance sheets to pound signs,any help
gratefully recieved
Macro To Amend Data In A Column10 Jan 2008 09:40 GMT14
I hope that someone can help me with a problem I have inherited with an
Excel 2003 file.
When the file was created, a column was sized and then the data was made to
fit the column by adding spaces and using word wrap to align the data on
weibull distribution function - graph10 Jan 2008 04:31 GMT1
Hello, I need to make graph of Weibull distribution function with  a = 10, b
= 10 and count the modus of the function. I never did something like that.
Can you give me detailed description how to do it? Thank you.
 
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.