|
|
Formula to count duplicates by
Jane
I have a list of names in a column. Some names are duplicated. I want to
keep the duplicated names but I also want to count how many times the names
are...
|
April 22nd, 2009 03:46 PM
by Jane
|
6 |
67 |
|
|
|
April 22nd, 2009 03:41 PM
by Eduardo
|
3 |
78 |
|
|
|
April 22nd, 2009 03:27 PM
by Helmut
|
0 |
87 |
|
|
Automatic add & subtract by
BadBoy
Hello all,
I had such great success with my last question that I am going to attempt
one last question which will save me plenty of headaches if answered.
I...
|
April 22nd, 2009 03:25 PM
by BadBoy
|
0 |
63 |
|
|
Logging information by
SPISO
I am new to the depth of excel but am excited to begin navigating through it.
Could someone help me with the following questions. I sure would appreciate...
|
April 22nd, 2009 02:16 PM
by SPISO
|
0 |
63 |
|
|
LOOKUP returning wrong values by
Raghavendran
Hi,
I am using Microsoft Excel 2004 for mac version 11.3.5
I encounter strange problem of LOOKUP returning incorrect results. Following
is the simplified...
|
|
2 |
88 |
|
|
Track Changes- Working Partially by
Peter
Hi,
I came across a few cases where I am unable to track changes if I open the
file for the second time.
example: I get a workbook and I go ahead and...
|
April 22nd, 2009 12:41 PM
by Peter
|
0 |
84 |
|
|
Link to another workbook path issue by
CraigKer
I have 2 excel 2003 workbooks with links to a common workbook. In one of the
two files the path portion of the link appears to be set to the path of the...
|
|
1 |
71 |
|
|
close match by
[email protected]
Hi All,
I have two sheets ( sheet1 and sheet2)
Sheet1 Col A has Client name ( unique ) - Approximately 20,000 Rows
Sheet 2 Col A has Client name and Col B...
|
|
0 |
74 |
|
|
|
|
2 |
89 |
|
|
unique entry sum by
Gareth.Evans
sorry first post had bad formatting
Thankyou for everyone's help yesterday it was great. I have one last
thing that is bafaling me to do with the same...
|
|
0 |
75 |
|
|
Sum if unique and another criteria by
Gareth.Evans
Thankyou for everyone's help yesterday it was great. I have one last
thing that is bafaling me to do with the same thing.
I have a column in D that shows the...
|
|
0 |
65 |
|
|
insert and copy by
Darius
Hi there;
I need to insert a row between row 4 and 5 and then jump 5 rows further and
do it again (insert row between row 9 and 10) again 5 jumps and insert...
|
|
3 |
60 |
|
|
|
|
2 |
101 |
|
|
IF Function and pulling data across by
Ivan Koh
Hi would like to find out, what should the formula be like if i wanted to
pull data from cell 1 from worksheet A to worksheet B if data from cell 2 of...
|
April 22nd, 2009 08:08 AM
by Stefi
|
3 |
90 |
|
|
|
|
2 |
82 |
|
|
INDEX MIN function? by
MrRJ
Hello,
I am thinking of using INDEX function, but not quite sure how to approach it.
Here is my sample data. I need to produce the last column with a...
|
April 22nd, 2009 06:39 AM
by Bernd P
|
6 |
81 |
|
|
|
|
1 |
84 |
|
|
|
|
2 |
72 |
|
|
TURN OFF AUTO-HIGHLITE by
smd1227
Hello. After selecting & deleting multiple rows in a worksheet. Excel
automatically highlights the next rows in the quantityI originally deleted.
This is...
|
|
1 |
70 |