|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
07-09-2008, 11:11 PM
|
|||
|
|||
|
Counting "instances" ??
Hi,
This forum has been a GREAT help so far! Now i'm wondering another thing, and I don't know if it's even possible. Say I have a column, and I want to find out how many times a certain thing occurs in that column. Like, I have aircraft tail numbers I have flown, and I want to know how many times i have flown them. Is there a way to do that?? Thanks  
|
|
#2
07-10-2008, 12:12 AM
|
||||
|
||||
|
G'day,
Yes this forum is addictive ! Try the COUNTIF formula If have trouble with formula, post back an example, and will go from there. Cheers
__________________
Office 2007 Any Feedback Welcomed You have made the effort of asking a question. Then make the effort to response to those are helpful enough to answer you.
|
|
#3
07-10-2008, 01:49 AM
|
|||
|
|||
|
I honestly have no idea how to use that formula, my knowledge is basic at best.
Basically, what I want it to do, is count the # of times, we'll say item "A" appears in a give column, and report it. Better yet, i'd like it to look at a column, and somehow generate how many times, we'll say item "A, B, and C" appear, and list that for me. For example A = 10 B = 4 C = 3 Or something. I hope this example works, obviously, the one I want to do has about 400 entries: Aircraft Ident N423RM N423RM N420RM N426RM N420RM N423RM N422RM N422RM N423RM N426RM N426RM N427RM N423RM N423RM N426RM N426RM N426RM N423RM N426RM N420RM N420RM N426RM N427RM N427RM N422RM N423RM N423RM N423RM N431RM N423RM N422RM N422RM N422RM N420RM N427RM N423RM
|
|
#4
07-10-2008, 03:05 AM
|
|||
|
|||
|
I would suggest playing around with pivot tables. They are very useful for something like this.
Under the insert tab - the first option. Set your column of data as both the Row label and Value. THis should compile all of your data into a neat little table. Let me know if you have any issues.
|
|
#7
07-10-2008, 05:41 AM
|
||||
|
||||
|
Hi,
Take a look here http://www.exceltip.com/st/Automatic...eport/738.html Or here "Refresh on Open" http://www.bettersolutions.com/excel...T423111411.htm
__________________
oldchippy -------------  Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
|
#9
07-10-2008, 06:46 PM
|
|||
|
|||
|
Ok, using the first link you gave me, I got it to work.
However, how do I get it to work with 2 different pivot tables? This is the code for the first obviously. The two tables are in the same worksheet. Option Explicit Private Sub Worksheet_Activate() ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh End Sub EDIT: I think I got it, with this: Option Explicit Private Sub Worksheet_Activate() ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh End Sub Now, anyway to make it so it doesn't always disable the macro? Last edited by THORmx; 07-10-2008 at 06:51 PM.
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
