Wildcard in IF statement

[cpedcped]

Hey there,

I know you cant really put a wildcard in a if statement but does anyone have any suggestions to get this formula to work?
=IFERROR(INDEX(Number; MATCH(0; COUNTIF(F$14:$F14;Number)+IF(Priority<>$C$3; 1; 0)+IF(SelectedCustomer<>Customer; 1; 0); 0)); "")

I want the selectedcustomer to be wildcard.. can also set that to a single cell as its just a named cell not a range.. Only the selectedcustomer should be wildcard

Reason for this is that I want to view unique numbers for all departments of the customer by just checking the customer name.

Best regards
Christian

 

[cpedcped]

Tried out
=IFERROR(INDEX(Number; MATCH(0; COUNTIF(C$14:$C14;Number)+IF(Priority<>$C$3; 1; 0)+IF(LEFT('Page 1'!A:A;LEN($C$4))<>$C$4; 1; 0); 0)); "")

sadly didnt work, then it just showed randoms...

to explain what im trying to do.. im extracting the unique values from a column based on two criterias.. number is the named range of the numbers im trying to get.. priority is checked against selected priority and the last us customer which is selected in c4

 

[Marcelo Branco]

A small data sample (~10rows) along with criteria and expected results would be helpful.

M.

 

[cpedcped]

A small data sample (~10rows) along with criteria and expected results would be helpful.

M.

Wasnt able to add attachment so i tried my best using a table.
If possible I want the list to show unique entries from column B based on 2 criterias(SelectedCustomer in B and SelectedPriority in D)
Also if possible i want if cell below selectedcustomer is empty then dont filter based on customer and if below selectedpriority is empty then list on 1 - Critical and 2 - High... If both selectedcustomer and selectedpriority was empty then it would show all numbers that are either high or critical.


[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Customer 1[/TD]
[TD]123[/TD]
[TD]1 - Critical[/TD]
[TD]List:[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Customer 2[/TD]
[TD]1234[/TD]
[TD]4 - Low[/TD]
[TD]2222[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Customer 3[/TD]
[TD]1111[/TD]
[TD]3 - Moderate[/TD]
[TD]5555[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Customer 4[/TD]
[TD]2222[/TD]
[TD]2 - High[/TD]
[TD]1212[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Customer 4[/TD]
[TD]3333[/TD]
[TD]1 - Critical[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Customer 4[/TD]
[TD]4444[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Customer 4[/TD]
[TD]5555[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Customer 3[/TD]
[TD]6666[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Customer 3[/TD]
[TD]7777[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Customer 1[/TD]
[TD]8888[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Customer 1[/TD]
[TD]9999[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Customer 4[/TD]
[TD]1212[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]SelectedCustomer[/TD]
[TD]SelectedPriority[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Customer 4[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Canapone]

Hi

to be confirmed with control+shift+enter


=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)*(SelectedPriority<>"")+IF($B$15<>B$1:B$12;1;0)*(SelectedCustomer<>"");0));"")

The red segments should work as wildcards.

I'm using ";" as delimiters in the formula

Hope it helps

 

[cpedcped]

Hey there,

Thanks for the reply.
It shows the unique values but the wildcard doesnt work. Say I write just Custom.. It should show everything.. The reason is that we have bunch of customers that are for example custom123,custom444, customer818.. i would want to be able to write just custom to show all of them as a whole.. if that makes sense.

 

[Canapone]

Hi

an attempt


=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)+IF($B$15<>mid(B$1:B$12;1;len($b$15));1;0);0));"")

In B15 Customer # or Cust...

Regards



Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

1​

[/td][td]Customer 1[/td][td]

123​

[/td][td]1 - Critical[/td][td][/td][td]

List:​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

2​

[/td][td]Customer 2[/td][td]

1234​

[/td][td]4 - Low[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td]Customer 3[/td][td]

1111​

[/td][td]3 - Moderate[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td]Customer 4[/td][td]

2222​

[/td][td]2 - High[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td]Customer 4[/td][td]

3333​

[/td][td]1 - Critical[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td]Customer 4[/td][td]

4444​

[/td][td]3 - Moderate[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]Customer 4[/td][td]

5555​

[/td][td]2 - High[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td]Customer 3[/td][td]

6666​

[/td][td]3 - Moderate[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td]Customer 3[/td][td]

7777​

[/td][td]3 - Moderate[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

10​

[/td][td]Customer 1[/td][td]

8888​

[/td][td]2 - High[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

11​

[/td][td]Customer 1[/td][td]

9999​

[/td][td]3 - Moderate[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

12​

[/td][td]Customer 4[/td][td]

1212​

[/td][td]2 - High[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

13​

[/td][td][/td][td][/td][td][/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0)*($B$15<>"Customer"),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

14​

[/td][td][/td][td][/td][td][/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0)*($B$15<>"Customer"),0)),"")​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

15​

[/td][td]Cust[/td][td][/td][td]3 - Moderate[/td][td][/td][td]

=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<>MID(B$1:B$12,1,LEN($B$15)),1,0)*($B$15<>"Customer"),0)),"")​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Foglio1[/td][/tr][/table]

 

[cpedcped]

That worked brilliantly!

Are you able to add that if selectedpriority is not selected it will just show 2 - high and 1 - critical?

Best regards
Christian

 

[Canapone]

Hi

maybe

=[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl63, width: 64"]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;[COLOR=#ff0000]IF(LEFT(D$1:D$12)+0>2[/COLOR];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));""))[/TD]
[/TR]
</tbody>[/TABLE]

Excel 2010 32 bit
[TABLE="class: head"]
<tbody>[TR]
[TH][/TH]
[TH]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]B[/COLOR]​

[/TH]
[TH]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]C[/COLOR]​

[/TH]
[TH]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]D[/COLOR]​

