July - UK Excel User Conference
目前分類:title (4957)
- Oct 18 Sat 2008 20:46
July
- Oct 18 Sat 2008 20:46
putting in a sum finction
- Oct 18 Sat 2008 20:46
Index function using multiple values in one cell
I have data that I have been categorizing into multiple categories.
What I would like to do is put all the of category types in one cell
- Oct 18 Sat 2008 20:46
Option Button
I have been asked to do a form in Excel and one portion of the form requires
a simple Yes or No answer. The best way of doing this I thought was giving
- Oct 18 Sat 2008 20:46
Comparing values of two spreadsheets
- Oct 18 Sat 2008 20:46
multiply A by 1000 record results in B
how do I multiply the values in column A by 1000, and put the results in
column B
- Oct 18 Sat 2008 20:46
IF(D2=quot;Paidquot;,quot;quot;,IF(C2=quot;quot;,quot;quot;,IF(TODAY()lt;C2,quot;quot;,IF(TO DAY()-C2gt;14,quot;Ove
I'm using this formula to show quot;paid,Due or Overduequot; invoices. Is there a way
I can keep the same basic formula but change the Font on OVERDUE RED?
- Oct 18 Sat 2008 20:46
Another Conditional Formating Question
- Oct 18 Sat 2008 20:46
conditional fomatting
If cell A2 contains todays date (using the NOW() formula) how do I get the
contents of A1 to be displayed either in bold and/or different colour?
- Oct 18 Sat 2008 20:46
Solver question
I can't seem to solve this problem. I am setting up a bonus program for our
sales people. Each sales person sells 3 products (A, B and C.) Management
- Oct 18 Sat 2008 20:46
Convert $ amount from excel to access? No decimals but 00 at end
I am trying to export dollar amounts from excel to Acess. Access does not use
decimals so I need to remove the decimals from the cells in Excel but add the
- Oct 18 Sat 2008 20:46
How do I get rid of a 2nd instance (xls:2)?
I have a spreadsheet. Whenever I open it, 2 copies open -- name.xls:1 and
name.xls:2. If I close one, both close. Driving me crazy, it is. It must
- Oct 18 Sat 2008 20:46
Returning all values
- Oct 18 Sat 2008 20:46
the format data
- Oct 18 Sat 2008 20:46
Pivot Tables are Automatically refreshing
Can anyone tell me where I might be able to find an answer about automatic
pivot table refereshes in Excel 2002? I have a spreadsheet that is
- Oct 18 Sat 2008 20:46
lookup in MATRIX
- Oct 18 Sat 2008 20:46
How can i reverse saving an excel spreadsheet.
I have made an incorrect save to a spreadsheet, therefore losing previous
data that i need. How can I reverse this? I have not set up track changes
- Oct 18 Sat 2008 20:46
formula to lookup amp; sum totals, given a start inv.# amp; finish inv.#
I have a worksheet containing the total of each invoice amp; then that gets
divided by two and placed into two seperate columns. I would like to retrieve
- Oct 18 Sat 2008 20:46
How to make a schedule
How can I make a schedule for basketball using Excel? I need it over 9
or 10 weeks with a bunch of different teams. Thanks.Hi, have you tried the ones that are already published on the microsoft