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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
IF and AND functions help required08 Apr 2007 23:46 GMT4
I need to set up a formula that will use two separate cells to provide a
text result in a third cell. The problem is that the first cell has an upper
and a lower limit to the values that influence the text output.
Here's what I'm trying to do:
fit multiple values into specific value (combinations?)08 Apr 2007 20:32 GMT4
This one is kinda hard to descibe.  I have a list of multiple values.  I need
a way to display the correct combinations of the values, each in a different
series, where the sum of each series is between x and y.   :S
Two example scenarios:
Copying cell value to master report file which is closed?08 Apr 2007 19:07 GMT3
Could someone please advise how can I achieve following task:
We have few guys in office who use excel worksheet to generate invoice for
our clients. The format of worksheet is standard for all users but I like to
generate the summary of all invoices they make.
Grouping Data in Pivot Tables08 Apr 2007 17:42 GMT1
I have recently started with Pivot tables. Below mentioned table is
the one on which I have to create a pivot table such that the average
order by a given customer/company for each furniture type in a year.
I
How to insert text table in excel spreadsheet08 Apr 2007 17:40 GMT2
I need a section at the bottom of my spreadsheet where I can type text that
will auto enter to the next line when you get to the edge just like in a text
document. Wrap text in a cell does not work because the column with stays the
same as the setting for that column above this ...
deleting takes too long08 Apr 2007 17:00 GMT1
When I delete a line or lines in a spreadsheet, it takes much too long to
complete and I am stuck waiting for the computer for 20 to 30 seconds at a
time.  How can I speed up the process?
assign button for color08 Apr 2007 16:04 GMT9
I have assigned a button with a macro for the color yellow.......
Please review the code.
Sub allow_highlight()
'
How can I create a Drop-down cell?08 Apr 2007 08:04 GMT7
I am creating an Excel worksheet for my hotel that updates the status of
Microwaves and Refridgerators in the rooms.  We only have enough for 50% of
the hotel so they move around often.  We currently scribble on a piece of
paper which rooms do/do not have micro/fridges.  This is ...
Identify last row of populated data08 Apr 2007 08:03 GMT2
Have 12 rows of linked cells,
one for each month of the year.
End of the month, data for March, for
example is updated through a link to another
find replace08 Apr 2007 04:50 GMT11
Sheet 1 contains following data
find  Replace with
krw   usd
jpy    usd
Price List and Quote Form08 Apr 2007 02:10 GMT2
I have a workbook with two tabs, one tab is my spreadsheet with item #'s,
prices, etc and the second spreadsheet is a quote form. What I want to do is
when I put in a quantity on my price list form and it calcualtes total price,
I want it to transfer that information to my quote ...
date series in PivotTables08 Apr 2007 01:43 GMT4
I often use PivotTables to count events that occur on specific dates. The
PivotTable only shows those dates that have at least one event associated
with them; however, I am also interested in seeing which dates had no events.
Is there a way to force the pivot table to show the ...
Updating Data in Validation Lists08 Apr 2007 00:22 GMT7
Is there a way to automatically update data in a validation list when the
data changes in the sourced cells?  for instance if A1 is the validation list
that display data sourced from A2, if data in A2 changes, I would A1 to
display the new data.  Currently, it does not, and only ...
Time Countif help or convert to text07 Apr 2007 22:19 GMT3
I am trying to count how many times 00:01 are in a column.
My formula is =COUNTIF(G1:H679,"00:01") but I get 0 instead of whatever the
actual count is.
Is there a way to convert the time to text? For now I have put in a new
Present value and future value07 Apr 2007 21:30 GMT6
I can't figure out the formula to get this calculator to work
http://www.smartmoney.com/retirement/now/index.cfm?story=moneylast
I've tried combining the payment and PV functions and I can get it to work
if return is 0% with some inflation rate, but I can't figure out hot to
 
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.