[/TH]
[TH]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]E[/COLOR]​

[/TH]
[TH]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]F[/COLOR]​

[/TH]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]1[/COLOR]​

[/TD]
[TD]Customer 1[/TD]
[TD]

123​

[/TD]
[TD]1 - Critical[/TD]
[TD][/TD]
[TD]

List:​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]2[/COLOR]​

[/TD]
[TD]Customer 2[/TD]
[TD]

1234​

[/TD]
[TD]4 - Low[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]3[/COLOR]​

[/TD]
[TD]Customer 3[/TD]
[TD]

1111​

[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]4[/COLOR]​

[/TD]
[TD]Customer 4[/TD]
[TD]

2222​

[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]5[/COLOR]​

[/TD]
[TD]Customer 4[/TD]
[TD]

3333​

[/TD]
[TD]1 - Critical[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]6[/COLOR]​

[/TD]
[TD]Customer 4[/TD]
[TD]

4444​

[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]7[/COLOR]​

[/TD]
[TD]Customer 4[/TD]
[TD]

5555​

[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]8[/COLOR]​

[/TD]
[TD]Customer 3[/TD]
[TD]

6666​

[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]9[/COLOR]​

[/TD]
[TD]Customer 3[/TD]
[TD]

7777​

[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]10[/COLOR]​

[/TD]
[TD]Customer 1[/TD]
[TD]

8888​

[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]11[/COLOR]​

[/TD]
[TD]Customer 1[/TD]
[TD]

9999​

[/TD]
[TD]3 - Moderate[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]12[/COLOR]​

[/TD]
[TD]Customer 4[/TD]
[TD]

1212​

[/TD]
[TD]2 - High[/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]13[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]14[/COLOR]​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
[TR]
[TD]

[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]15[/COLOR]​

[/TD]
[TD="bgcolor: #FFFF00"]Customer 4[/TD]
[TD][/TD]
[TD="bgcolor: #FFFF00"][/TD]
[TD][/TD]
[TD]

=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)),""))​

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Foglio1[/TD]
[/TR]
</tbody>[/TABLE]

 

[cpedcped]

****, perfect! thank you!