Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare one Column to a Second Column Formula Help Needed
This one's got me stumped so any help would be appreciated. Here's the problem, I've got one column with names in it and a second column with dates in it. What I'm trying to do is generate a count in a third column next to each name with the number of times the name appears in the name column when there is a date in the corresponding date column. If the date column is blank I want the count column to remain blank. For example: Assigned To: Number Completed Date I know that there will be repeated info but the end user doesn't care. Thanks Jeff -- jeffc ------------------------------------------------------------------------ jeffc's Profile: http://www.excelforum.com/member.php...o&userid=33452 View this thread: http://www.excelforum.com/showthread...hreadid=532622 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare one Column to a Second Column Formula Help Needed
See other thread
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "jeffc" wrote in message ... This one's got me stumped so any help would be appreciated. Here's the problem, I've got one column with names in it and a second column with dates in it. What I'm trying to do is generate a count in a third column next to each name with the number of times the name appears in the name column when there is a date in the corresponding date column. If the date column is blank I want the count column to remain blank. For example: Assigned To: Number Completed Date I know that there will be repeated info but the end user doesn't care. Thanks Jeff -- jeffc ------------------------------------------------------------------------ jeffc's Profile: http://www.excelforum.com/member.php...o&userid=33452 View this thread: http://www.excelforum.com/showthread...hreadid=532622 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula for a column | Excel Discussion (Misc queries) | |||
Excel formula needed to amounts into one column pulling from 2 col | Excel Worksheet Functions |