Return as many Y as the number of occurrence of values in another column

		Microsoft Office Forums > Microsoft Excel > Excel
Return as many Y as the number of occurrence of values in another column

11-27-2020, 05:19 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

Into C2 enter formula like

Code:

=IF(AND(OR($A2=$A1,$A2=$A3),OR(COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,1)>0,COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,2)>0)),"Y","")

, and copy down.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Picture attached. Need one column to return sum of another column.	IRHSAM	Excel	3	11-18-2017 01:21 AM
Excel / Mail Merge - Return Column Headers for All and Any Columns with Values	eduams	Mail Merge	1	09-26-2016 07:02 PM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
Return Sum value of one column from cells not blank in another column	zulugandalf	Excel	3	08-14-2014 03:37 AM
Need to search a column for a macth and return a result from a third column	pdfaust	Excel	2	02-03-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:54 AM.