LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Count Text Values in a filterd column

I need a running count at the top of a column of single text vaules in a
column once sheet has ben filtered.

eg: need running count of number of W's if I filter by pairs 1 to 5 only.

Cable Pair # Type Status
NHI 1 1 ** W
NHI 1 2 ** W
NHI 1 3 ** W
NHI 1 4 ** S
NHI 1 5 ** W
NHI 1 6 ** W
NHI 1 7 ** F
NHI 1 8 ** S
NHI 1 9 ** W
NHI 1 10 ** S
NHI 1 11 ** F
NHI 1 12 ** W
NHI 1 13 ** S
NHI 1 14 ** S
NHI 1 15 ** S
NHI 1 16 ** S
NHI 1 17 ** W
NHI 1 18 ** S
NHI 1 19 ** S
NHI 1 20 ** W
NHI 1 21 ** S
NHI 1 22 ** S
NHI 1 23 ** S
NHI 1 24 ** S
NHI 1 25 ** S
NHI 1 26 ** S
NHI 1 27 ** S
NHI 1 28 ** S
NHI 1 29 ** S
NHI 1 30 ** W
NHI 1 31 ** W
NHI 1 32 ** W
NHI 1 33 ** S
NHI 1 34 ** S


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count entries in one column based on values in another column Kurt Excel Worksheet Functions 7 January 10th 07 09:29 PM
How to count certain values in a column Mark Corbett Excel Discussion (Misc queries) 3 August 23rd 06 03:56 PM
Count Text Values in Column Karl Burrows Excel Discussion (Misc queries) 7 August 3rd 05 04:23 AM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
Can I count values in column 1 if criteria in column 2 are met confounded office user Excel Worksheet Functions 2 November 9th 04 12:02 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"