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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Calculating Dates07 Feb 2008 00:56 GMT6
Need to a run adhocs on the 1st and 15th of each month to find individuals
who will reach the age of 59 1/2 two weeks prior to the reaching the 59 1/2
age, bascially the 15th adhoc run is to cover the first half of the next
month and the 1st adhoc run to cover the second half of ...
Date/time increment specifier07 Feb 2008 00:38 GMT4
Date + 1 increments the date.
How do you increment date at year, month, hour, min, or second?
Ex: Is there anything more compact for “Date + 1 year” than DATE(YEAR(Date)
+ 1, MONTH(Date), DAY(Date))?
Reconcile Inventories Using excel06 Feb 2008 23:55 GMT10
I have two inventories downloaded into Excel and need to reconcile them.  
There 500 items in each worksheet.  Is there some kind on add in or function
to use that will compair them and tell me what the differences are.
PDIFF , DDIFF06 Feb 2008 23:38 GMT1
What do these mean and how do they work?
Thank you,
Steven
automatically copying cells06 Feb 2008 23:23 GMT1
Can excel automatically copy the content of one cell to another cell? For
example, if I want the contents in say column L, row # 10 to automatically
copy to column E, row 10 when I type the info into column L, row # 10 ... how
do I do that?
I want brackets around my math equation answer?06 Feb 2008 23:20 GMT7
I am putting together a equipment table that has to have entries in metric. I
would like to set it up so that you type in the english units and it would
the convert into metric on the next line. However i have to have Brackets
around the Metric numbers...is there a way to do ...
Formula editing06 Feb 2008 22:49 GMT2
I usually edit complex formulas in a text editor, especially if I want to
replace constructs, ex: replace string check for “PROD_1” with “NPRODX_2”.
Is there a way to extend the Excel Find/Replace to formulas? This would be
very helpful in replicating entire sets of formulas for ...
{=SUM(ABS($Q$5:$Q$651))}06 Feb 2008 22:44 GMT3
I am looking at spreadsheets someone else built and seeing cells with
formulae like what's shown in subject.
I can see what it is supposed to do which is to sum the absolute value of
each cell referenced, which is something I want to duplicate elsewhere.
recall cell value in hyperlink06 Feb 2008 22:30 GMT2
Thanks for taking the time to read and hopefully help me come up with a
solution...
Cell A1 = 1234
cell A2 =hyperlink("http://www.website.com/" & "A1" & ".aspx","name to
find last row value in column when using MATCH to find column06 Feb 2008 22:16 GMT6
I have a problem where I use MATCH to find a column with a specific heading
and then I want to find the last value in the column.  
I would like to achieve this just using formulas in the worksheet if possible
All the solutions I have found require the Column letter ("B") instead ...
change font color on search06 Feb 2008 22:11 GMT2
Hi, I need to do a search and replace in a worksheet.  When I match a string,
I want to change the color.
For example, if the string is
"Hello everyone!"
Search and calculate formula06 Feb 2008 22:09 GMT4
I am working on a project and trying to figure out a formula.  What I want to
have happen is in the A column I have different project codes and in the H
column I have the cost of the task.  I would like to have a formula that will
find a specific code in column A and then add the ...
Sumproduct syntax when using AND, OR06 Feb 2008 22:04 GMT3
I have a list of trouble tickets with ticket#, open and close dates recorded
like this:
A                B                    C                  
1234    05/01/07           06/15/07
Formula Help06 Feb 2008 21:27 GMT2
I am really computer (dumb)! I want to create a formula so when I type in the
#1 John Smith will be entered into that cell.
enter if less than06 Feb 2008 21:10 GMT4
i am trying to get the sum of two cells or $30, whichever is less
g98*3<30
if g98*3 is more than $30 i want it to return $30
otherwise return the sum of G98*3
 
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.