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: 24
Default Comparing & Counting Data

I have created an Excel workbook containing several tabs. The workbook is to
keep track of a project for a social organization, Flags for Patriotism
Program. Briefly, the Flags Program posts American Flags at participating
businesses on specific holidays throughout the year. The entire project is
divided into 6 routes (A-F).

As such, I have a tab for each route. Other than the business names and
addresses, the tabs are identical to start. The user enters the name(s) of
the people that post a route into cells A4, K4, A5, and K5 (room for 4
names). Often times, one person will post more than one route.

On a "Summary" tab, I need to count the people that were involved in the
process. However, if I posted 2 of the routes, it counts me as 2 people and
lists my name twice. How can I get it to count me and list my name only one
time in a certain field on the "Summary" tab, say cell BW6?
 
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
Counting days comparing 2 dates excluding empty cells Terry Rogers[_2_] Excel Worksheet Functions 4 August 11th 08 04:27 PM
Comparing and counting occurences in 2 columns Brian Johnston Excel Worksheet Functions 2 April 14th 06 10:05 AM
comparing lists of data to remove duplicate data Tom Excel Discussion (Misc queries) 2 October 13th 05 06:16 PM
Counting values and comparing them to a single cell Tbentsen Excel Discussion (Misc queries) 3 August 4th 05 10:47 PM
Comparing Columns and Counting Mike Excel Discussion (Misc queries) 5 January 31st 05 04:55 PM


All times are GMT +1. The time now is 02:04 PM.

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"