I want my footer to say Damp;T, but instead it says D2:55PM. How do I turn off
the concatenating text?
目前分類:title (5957)
- Mar 09 Fri 2007 20:36
Concatenating text
- Mar 09 Fri 2007 20:36
Finding a match and adding to the statement
I'm using the formula:
=IF(MATCH(C51,'Data Sheet'!A4:A103,1),quot;Added Holiday(s) For:quot;,quot;quot;)
- Mar 09 Fri 2007 20:36
Navigating in filtered rows
- Mar 09 Fri 2007 20:36
Error using Advanced Filter Unique Records
Have a list of 1000 rows of data (countries). Use the adv filter unique to a
new region but still get duplicate values for US and a 'salesperson'. Tried
- Mar 09 Fri 2007 20:36
Modified grouping help
- Mar 09 Fri 2007 20:36
How do I identify blank cells?
Just learning here. I am trying to identify blank cells and to remove the
rows containing them to another sheet. I have played around with the
- Mar 09 Fri 2007 20:36
Random Item
- Mar 09 Fri 2007 20:36
minus sign
- Mar 09 Fri 2007 20:36
If statements and Dates
Hello,
I need to flag milestone yrs of service for our employees.
- Mar 09 Fri 2007 20:36
Change Cell properties by Function
Hello,
- Mar 09 Fri 2007 20:36
In Excel, how do you move the contents of 3 cells into 1 cell?
Excel 2003: What is the formula for moving the contents of 3 cells, A1:C1,
into 1 cell, E1?
- Mar 09 Fri 2007 20:36
Quick Question
Hi all,
- Mar 09 Fri 2007 20:36
Excel: Using DSUM, I need to evaluate 2 criteria that are not toge
The CRITERIA field in DSUM looks for adjacent columns in a table. If a column
or cell is blank, it does nothing.
- Mar 09 Fri 2007 20:36
what is perequi function?
i've found quot;=H7*perequiquot; inside a cell and it gives me the number from the H7
cell.
- Mar 09 Fri 2007 20:36
Leave cell blank if no data
Excel Experts,
- Mar 09 Fri 2007 20:36
amp; help with date format
Hello and thanks for the help.
- Mar 09 Fri 2007 20:36
Data Generation
- Mar 09 Fri 2007 20:36
How do I put my spreadsheet in numerical order?
I looked at the directions for some of them. I don't have unhide highlighted
in my windows menu. What do I do?
- Mar 09 Fri 2007 20:36
Template Creation
I have the responsibility of generating a daily report via a text file that
is updated nightly. I want to have a template that would remain formatted
- Mar 09 Fri 2007 20:36
Template Wizard with Data Tracking
I have been able to set up a form and datbase with the template wizard. The
only problem is that it only captures data from one column. Example below: