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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Functions expert………numbering ran    dom condition in a column20 Jun 2007 23:29 GMT14
I need to number random conditions as they occur in a column.  The example
show is in its simplest form.
Column A is a list of colors that are selected randomly.  Column B needs to
be the order in which the color was selected relative to equivalent colors.  
Looking to add color code alert20 Jun 2007 23:29 GMT3
I have a spreadsheet that has a list of 200 customers, I would like to use
the end date of the customers renewal section then subtract it from the
current date and if that is less than 130 days I want the cell that has the
customers name in it to turn yellow.  Can this be done ...
rows 4-15 will not scroll20 Jun 2007 23:01 GMT1
I have a spread sheet that I'm working on and rows 4 -15 will not scroll with
the rest of the data in the spreadsheet.  I haven't been able to fix this.  
Thank you for your help.
Copying rows from one sheet to another....20 Jun 2007 22:56 GMT1
I have a large spreadsheet that I update weekly. Columns a:x and rows going
on forever. I need a way of copying rows that match the criteria to a new
sheet.
i.e if A=dave i need all the information from a:x to go to a sheet called
More specific question about adding color code20 Jun 2007 22:20 GMT3
I am trying to do the following without success
1A = company name
1B = renewal date ex 07/19/2007
1Z (hidden) Has current date which updates to current date each time excel
return TRUE if a date falls between two dates20 Jun 2007 22:19 GMT8
I am looking for an "IF" statement to send back "T" or "F" (true/false), if
the date entered falls between two dates from a list, for all 5 rows...  
The date entered, lets say in A5, of the "Sched" worksheet.
On the "Dates" worksheet, Column A are starting dates, Column B are end
Pivot Table Date Format Question20 Jun 2007 22:19 GMT6
The formating of date in the spreadsheet is mmm yyyy and it does display the
way I intend at this point, but not the pivot table.  When I run a report in
the pivot table a date that is supposed to show up as May 2007, shows up as
5/07/07.   I even changed the format in the pivot ...
Calculate the difference between two times - getting '#VALUE!' err20 Jun 2007 22:18 GMT2
I tried to use help, it gave me the same formula I was using, but when I try
to implement, I get the '#VALUE!' error.
Column A:
6/1/2007   9:30:51AM
password problem20 Jun 2007 22:18 GMT3
I started a spreadsheet for a friend a couple of months back and as she is
always messing it up I password protected it and now cant get the password
correct to update it. It wont be a difficult one as for something like that
(not important) I usually use something simple like ...
"manual page breaks error"20 Jun 2007 22:18 GMT5
I am getting an error message when I try to open my excell file saying "this
action exceeds the number of page breaks you can manually add to a worksheet.
A worksheet can contain up to 1026 horizontal page breaks.  This is a file
that was developed in 2004 and has been set to ...
Comparing multiple column values20 Jun 2007 22:18 GMT7
I have a grid where the column data is as follows
   A            B                  C                    D           E
Exclude; Status; Property Address; Enter Date; Price
I want formulas to calculate the following
linking to other workbooks20 Jun 2007 21:53 GMT1
I am linking cells from one worksheet to another.  When there is nothing
entered yet in the worksheet that I want the into to carry over from, it
is inserting a 0 in the cell (but shows my formula in the top fx box).  
Do you know how to get rid of that 0 so the cell is completely ...
Movng Data Automatically the Fits a provision20 Jun 2007 21:40 GMT3
Sub versive()
Dim myRange As Range
Set myRange = Range("D2:D25")
   For Each "c"        c.Select
How do I add " to the right of a number when formatting?20 Jun 2007 21:05 GMT4
I am trying to format a column of numbers example.
0.152
0.025
I have figured out how to remove the first zero now I need to add a single
formula help20 Jun 2007 21:04 GMT3
Hi I am having an issue with the formula below. It is returning a NA value
for the cells = to 302 & 366. If it is any other value the formula is
functioning fine. Any ideas as to why my formula is not working!! I have try
the vlookups on there own & they work fine.
 
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.