|
|
Drop-down Delete Multiples by
shepster
I have created a dropdown in excel 2007. This drop down contains a list of
data with many repeats, ie
A
A
A
B
B
C
D
|
|
1 |
104 |
|
|
|
|
October 26th, 2009 08:31 PM
by TimO 
|
0 |
119 |
|
|
|
Referencing a named array by
mooresk257
I have a named array "EAP" which I am using the MATCH function to find if a
value in a cell is contained in the list.
Ex. 1
=MATCH($L19,EAP,0)
The name of...
|
October 26th, 2009 08:14 PM
by Luke M
|
1 |
124 |
|
|
Linking multiple Worksheets by
Jill
I have to keep track of foundation donors. There are two different causes
that a donor can make a pledge towards. They can choose one or the other, or...
|
October 26th, 2009 08:12 PM
by Luke M
|
1 |
159 |
|
|
|
|
October 26th, 2009 07:50 PM
by toby131
|
0 |
145 |
|
|
|
Singling out searched cells by
Lycean
I'm creating a customer database, and I would like to be able to search for
values and ONLY show those that match. For instance, if I search for Apples,
I...
|
|
1 |
101 |
|
|
|
Row #s Not Advancing When I Copy Formula by
Patti Robertson
Hi All. I'm working on a spreadsheet of addresses that I have to convert to
barcode. I found a plug-in that makes barcode a font. My address parts are
in...
|
|
2 |
103 |
|
|
|
VLookup, Dynamic Range or Something else by
Ess
I am trying to create a lookup table. I have a concatenated field on two
sheets and want all the values that match that field to be populated on one
of the...
|
October 26th, 2009 07:04 PM
by Ess
|
8 |
150 |
|
|
|
|
|
2 |
120 |
|
|
|
|
|
7 |
122 |
|
|
|
Number formats switches to a date by
Diane
I have a workbook with several tabs. Some of the columns are saved a General
(so it looks like a number or numbers with letters. Other columns are pure...
|
October 26th, 2009 06:49 PM
by Diane
|
0 |
113 |
|
|
|
updating a list of messages by
Schofield
I have a numbered list of items on one sheet each number refers to an error
message through pasted link from another program. The number being sent
updates...
|
|
0 |
89 |
|
|
|
Compatibility Checker-excel by
Ron
I have Microsoft Office Home and Student 2007 recently installed. Previous
Excel work sheet was 2003. After entering data in the Excel work sheet the...
|
October 26th, 2009 06:40 PM
by Ron
|
0 |
127 |
|
|
|
Insert row disappeared by
Tia Joseph, CSp
Normally, when I work with a list, an "insert row' is displayed directly
below the last row of data, with a blue asterisk (*) inside the left-most
cell....
|
|
1 |
152 |
|
|
|
Outline(grouping) more than 8 levels by
dk96m
I have a pretty extensive Bill of Material that goes atleast 14 levels deep.
Excel only lets me go 8 levels deep. Is there anyway to go more than 8
levels...
|
|
1 |
93 |
|
|
|
Sumif problem by
Suddes
=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)
this is my formula what i need to do is divide the result...
|
October 26th, 2009 05:45 PM
by Suddes
|
6 |
132 |
|
|
|
Formula after division by
gemcauley
Need to display the gross margin as a percentage (easy enough) but after
dividing my 2 known amounts I need to subtrack several cells to get the
correct...
|
October 26th, 2009 05:07 PM
by Eduardo
|
1 |
140 |
|
|
|
|
|
2 |
112 |
|
|
|
Formula Help by
gcw
I currently have a Dept sheet summing the results from different groups. The
items that I need to capture a
Counting Weekday only
1. How many line...
|
|
2 |
101 |
|
|
|
Exel feature by
confused&lost
In Excel 2005, can a document be made that when you enter a number in one
cell a a description will fill-in on the same line for that particular
number...
|
|
3 |
191 |
