Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: AlexandraPopa 25 ani
| Femeie 25 ani Bucuresti cauta Barbat 25 - 39 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
Search if string from range exists in cell and return value if it's not there:
=IF(SUMPRODUCT(COUNTIF([@[Nm]];"*"&$R$3:$R$8&"*"))>0;0;[@[Qty]]*0,82)
This will return 0 if cell from Nm column of the Table contains partial strings from range R3:R8.
|
|
pus acum 4 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
Source:
The following formula will return a value from J3:J20 if it finds a partial match from I3:I20 in cell D3.
F3 =INDEX(J$3:J$20;MATCH(1;COUNTIF($D3;"*"&$I$3:$I$20&"*");0))
D3 contains a long string while I3:I20 contains shorter strings, so if it finds a string from I3:I20 in D3, it will return the corresponding value from J3:J20.
Eg.
D3 contains AAAA xxx BVBC yyyy NNNM I10 contains BVBC
it will return the value of J10.
_______________________________________
|
|
pus acum 4 ani |
|