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: Mariatha
| Femeie 25 ani Prahova cauta Barbat 25 - 52 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
I need helper columns in the base data for my Pivot table. My base data is a Table and I need to look for 1 of two key words in a range of that Table, so I created a helper column and added the following formula that is searching for either the word "steel" or the word "inox":
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"steel";"inox"};[@[Description]])))>0;"Steel / inox";"") |
If you have multiple strings you need to search and return different results, you can transform the IF formula above into IFS (you can write the formula as is below, or put it all on 1 line):
=IFERROR( IFS( SUMPRODUCT(--ISNUMBER(SEARCH({"steel";"inox"};[@[Description]])))>0;"Otel / inox"; SUMPRODUCT(--ISNUMBER(SEARCH({"alama"};[@[Description]])))>0;"Alama"; SUMPRODUCT(--ISNUMBER(SEARCH({"aluminiu"};[@[Description]])))>0;"Aluminiu"; SUMPRODUCT(--ISNUMBER(SEARCH({"cupru"};[@[Description]])))>0;"Cupru"; SUMPRODUCT(--ISNUMBER(SEARCH({"bronz"};[@[Description]])))>0;"Bronz") ; "") |
Then in the Pivot table I can use the results for that column.
Source:
|
|
pus acum 7 luni |
|