Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 15th 05, 08:14 PM
Sam via OfficeKB.com
 
Posts: n/a
Default Count Position of Filtered TEXT cells in a column

Hi All,

I have a column of Firstnames and would like to count their positon in the
column. If a name matches the name directly beneath it, a count of zero
should be returned. If not, a sequential count of the number of Rows away
from the last time it appeared in the list is needed.
First Row of data starts in Row 11 Column "C". Results for the returned
Count use the same Row, Column "D". The expected "filtered" Results should
count only the visible cells. The first returned count in Column "D" -
filtered or unfiltered must be zero.

Example of Unfiltered Columns:

RowNo. Sequential Count Column "C" Column "D"
11 1 Sharon 0
12 2 Terry 1
13 3 Robert 2
14 4 Sam 3
15 5 Dave 4
16 6 Sam 1 17
7 Jan 6
18 8 Sam 1
19 9 Jay 8
20 10 Robert 6
21 11 Deborah 10
22 12 Deborah 0
23 13 Sharon 11
24 14 Rita 13
25 15 Jay 5



Expected Filtered Results:

RowNo. Sequential Count Column "C" Column "D"


13 3 Robert 0
14 4 Sam 1
16
6 Sam 0
17 7 Jan 3
18 8 Sam 1
19 9 Jay 5
20 10 Robert 5
21 11 Deborah 7
22 12 Deborah 0

24 14 Rita 9


Kind regards,
Sam

--
Message posted via http://www.officekb.com

Reply
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 cells in a column that contain dates Cachod1 New Users to Excel 1 March 29th 05 08:56 PM
In a column of text data, how do I delete random cells that have . Minivann Excel Discussion (Misc queries) 2 January 26th 05 10:07 PM
How can I count cells that meet two criteria within a filtered co. lizzzy Excel Worksheet Functions 1 January 21st 05 07:03 PM
Putting text in a column based on variable text from another colum Jacky D. Excel Discussion (Misc queries) 1 December 16th 04 07:09 PM
I need to count the occurence of text in a range of cells (which . Brenda Excel Worksheet Functions 1 December 12th 04 10:00 PM


All times are GMT +1. The time now is 09:22 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017