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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Alternative to a drop down list06 Sep 2007 15:28 GMT3
Hi, I have designed a requisition form.  The first work sheet "req" in the
spreadsheet is a form that links to 3 other worksheets in the spreadsheet.  
In the "req' worksheet, Officers select a supplier from a dropdown box.  It
then does looks ups (Vlookups) based on the supplier ...
VBA Code for Deleting a Row06 Sep 2007 15:23 GMT3
I would like to use a macro to delete any row that has the word
"delete" in one of its cells.  What would this code be?  Thanks!
pop up calander in an excel spreadsheet06 Sep 2007 15:22 GMT1
I'm attempting to create a popup calander in an excel spreadsheet to be able
to choose a date and fill in a field. How can I create it?
Complicated formula help needed please06 Sep 2007 15:17 GMT2
Is it possible please to create a formula where
Sheet1!A2 = the count of Sheet2!C* where Sheet2!A*= Sheet1!A1 and Sheet2!B*
contains "String"
Thanks
I wish to fomat numbers in Excel06 Sep 2007 14:55 GMT4
so that 0's follow:if I enter 123 then 123000 will enter.
unable to solve array formula syntax06 Sep 2007 14:24 GMT2
I'm confounded by what I think should be a rather simple formula -- I
think an array formula. Here's what I have so far:
=SUM((DateAll)*(WeekdayAll="1")*(quarter="Q1")*(Fiscal="F2008"))
Date"All is a named range of numbers
if then statements06 Sep 2007 14:22 GMT6
I haven't used in forever and now need...  I have cells formatted custome as
0;-0;;@ so that if there is a 0 it won't show and become visually in the way,
but now the other problem that I need is if the cell (e9) above my cell (e10)
is equal to or lesser than the formula should ...
Lookup and return value 12 rows below06 Sep 2007 14:00 GMT5
I am trying to find a formula to lookup in a table and return the
value to the right 12 rows below. In the example below my search value
is 02-2007 and I would like to return the value 36.000 which is 12
rows below next to 02-2008.
New sub-folder in Excel using a formula06 Sep 2007 13:56 GMT1
I would like to read a cell value then create a Windows folder using the
value in the cell as the folder name
What is the furmulla to extract  Rs.44325/t06 Sep 2007 13:23 GMT2
if any one have excel functions file then please send in my email Id
narender.gupta@hotmail.com
Get all Sundays06 Sep 2007 12:01 GMT4
what I want to do is put a year in A1 and return the first Sunday day date
in cell A2. The second Sunday day date in A3. The third Sunday day date in
A4 and so on. Then all I need to do is change the year and the cells will
reload to the correct day dates. Is this possible? I am ...
Concatenation Formula needed06 Sep 2007 09:56 GMT5
I am trying to joins 2 text fields in columns a & b.
Column A is a variable field of differring lengths and characters in every
row.
Column B is the same string in every row of 7 characters long.
Rating according to 2 criteria.06 Sep 2007 09:24 GMT5
On a  spreadsheet at work, used to silent monitor incoming phone calls and
the way they are handled, we look our for 4 characteristics. Under each of
these headings are, at present, 7 items we look out for.
Everyone starts with 100% score for each characteristic and loses a point ...
IF function and wildcards06 Sep 2007 08:48 GMT6
Is it possible to use wildcards in an IF function to test a text string in a
cell.
I have a cell that could contain 2 text string options
"300 Denier Polyester" or
filtering rows depending on onother sheet06 Sep 2007 08:46 GMT3
I need help - please:
I have 2 Excel sheets:
1 – Contains all contact details (aaprx 900 rows)
2- Contains email addresses which have bounced back over the past 3 months
 
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.