help me to manipulate excel data

ibor · #1 02-01-2011, 02:42 AM

I need some help to gather data out of colomn from an excel file.

(opening test.xls) I need to get out data from colomn C and count out the incidence in colomn I automatically.
Fo example "faulty component " was listed twice in column C so in column I7 it must count 2. If "faulty component" should be relisted again in column C I7 must turn to 3 automatically.

Any help is appreciated!

Colin Legg · #2 02-01-2011, 02:50 AM

Welcome to the forum.

Per attachment, put this formula in cell I4 and copy down:

Code:

=COUNTIF($C:$C,G4)

This approach relies on you identifying each unique item in column C and then listing it in column G. An alternative approach would be to have A:E as a table and then to get a count of each unique item using a pivot table.

ibor · #3 02-01-2011, 03:14 AM

Thank you for your support!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to manipulate Hyperlinks	mecaton2	Word	0	10-04-2010 06:18 AM
Using Paste/Special wih Excel data	chickasaw	PowerPoint	0	02-05-2010 10:00 PM
Handling Excel Data	msofficeno475	Excel	1	01-17-2010 09:56 AM
Excel not saving all data and formatting	TRT	Excel	2	04-09-2009 12:51 PM
Refreshing Data in Excel	jamal420	Office	3	06-13-2005 03:45 PM