|
Drop Down Menu help
I am putting together a spreadsheet for a Bowl Pick'Em league. I am trying
to have a column for confidence points that has a drop down list in each cell
with the option to pick from 1-34. I have figured out how to have a list
that allows you to pick from 1-34, but what I really need to figure out is
how to make it to where I can only select each number one time. For
instance, if I cho...
|
2 |
12/19/2008 1:18:02 PM |
|
|
Question about dynamic ranges
Hi All,
I'm using some dynamic ranges on an excel file I'm working on. One range has
a problem though. The column contains fomulas and the default result is a
blank. When I reference this range, it also takes in the blank values. This
is impacting some other fomulas on the file. Is there a way I can modify the
range to exclude blanks?
This is how the range is defined.
=Application...
|
5 |
12/19/2008 1:02:06 PM |
|
|
Excel 2007 and earlier versions when tracking changes
I am tracking changes with 2007 and earlier versions of Excel. when changes
are made and before they are reviewed and accepted a duplicate file is
created. After the changes are reviewed and accepted can i delete these
files from the directory? The file name appears to be HEX and the extension
displays as File. ...
|
1 |
12/19/2008 12:57:03 PM |
|
|
Number Formatting help
I have a series of part numbers in an excel spreadsheet
They should be 12 digit numbers
however some of the numbers are displaying , apparently at random, in
scientific notation as exponents. If I click on the number in question it
displays normally in the formula bar but the cell is scientific notation. I
have formatted the whole column and it still seems to happen at intervals.
Any su...
|
4 |
12/19/2008 12:47:47 PM |
|
|
How to paste grouped rows without copying over the detailed items?
I would like to copy & paste only the summary grouped line but not the
detailed information. If you select "Paste Special, Values" the grouped
items expand but I only want the summary line and not the detailed lines
below.
Is there a way to copy and paste only the grouped information and exclude
the details below? ...
|
2 |
12/19/2008 12:34:00 PM |
|
|
Maximum tabs in Excel?
I need to import a large amount of data (of unknown size) into Excel.
Each item of data needs to go on a new tab - and when attempting the import
it is erroring.
What is ther maximum number of tabs I can create in an Excel spreadsheet?
many thanks...
|
5 |
12/19/2008 10:16:02 AM |
|
|
double quotes used in cell
Hi,
I am trying to trace an error while importing excel file. It shows one of
the enum values has a space. This is shown while I import it through another
application (Axapta). My excel sheet has some hidden rows which uses double
quotes along with some value/name within it. what exactly does this mean? for
e.g: "53".Is this some constant? Where can I get its value? I need to edit
th...
|
2 |
12/19/2008 10:02:23 AM |
|
|
Conditional Formatting
Hello,
I did search this question but could not find an answer.
If I want to format f6 only when there is data in a a6: what formula do I
enter?
Thank you...
|
5 |
12/19/2008 9:27:50 AM |
|
|
i want to email a spreadsheet in excel to another person
i cannot find where to email an attached excel sheet...
|
2 |
12/19/2008 9:26:31 AM |
|
|
Time Sheets
I am trying to set up a roster/time sheet that will give me my expected gross
wages for the week. I am having trouble because staff are finishing at 1am or
2am and i'm not sure how to calculate the hours worked using a formula. I am
just getting #### because it is a negative number. eg 17:00pm - 1.00am.
Thank you in advance...
|
4 |
12/19/2008 9:20:45 AM |
|
|
Topics on Electronics
Electronics is the field of manipulating electrical currents and
voltages using passive and active components that are connected
together to create circuits. Electronic circuits range from a simple
load resistor that converts a current to a voltage, to computer
central-processing units (CPUs) that can contain more than a million
transistors. The following indices and documents provide a basic...
|
1 |
12/19/2008 7:59:17 AM |
|
|
Topics on Electronics
Electronics is the field of manipulating electrical currents and
voltages using passive and active components that are connected
together to create circuits. Electronic circuits range from a simple
load resistor that converts a current to a voltage, to computer
central-processing units (CPUs) that can contain more than a million
transistors. The following indices and documents provide a basic...
|
1 |
12/19/2008 7:59:02 AM |
|
|
LOOK UP/VLOOKUP
Dear All,
Can you help me with the LOOK UP/VLOOKUP function?
Let me explain my requirement clearly.
In sheet 1, I have data with several columns which is entered manually
everyday. In the sheet 2, I would be requiring only the data mentioned in
selected columns.
For example if I enter a date in a particular cell in sheet 2 (say B2), the
selected column data with respect to that d...
|
7 |
12/19/2008 5:20:01 AM |
|
|
COPY MULTIPLE ROWS INSERTED BELOW EACH
How can I copy all selected rows to insert each directly below without
individually copying then inserted each row one at a time?
Essentally I need ROW 1, 1, 2, 2, 3, 3, 4, 4, etc.? (I know the rows will
be in numerical order)
Thanks....
|
6 |
12/19/2008 4:48:01 AM |
|
|
If Then
How do I write a formula that will return an x if a range of cells have any
data?
For example I would like A1 to return X, if any of the cells in B1 through
P1 have any data in them.
Thanks...
|
3 |
12/19/2008 3:18:39 AM |
|
|
Pivot table page field filtering
I have a pivot table with multiple iteam in the "Page" area. Two of them are
Account Manager & Customer Name. When I select a specific Account Manager it
still shows all the customer names for all of the account managers. Is there
a way in a pivot table to select an Account manager and the Customer Name
would be specific to that account manager instead of all of the data? I
cannot move e...
|
3 |
12/19/2008 1:47:01 AM |
|
|
Is Paste Special HTML broken in Excel/Office 2007?
In older versions of Office, I was able to copy/paste HTML tables into Excel
(and Word), and have the format preserved... most importantly, the data
pasted in rows and columns exactly as seen in the HTML version.
In Office 2007, however, HTML tables paste in one cell in Excel (or one long
text string, in Word). Even if I use Paste Special and choose HTML, all the
data ends up in one ...
|
2 |
12/18/2008 11:42:13 PM |
|
|
How can I find external data query name
Hi -
I have a worksheet that imports external data from SQL Server. The SQL
Server has several Views that are used to populate the different worksheets
on the workbook. How can I identify the View name for a particular tab?
Simply put, I'm trying to identify the source code for external data.
Regards - Mark
...
|
4 |
12/18/2008 11:09:01 PM |
|
|
prevent the over-write
I have a public workbook that is updated by other users. One of the
worksheets is being deleted. I have protected the worksheet but that didn’t
solve the problem. I believe someone is coping the workbook to a local drive
or some other location, deleting the worksheet and then overwriting the
original workbook. I can prevent the file from being deleted with special
permissions but I...
|
6 |
12/18/2008 11:06:00 PM |
|
|
Return names which are repeated 5 times
Hi,
I will try my best to explain this problem.
We have a running report. Weeks in columns...(Jan week 1, Jan week
2.......December week 4). In these columns we have names of people who
acheived 100% target in that particular week. Now we need 3 kinds of
information from this report.
1. Who acheived 100% in the week. This is done just by pasting names in the
column
2. Who is a co...
|
3 |
12/18/2008 10:54:04 PM |
|
|
More Help with Conditional Formatting
I now have it sort of working with this formula:
=IF(AND(L7<(A1)-L7>60),"Pending",IF(AND(L7>(A1)-L7<180),"FollowUp",IF(L7>=(A1),"Completed",0)))
My problem now is that it isn't calculating the dates correctly it is
showing all cells as being "pending" (i.e. when I put in the date 1/2/2006 it
is still showing as "pending" instead of "completed").
I also would like to see ...
|
9 |
12/18/2008 10:54:01 PM |
|
|
How do I get hyperlinks created in Excel to work in a PDF?
When I create hyperlinks in Excel and then save or convert the file to a PDF,
the hyperlinks don't work in the PDF. The links display, but they do not work
as links. Any suggestions? Thanks....
|
4 |
12/18/2008 10:48:20 PM |
|
|
remove dashs from social security numbers
is there a way to remove dashs out of the social security number is excel
spreedsheet...
|
5 |
12/18/2008 10:48:01 PM |
|
|
Cumulatively list data from each new worksheet
I have a very simple system for generating invoices where I have one
worksheet as the invoice template, and then for each new invoice I copy that
template to a new worksheet, rename that worksheet with the new invoice
number, and use a formula to copy that sheetname to the relevant "InvoiceNo."
cell on the new worksheet. In other words, each invoice is a separate
worksheet, with the invo...
|
2 |
12/18/2008 10:44:06 PM |
|
|
countif, multiple value range PLEASE HELP
I have a set of data where I want to count some values with a range of
different outcomes:
a b c d
a a c e
0 = COUNTIF(A2:D2,OR(A1,B1,C1,D1))
3 <-- Answer I want to get
The Bottom answer is what I want to get
The Top answe is what I am getting
Is there a way of doing this without doing a long formula such as:
= COUNTIF(A2:D2,A1)+COUNTIF(A2:D2,B1)+COUNTIF(A2:D2,C1)+COUNTIF(A2...
|
3 |
12/18/2008 10:46:53 PM |