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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Finding MIN value in a column between Two Dates in different columns28 Oct 2007 04:14 GMT3
Hope everybody is doing well. I am trying to find a solution to the
problem I am having for some time. I seem to have found half of the
solution from one of the threads and stuck finding the other half.
Here is what I have:
printing without zeros showing in a cell with formulas28 Oct 2007 02:05 GMT3
I've created a workbook that totals 5 worksheets (for Monday thru Friday) on
a 6th worksheet that is printed and posted weekly. However, because there is
a formula in each cell on the weekly sheet, a zero appears in all of the
cells which makes the sheet being posted look too too ...
Time format 1/1/1900 15:20:0028 Oct 2007 00:13 GMT1
I had some imported times in Access, some of theam are fine, but some of
them are like : 1/1/1900 15:20:00 , after copying them to excel they have
remained the same, and after apply number formats they are the same, I did
see a previous posting where you copy a value of 60 paste ...
match 1 column bringing in a value from another column27 Oct 2007 22:34 GMT3
I tried using vlookup to lookup information in 1 column then go to another
worksheet and bring in the information for another column.  Below is the
formula I'm using but I either get #N/A or the wrong information.  What I
have is a list of outstanding payments I'm trying to match ...
Excel Function27 Oct 2007 21:15 GMT5
Is there a function in Excel where you can select a column of figures, then
ask what figures in the column add up to a certain amount?  Example - you
have a check for $24,674.82 and a long list of amounts.  The check may be for
20 or 30 amounts totaled together in the column.  ...
Cannot Exceed27 Oct 2007 20:43 GMT8
I am working on a formula based on 5% growth per month.  I started out with
100 units in January and in February that number will be 105, and so on.  I
have a maximum number of 150 units I cannot exceed for a formula.  Is there
anyway to set this up as a growth rate per month and ...
Check off Box??27 Oct 2007 19:41 GMT3
Can I add a "check off box" into a document. I am trying to add a box that I
can click and as I go through a document. As I "click or check-off" a box,
the column will add those rows that have been checked. I know how to use the
"IF" function, but I want the user to just be able ...
Group data from a table27 Oct 2007 16:04 GMT1
in the worksheet 'Stock' have a table with many columns , and in one column
the input list has always 4 names of people. (Haris, Chris, Tom, Michael)
Now i want to have 4 different worksheet, one for each person. How can i
gather the data of each speicific person and transfer it ...
Consolidate information from Column B Based on Info In Column A27 Oct 2007 16:02 GMT1
Suppose I have Column A that contains a company's name and in Column B is a
stockholder in that company. However, the program that provides this
information only puts one shareholder in each cell in column B. For example:
Microsoft    Bob Jones
Help on substitue value, by excel function27 Oct 2007 15:42 GMT2
i receive BIG data files with customer name, location, bill number, date and
due amount, reason for delay in payment etc.,
But customer is spelled in many ways and sent to me.
However some portion will be unique.
Protected sheet, On Enter moves next. Can I stop this?27 Oct 2007 15:29 GMT3
I have a protected Excel Worksheet. Only specific cells are unlocked
for data entry. The behavior for protected sheets on enter is to move
to the next unlocked cell. Is there any way to make the move next not
happen? (I have that box unchecked in Tools|Options.)
Conditional auto printing in excell?27 Oct 2007 15:18 GMT1
How do I write macro for conditional auto printing in excell? I have tried
things like:
if L2>0 then print. This would be that a number greater than 0 would get the
system to print the page. This is to be encorporated into an existing macro
lookup with multiple condition, but one condition to satisfy is en27 Oct 2007 14:06 GMT2
I am looking to compare 2 sheets with 20 columns
but i need to compare sheet 1 having 75 rows & sheet 2 having 2000 rows
sheet1 column d d2:d75 to compare in sheet2 column b b2:b2000
sheet1 column e e2:e75 to compare in sheet2 column b c2:c2000
Counting Within a Date Range27 Oct 2007 13:59 GMT2
I'm trying to count the number of people present during any given date range
which I have been able to do.  The problem I'm having is including people who
are still here.  My simplified dataset looks like this
A    B    C
Excel Formular help27 Oct 2007 12:35 GMT1
I am trying to reference dates within a spreadshett that fall per fanancial
year and return it as a number representing the quarter of the year for which
it falls.
For eample if I have a date in column A
 
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.