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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Looking for certain months and summing the totals30 Jan 2008 17:44 GMT10
I need a formula to first look for all of january date, febuary dates, etc.
and total them under check amount column. Hope this is clear.thank you
Amount    Date     Check Amount    Month
$320     1/29/2008      $1,886.24     Jan
Assigning macro to toolbar - only works sometimes!30 Jan 2008 16:47 GMT4
I have recorded a few macros for my colleague, i have sent the file across in
which the macro was coded and have advised my colleague to assign the macro
to a toolbar button.
He assigned the macro to a toolbar button but finds that each week he needs
VBA Function30 Jan 2008 16:46 GMT7
How to combine 3 macros to run together.  First, I would like to unprotect
all sheets for which I am using the following macro:
Sub unprotectAll()
Dim myCount
Data Validation error message30 Jan 2008 16:28 GMT1
I have set up a data validation to include a drop down box of a list of yes
or no on my question.  I have also set up a conditional format to color the
box in if the answer is no.  however I'm having trouble getting the error
message box to flag up if they select no.  I thought I ...
Count of a time range30 Jan 2008 16:01 GMT13
I have a list of times 0:00 - 24:00 and days and I need to find out how many
files were processed between in an 8 hour shift per day
Entry Number    TIME    Est. Date of Arrival
9065233-5                   14:56    1/1/2008
Before Save code30 Jan 2008 15:57 GMT4
I have an excel spreadsheet where I have cells that are mandatory to fill in.
I used the Before Save code in Thisworkbook and it worked.  Now how can I
suspend this action so I can save the file myself?
Adding workdays30 Jan 2008 15:42 GMT1
I need to add networkdays to a date that will return a date
(example: start date 1/1/08 plus 10 networkdays = 1/15/08 because 1/1/08 is
a holiday and 4 days are weekends).
IF Function to enter background colour and border to a cell30 Jan 2008 15:37 GMT1
Is it at all possible to set up an if function to have a cell become a
certain background colour and to have a border added to the cell?
The right formula is?30 Jan 2008 14:58 GMT2
I'm trying to put together a complex weight chart to record a few different
items for my wife and I, been so long i cant remember the correct formula to
calculate plus and minus weights in the same column as below.
B2               B3               B4                    B5        ...
Crazy If30 Jan 2008 14:44 GMT1
Looking through multiple worksheets:
I multiple worksheets (at least . Each worksheets has the same data and
different data.
Example:
Linking cells in different spreadsheets30 Jan 2008 14:31 GMT6
I want to link a number of cells from different spreadsheets into one main
stock control spreadsheet and I've no idea how.  Any suggestions?  
ie  Stock control = 200
    Order Number 50
Formula to record the date30 Jan 2008 14:03 GMT12
I've been working with the following formula:
IF(B2<time(14,0,0),today()+1, today()).  
What the formula should do is determine if it is before 2pm on a given day
then put today's day.  If it's after 2pm then put tomorrow's date.  I have
avoid embedded if statements30 Jan 2008 13:07 GMT3
Is there a quick way to do multiple if statements rather than using an
embedded if statement?
I have the following:
If A1 = 1 then write carpet, If A1 = 2 then write couch, If A1 = 3 then
copy data of two cells from Sheet 2 into one cell in Sheet 130 Jan 2008 13:00 GMT6
I have a workbook with multiple sheets, the first sheet is a summary sheet.  
I'm trying to copy data from two separate cells in one sheet to one cell in
the summary sheet.
CLARIFICATION:  From Sheet 2 I have data in cells K33 & K34.  I need to have
choose table_array in VLOOKUP from list of multiple worksheets?30 Jan 2008 12:56 GMT5
I'm looking to search multiple worksheets labeld by date using the vlookup
function. I'm using the drop down, and I want to know if there is a way to
reference the drop down to a list of ranges, or have that drop down be a
changing reference to in the table_array section of the ...
 
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.