Thread
:
Counting Criteria Values with For Loop
View Single Post
#
3
Posted to microsoft.public.excel.programming
Claus Busch
external usenet poster
Posts: 3,872
Counting Criteria Values with For Loop
Hi,
Am Mon, 5 Jan 2015 02:35:21 -0800 (PST) schrieb
:
I'm attempting to count the number of A's, B's, and C's for each last name (Smith, Jones, Taylor) to make sure there are 2 of each letter for each last name. If there are more or less than 2 it displays that in Col C for each last name. Is a For loop and Nested Ifs the right way to go about this?
please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "CountingCriteria"
It is a formula solution and the values will be modified if source table
is changed.
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch