How to find incident which has changed multiple priority during his life-cycle

[rkvalu]

Hi Team,

I have been brainstorming this from past couple of months. I work in reporting team and during month end I pull all incident report which has changed priority from P1-P2-P3-P4, P2-P3-P4 or P3 to P4. Currently, I am performing it manually (4000+ count). Below is the sample excel where I would highlight in a different color if priority changes from P1-P2-P3-P4, P2-P3-P4 or P3 to P4. Attached is the Spreadsheet.

So basically I want to check column A, if it has more than 2 similar value it should check the final priority in column B based on Column C's updated Date and time and it should return value as P1-P2-P3-P4, P2-P3-P4 or P3 to P4 in Column D. Any help would be appreciated.

 

[Peter_SSs]

OK, well, we can do it without a macro I believe. Try this.

Excel Workbook
	A	B
1	Number	Value
2	IMA201552	Priority 4
3	IMA201552	Priority 3
4	IMA201552	Priority 4
5	IMA201552	Priority 3
6	IMA201552	Priority 4
7	IMA212500	Priority 3
8	IMA212500	Priority 4
9	IMA222660	Priority 3
10	IMA222660	Priority 4
11	IMA226274	Priority 3
12	IMA226274	Priority 4
13	IMA226274	Priority 3
14	IMA282027	Priority 1
15	IMA282027	Priority 4
16	IMA282021	Priority 2
17	IMA282021	Priority 3
Sheet1

Formula in B2, copied down.

Excel Workbook
	A	B
1	Number	Priority Change
2	IMA201552	No Change
3	IMA212500	Priority 3-Priority 4
4	IMA222660	Priority 3-Priority 4
5	IMA226274	No Change
6	IMA282027	Priority 1-Priority 4
7	IMA282021	Priority 2-Priority 3
Sheet2