Formula for different columns

[needinfo]

How would I write a formula that would do this:

Look in column A. For the rows that have the same number, look in those rows in column E. If those rows in E all have a same entry filled in, say yes. If not, say no.

Further explanation:
Column A will have 5 digit member ID numbers. Sometimes the same ID number will appear in several rows (if so, they will be one after another). The data in column E will be different. It will have a text/number entry, eg: A2, B4, etc... I want to know if the info in E is the same for all if its corresponding row ID numbers in A.
....for all of the same ID #'s in A, has there been a change to their corresponding info in rows in E? Or does E have all the same info per ID # ?

 

[jtakw]

Hi,

Is this what you mean.

Book1
	A	B	C	D	E	F	G
1	12345				A2		Yes
2	23456				B4
3	12345				A2
4	23456				B4
5	12345				A2
6	12345				A2
7	34567				C3
8	12345				A2
9
10	12345				A2		No
11	23456				B4
12	12345				D5
13	23456				B4
14	12345				A2
15	12345				A2
16	34567				C3
17	12345				A2
Sheet349

Cell Formulas
Range	Formula
G1	=IF(COUNTIFS(A1:A8,A1,E1:E8,E1)=COUNTIF(A1:A8,A1),"Yes","No")

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

Cross posted at: https://www.excelforum.com/excel-formulas-and-functions/1250561-formula-looking-in-different-columns.html

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.