|
|
|
|
2 |
143 |
|
|
Excel drop down menus by
Paetra
Alright so my question is how do you create a drop down list that once an
item is selected it will automatically fill in the rest of the information
for...
|
|
1 |
108 |
|
|
Vlookup stops working??? by
Steve Peel
I use this formula frequently and have had some trouble with it. Recently, I
opened a file that uses this formula and got a message that said "Unable to...
|
|
0 |
126 |
|
|
count function by
monkeytrader
i have a column of 3, 4, and 5 letter symbols and want to separate the data
according to numbers of letters.
ex:
abc
abcde
abcd
def
defg
ghi
|
September 19th, 2008 06:53 PM
by Mike H
|
2 |
99 |
|
|
Excel Function Help please by
TotallyConfused
Please help with this function. I am using the following function to
identify dupes in my list. "=IF(COUNTIFI(B$1:B$1000,B1)1,"DUP,"NO DUP")".
However, I...
|
September 19th, 2008 06:30 PM
by T. Valko
|
3 |
118 |
|
|
Countif excluding hidden rows by
qh8519a
I would like to count the total number of "1"s and "2"s across a range of
(b8:cu30000). I have an autofilter set up and I would only like to count the...
|
September 19th, 2008 06:22 PM
by T. Valko
|
4 |
172 |
|
|
|
September 19th, 2008 06:01 PM
by Spiky
|
0 |
122 |
|
|
Formula to find and list duplicates by
Charlotte B
I have two columns consisting of 1000 cells that each have 7 digits. For
example
8956743 8658237
8967842 8753689
8974389 8896536
These two...
|
September 19th, 2008 05:32 PM
by T. Valko
|
4 |
185 |
|
|
not sure if i'm using the right thing by
Tiffany
Hi,
I have a spreadsheet that i have entered all my data and what i would like
to do is creat dropdown menus at the top of each list so that i can easily...
|
September 19th, 2008 05:21 PM
by Tiffany
|
4 |
121 |
|
|
|
September 19th, 2008 05:01 PM
by Dennis
|
2 |
117 |
|
|
consolidate and compare workbooks in excel by
SC Diane
I have a list in excel (version 2003) with employee data that I need to match
to an insurance billing. Both workbooks have Employee names, SS#'s, Insurance...
|
|
1 |
139 |
|
|
|
|
1 |
139 |
|
|
formula help by
Shallow
For me this seem like rocket science I have a feeling it will take you guys 1
min
I am trying to build a football pool sheet
I would like to have a formula...
|
September 19th, 2008 04:29 PM
by Shallow
|
2 |
120 |
|
|
|
September 19th, 2008 04:21 PM
by Spiky
|
1 |
120 |
|
|
|
|
1 |
102 |
|
|
IF - And - Then Statement question by
MayJuneJuly
Could you help me to write and if-and-then statement?
example:
Col A Col B
C BSY
I am trying to have the statement read: IF Column A = C AND...
|
|
4 |
117 |
|
|
|
September 19th, 2008 03:23 PM
by NM
|
13 |
406 |
|
|
Vlookup Formula Help by
Gmata
I have to spread sheets with similar fields but one has ITEM number and the
other one doesn't.
I need them to match so i can have the same item number on the...
( 1 2)
|
September 19th, 2008 03:10 PM
by RagDyeR
|
11 |
209 |
|
|
ListBox Drop Down Font Size by
Phil B.
When developing a List Box using "Data/Validation" (Excel 2002), the drop
down text font is very small. How can you change this font size?
Thanks
|
September 19th, 2008 02:43 PM
by Phil B.
|
2 |
128 |
|
|
Formula by
Mark
I am having trouble with the following formula:
=SUMPRODUCT(--(RBS!A2:A9999="1/4/2008"),--(RBS!A2:A9999="31/3/2009"),--(RBS!M2:M9999="Directors...
|
|
2 |
128 |