Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-01-2011, 02:42 AM
ibor ibor is offline help me to manipulate excel data Windows 7 32bit help me to manipulate excel data Office 2007
Novice
help me to manipulate excel data
 
Join Date: Feb 2011
Posts: 2
ibor is on a distinguished road
Default help me to manipulate excel data

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!
Attached Files
File Type: xlsx test.xlsx (12.2 KB, 13 views)
Reply With Quote
  #2  
Old 02-01-2011, 02:50 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline help me to manipulate excel data Windows 7 32bit help me to manipulate excel data Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Attached Files
File Type: zip test(1).zip (9.4 KB, 15 views)
Reply With Quote
  #3  
Old 02-01-2011, 03:14 AM
ibor ibor is offline help me to manipulate excel data Windows 7 32bit help me to manipulate excel data Office 2007
Novice
help me to manipulate excel data
 
Join Date: Feb 2011
Posts: 2
ibor is on a distinguished road
Default

Thank you for your support!
Reply With Quote
Reply

Thread Tools
Display Modes


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
help me to manipulate excel data Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
help me to manipulate excel data Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft