| [COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]B[/COLOR] | [COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]C[/COLOR] | [COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]D[/COLOR] | [COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]E[/COLOR] | [COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]F[/COLOR] |
---|
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]1[/COLOR] | Customer 1 | 123 | 1 - Critical | | List: |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]2[/COLOR] | Customer 2 | 1234 | 4 - Low | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F1,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F1,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]3[/COLOR] | Customer 3 | 1111 | 3 - Moderate | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F2,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F2,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]4[/COLOR] | Customer 4 | 2222 | 2 - High | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F3,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F3,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]5[/COLOR] | Customer 4 | 3333 | 1 - Critical | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F4,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F4,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]6[/COLOR] | Customer 4 | 4444 | 3 - Moderate | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F5,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F5,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]7[/COLOR] | Customer 4 | 5555 | 2 - High | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F6,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F6,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]8[/COLOR] | Customer 3 | 6666 | 3 - Moderate | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F7,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F7,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]9[/COLOR] | Customer 3 | 7777 | 3 - Moderate | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F8,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F8,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]10[/COLOR] | Customer 1 | 8888 | 2 - High | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F9,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F9,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]11[/COLOR] | Customer 1 | 9999 | 3 - Moderate | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F10,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F10,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]12[/COLOR] | Customer 4 | 1212 | 2 - High | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F11,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F11,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]13[/COLOR] | | | | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F12,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F12,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]14[/COLOR] | | | | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F13,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F13,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]15[/COLOR] | Customer 4 | | | | =IF(D$15="",IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F14,C$1:C$12)+IF($D$1:$D$12<>$D$15,IF(LEFT($D$1:$D$12)+0>2,1,0))+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),""),IFERROR(INDEX(C$1:C$12,MATCH(0,COUNTIF(F$1:F14,C$1:C$12)+IF(D$1:D$12<>$D$15,1,0)*($D$15<>"")+IF($B$15<>LEFT(B$1:B$12,LEN($B$15)),1,0),0)),"")) |