|
|
Compare 2 Worksheets & Find Matches by
Mark
Can anyone tell me how to compare 2 worksheets and where
there is an exact match of text in a cell to return a list
of matches? Or in someway highlight the...
|
|
1 |
529 |
|
|
filtered list by
Pam Coleman
If I have done an advanced filter from a Master db and
filtered a list of juveniles within a 3 month period, and
in that list some of the juveniles are listed...
|
September 15th, 2003 05:29 PM
by Lance
|
1 |
409 |
|
|
#N/A by
Bob Phillips
thanks bob..that did it..thanks for taking time to help
-----Original Message-----
Steve,
=IF(ISNA(vlookup_formula),0,vlookup_formula)
--
HTH
|
|
0 |
443 |
|
|
Comparing ranges by
ibeetb
I would like to compare Range A and Range B and then be able to identify or
write out the items in A that re NOT in B.
Keep in mind,, that range B has unique...
|
September 15th, 2003 05:20 PM
by john
|
1 |
391 |
|
|
Networkdays calculations by
Linda
Everytime I enter the formula, =networkdays(l5,k5) to
calculate how many days an employee will receive his/her
new rate of pay for the new fiscal year, it...
|
|
2 |
390 |
|
|
Formatting Column with all Caps by
Dean
Is there anyway to format a column to take data from
another column and convert it to all caps? I can get the
data from another column but can't seem to get it...
|
September 15th, 2003 05:06 PM
by Andy B
|
1 |
375 |
|
|
Extract a number from a cell of text by
pnoel
I am trying to find out what formula I would use to
extract the number from the following cell:
Numer of items in truck,13625.
Then place the number in...
|
|
2 |
875 |
|
|
Selecting from a list by
Mike
I want to be able to select from a list based on the contents of
another cell.
For example, in A1 I can select the value from a list of 4 options.
Cell B1 has...
|
September 15th, 2003 04:46 PM
by Anon
|
1 |
1,181 |
|
|
excel.exe program error by
Dawn
I have a spread sheet that I'm running macro's in, and it
keeps coming up with the error message
"excel.exe has generated errors and will be shut down...
|
|
1 |
1,028 |
|
|
Pivot range update on mulitple tables by
aablank
I am using the same range for a number of pivot tables. If
I add to the data, is there a way to update all of the
tables at once? Right now I need to update...
|
September 15th, 2003 04:12 PM
by aablank
|
0 |
1,140 |
|
|
VLOOKUP problem by
Crystal
I'm using the VLOOKUP worksheet function and I'm having
some issues with the result affecting my other formulas.
Instead of the lookup returning "#N/A" when it...
|
September 15th, 2003 04:03 PM
by Anon
|
1 |
986 |
|
|
Excel "IF" function problem by
Johan
Our domain uses group policy to configure user rights on
the workstations, and it appears that on certain machines,
or rather under certain user profiles, the...
|
September 15th, 2003 03:08 PM
by JM
|
2 |
1,214 |
|
|
Notes by
Pinda
Is it possible to have a note attached to a phrase rather
than a cell?
So where ever that phrase may be duplicated within a
worksheet, it will carry the same...
|
|
1 |
1,043 |
|
|
Excel column headings by
Wayne
EVery time I open EXcel for a new worksheet, the columns
are shown as numbers, the same as the rows. How do I
change it so that they are letters? Makes it much...
|
September 15th, 2003 03:01 PM
by Andy B
|
1 |
1,011 |
|
|
Combo Box & Linked Workbooks by
D B
I have two questions:
1. Drop Down Boxes: Is there a way to actually convert a
cell(s) to be a combo box? The only way I have been able
to achieve this is...
|
|
1 |
1,241 |
|
|
Numbering rows for sorting by
Dan
If i understand you correctly try this:
Say you want your numbers from A1 to A1000
In A1 input the number 1.
In A2 input the number 2.
Hilight (select just...
|
September 15th, 2003 02:08 PM
by Andy B
|
1 |
983 |
|
|
sumif function by
Dee
I am trying to use sumif function to add up a range in
excel using color as "CRITERIA". Is this possible? or is
there another way to go about it? Thanks.
|
September 15th, 2003 01:24 PM
by JMay
|
5 |
1,111 |
|
|
Time-of-day Average by
GBL
Hi:
Cell designations are H8:H51.
I used your entire formula. But didn't understand where you got the "hhmm"
designation.
My military-time cell examples a...
|
|
2 |
1,043 |
|
|
split worksheet by
patrick072040
Can you split a worksheet in half vertically, but scroll vertically on
both?. For example, have cells j1..l8 stay put, when scrolling up cells
a1.I100 ?
It...
|
September 15th, 2003 01:00 PM
by Jim Rech
|
3 |
1,355 |
|
|
|
|
1 |
1,167 |