Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dear all,
i have this question:
supplier | code | date | amount | number | select1 | select2 |
1 | 465540 | 31/12/2019 | 100 | 11 | red | |
2 | 56423 | 30/01/2020 | 200 | 22 | red | |
3 | 3213 | 29/02/2020 | 300 | 33 | red | |
4 | 897 | 30/03/2020 | 400 | 44 | blu | |
5 | 32321 | 29/04/2020 | 500 | 55 | blu |
how can i select "red" in different fields? my goal is to have this issue by selecting "red"
supplier | code | date | amount | number | select1 | select2 |
1 | 465540 | 31/12/2019 | 100 | 11 | red | |
2 | 56423 | 30/01/2020 | 200 | 22 | red | |
3 | 3213 | 29/02/2020 | 300 | 33 | red |
the other problem is that i cannot modify the script. so can i create, for example, a filter?
thank you for the attention.
dear Vamsee, thank you very much for your answer. my problem is a little more complicated. see the table below
supplier | code | date | amount | number | select1 | select2 |
1 | 465540 | 31/12/2019 | 100 | 11 | aa | |
2 | 56423 | 30/01/2020 | 200 | 22 | aa | |
3 | 3213 | 29/02/2020 | 300 | 33 | ba | |
4 | 897 | 30/03/2020 | 400 | 44 | ab | |
5 | 32321 | 29/04/2020 | 500 | 55 | cc | |
6 | 52 | 31/12/2019 | 600 | 66 | dd | |
7 | 435 | 30/01/2020 | 700 | 77 | aa | |
8 | 235 | 29/02/2020 | 800 | 88 | ba | |
9 | 34534 | 30/03/2020 | 900 | 99 | ab | |
10 | 5675 | 29/04/2020 | 1000 | 110 | cc | |
11 | 87768 | 31/12/2019 | 1100 | 121 | aa | |
12 | 98 | 30/01/2020 | 1200 | 132 | aa | |
13 | 5 | 29/02/2020 | 1300 | 143 | ba | |
14 | 33 | 30/03/2020 | 1400 | 154 | ab | |
15 | 45454 | 29/04/2020 | 1500 | 165 | cc | |
16 | 7 | 31/12/2019 | 1600 | 176 | aa | |
17 | 88577 | 30/01/2020 | 1700 | 187 | dd | |
18 | 675 | 29/02/2020 | 1800 | 198 | ba | |
19 | 456 | 30/03/2020 | 1900 | 209 | ab | |
20 | 56 | 29/04/2020 | 2000 | 220 | da | |
21 | 68 | 31/12/2019 | 2100 | 231 | da | |
22 | 80 | 01/01/2020 | 2200 | 242 | aa | |
23 | 92 | 02/01/2020 | 2300 | 253 | aa | |
24 | 104 | 03/01/2020 | 2400 | 264 | ba | |
25 | 116 | 04/01/2020 | 2500 | 275 | ab | |
26 | 128 | 05/01/2020 | 2600 | 286 | cc | |
27 | 140 | 06/01/2020 | 2700 | 297 | aa | |
28 | 152 | 07/01/2020 | 2800 | 308 | dd | |
29 | 164 | 08/01/2020 | 2900 | 319 | ba | |
30 | 176 | 09/01/2020 | 3000 | 330 | ab | |
31 | 188 | 10/01/2020 | 3100 | 341 | da | |
32 | 200 | 11/01/2020 | 3200 | 352 | da | |
33 | 212 | 12/01/2020 | 3300 | 363 | aa | |
34 | 224 | 13/01/2020 | 3400 | 374 | aa | |
35 | 236 | 14/01/2020 | 3500 | 385 | ba | |
36 | 248 | 15/01/2020 | 3600 | 396 | ab | |
37 | 260 | 16/01/2020 | 3700 | 407 | cc | |
38 | 272 | 17/01/2020 | 3800 | 418 | aa | |
39 | 284 | 18/01/2020 | 3900 | 429 | dd | |
40 | 296 | 19/01/2020 | 4000 | 440 | ba | |
41 | 308 | 20/01/2020 | 4100 | 451 | ab | |
42 | 320 | 21/01/2020 | 4200 | 462 | db | |
43 | 332 | 22/01/2020 | 4300 | 473 | da | |
44 | 344 | 23/01/2020 | 4400 | 484 | aa | |
45 | 356 | 24/01/2020 | 4500 | 495 | aa | |
46 | 368 | 25/01/2020 | 4600 | 506 | da | |
47 | 380 | 26/01/2020 | 4700 | 517 | db | |
48 | 392 | 27/01/2020 | 4800 | 528 | cc | |
49 | 404 | 28/01/2020 | 4900 | 539 | aa | |
50 | 416 | 29/01/2020 | 5000 | 550 | db | |
51 | 428 | 30/01/2020 | 5100 | 561 | ba | |
52 | 440 | 31/01/2020 | 5200 | 572 | ab | |
53 | 452 | 01/02/2020 | 5300 | 583 | da | |
54 | 464 | 02/02/2020 | 5400 | 594 | db | |
55 | 476 | 03/02/2020 | 5500 | 605 | aa | |
56 | 488 | 04/02/2020 | 5600 | 616 | db | |
57 | 500 | 05/02/2020 | 5700 | 627 | ba | |
58 | 512 | 06/02/2020 | 5800 | 638 | ab | |
59 | 524 | 07/02/2020 | 5900 | 649 | cc | |
60 | 536 | 08/02/2020 | 6000 | 660 | db | |
61 | 548 | 09/02/2020 | 6100 | 671 | dd | |
62 | 560 | 10/02/2020 | 6200 | 682 | ba | |
63 | 572 | 11/02/2020 | 6300 | 693 | ab | |
64 | 584 | 12/02/2020 | 6400 | 704 | da | |
65 | 596 | 13/02/2020 | 6500 | 715 | da | |
66 | 608 | 14/02/2020 | 6600 | 726 | aa | |
67 | 620 | 15/02/2020 | 6700 | 737 | aa | |
68 | 632 | 16/02/2020 | 6800 | 748 | db | |
69 | 644 | 17/02/2020 | 6900 | 759 | ab | |
70 | 656 | 18/02/2020 | 7000 | 770 | cc | |
71 | 668 | 19/02/2020 | 7100 | 781 | aa | |
72 | 680 | 20/02/2020 | 7200 | 792 | db | |
73 | 692 | 21/02/2020 | 7300 | 803 | ba | |
74 | 704 | 22/02/2020 | 7400 | 814 | ab | |
75 | 716 | 23/02/2020 | 7500 | 825 | da |
my goal is to get a "filter" where i can select, for example, all rows "db" in fields "select1" end "select2" in the same time:
supplier | code | date | amount | number | select1 | select2 |
42 | 320 | 21/01/2020 | 4200 | 462 | db | |
47 | 380 | 26/01/2020 | 4700 | 517 | db | |
50 | 416 | 29/01/2020 | 5000 | 550 | db | |
54 | 464 | 02/02/2020 | 5400 | 594 | db | |
56 | 488 | 04/02/2020 | 5600 | 616 | db | |
60 | 536 | 08/02/2020 | 6000 | 660 | db | |
68 | 632 | 16/02/2020 | 6800 | 748 | db | |
72 | 680 | 20/02/2020 | 7200 | 792 | db |
"db" is an example, i could select "da" or any other...
Thank you averyone for your support.
Massimo.
Maybe try creating a list box with the following condition
=if(select1='red' or select2='red','Red','Others')
Attached is the sample app
dear Vamsee, thank you very much for your answer. my problem is a little more complicated. see the table below
supplier | code | date | amount | number | select1 | select2 |
1 | 465540 | 31/12/2019 | 100 | 11 | aa | |
2 | 56423 | 30/01/2020 | 200 | 22 | aa | |
3 | 3213 | 29/02/2020 | 300 | 33 | ba | |
4 | 897 | 30/03/2020 | 400 | 44 | ab | |
5 | 32321 | 29/04/2020 | 500 | 55 | cc | |
6 | 52 | 31/12/2019 | 600 | 66 | dd | |
7 | 435 | 30/01/2020 | 700 | 77 | aa | |
8 | 235 | 29/02/2020 | 800 | 88 | ba | |
9 | 34534 | 30/03/2020 | 900 | 99 | ab | |
10 | 5675 | 29/04/2020 | 1000 | 110 | cc | |
11 | 87768 | 31/12/2019 | 1100 | 121 | aa | |
12 | 98 | 30/01/2020 | 1200 | 132 | aa | |
13 | 5 | 29/02/2020 | 1300 | 143 | ba | |
14 | 33 | 30/03/2020 | 1400 | 154 | ab | |
15 | 45454 | 29/04/2020 | 1500 | 165 | cc | |
16 | 7 | 31/12/2019 | 1600 | 176 | aa | |
17 | 88577 | 30/01/2020 | 1700 | 187 | dd | |
18 | 675 | 29/02/2020 | 1800 | 198 | ba | |
19 | 456 | 30/03/2020 | 1900 | 209 | ab | |
20 | 56 | 29/04/2020 | 2000 | 220 | da | |
21 | 68 | 31/12/2019 | 2100 | 231 | da | |
22 | 80 | 01/01/2020 | 2200 | 242 | aa | |
23 | 92 | 02/01/2020 | 2300 | 253 | aa | |
24 | 104 | 03/01/2020 | 2400 | 264 | ba | |
25 | 116 | 04/01/2020 | 2500 | 275 | ab | |
26 | 128 | 05/01/2020 | 2600 | 286 | cc | |
27 | 140 | 06/01/2020 | 2700 | 297 | aa | |
28 | 152 | 07/01/2020 | 2800 | 308 | dd | |
29 | 164 | 08/01/2020 | 2900 | 319 | ba | |
30 | 176 | 09/01/2020 | 3000 | 330 | ab | |
31 | 188 | 10/01/2020 | 3100 | 341 | da | |
32 | 200 | 11/01/2020 | 3200 | 352 | da | |
33 | 212 | 12/01/2020 | 3300 | 363 | aa | |
34 | 224 | 13/01/2020 | 3400 | 374 | aa | |
35 | 236 | 14/01/2020 | 3500 | 385 | ba | |
36 | 248 | 15/01/2020 | 3600 | 396 | ab | |
37 | 260 | 16/01/2020 | 3700 | 407 | cc | |
38 | 272 | 17/01/2020 | 3800 | 418 | aa | |
39 | 284 | 18/01/2020 | 3900 | 429 | dd | |
40 | 296 | 19/01/2020 | 4000 | 440 | ba | |
41 | 308 | 20/01/2020 | 4100 | 451 | ab | |
42 | 320 | 21/01/2020 | 4200 | 462 | db | |
43 | 332 | 22/01/2020 | 4300 | 473 | da | |
44 | 344 | 23/01/2020 | 4400 | 484 | aa | |
45 | 356 | 24/01/2020 | 4500 | 495 | aa | |
46 | 368 | 25/01/2020 | 4600 | 506 | da | |
47 | 380 | 26/01/2020 | 4700 | 517 | db | |
48 | 392 | 27/01/2020 | 4800 | 528 | cc | |
49 | 404 | 28/01/2020 | 4900 | 539 | aa | |
50 | 416 | 29/01/2020 | 5000 | 550 | db | |
51 | 428 | 30/01/2020 | 5100 | 561 | ba | |
52 | 440 | 31/01/2020 | 5200 | 572 | ab | |
53 | 452 | 01/02/2020 | 5300 | 583 | da | |
54 | 464 | 02/02/2020 | 5400 | 594 | db | |
55 | 476 | 03/02/2020 | 5500 | 605 | aa | |
56 | 488 | 04/02/2020 | 5600 | 616 | db | |
57 | 500 | 05/02/2020 | 5700 | 627 | ba | |
58 | 512 | 06/02/2020 | 5800 | 638 | ab | |
59 | 524 | 07/02/2020 | 5900 | 649 | cc | |
60 | 536 | 08/02/2020 | 6000 | 660 | db | |
61 | 548 | 09/02/2020 | 6100 | 671 | dd | |
62 | 560 | 10/02/2020 | 6200 | 682 | ba | |
63 | 572 | 11/02/2020 | 6300 | 693 | ab | |
64 | 584 | 12/02/2020 | 6400 | 704 | da | |
65 | 596 | 13/02/2020 | 6500 | 715 | da | |
66 | 608 | 14/02/2020 | 6600 | 726 | aa | |
67 | 620 | 15/02/2020 | 6700 | 737 | aa | |
68 | 632 | 16/02/2020 | 6800 | 748 | db | |
69 | 644 | 17/02/2020 | 6900 | 759 | ab | |
70 | 656 | 18/02/2020 | 7000 | 770 | cc | |
71 | 668 | 19/02/2020 | 7100 | 781 | aa | |
72 | 680 | 20/02/2020 | 7200 | 792 | db | |
73 | 692 | 21/02/2020 | 7300 | 803 | ba | |
74 | 704 | 22/02/2020 | 7400 | 814 | ab | |
75 | 716 | 23/02/2020 | 7500 | 825 | da |
my goal is to get a "filter" where i can select, for example, all rows "db" in fields "select1" end "select2" in the same time:
supplier | code | date | amount | number | select1 | select2 |
42 | 320 | 21/01/2020 | 4200 | 462 | db | |
47 | 380 | 26/01/2020 | 4700 | 517 | db | |
50 | 416 | 29/01/2020 | 5000 | 550 | db | |
54 | 464 | 02/02/2020 | 5400 | 594 | db | |
56 | 488 | 04/02/2020 | 5600 | 616 | db | |
60 | 536 | 08/02/2020 | 6000 | 660 | db | |
68 | 632 | 16/02/2020 | 6800 | 748 | db | |
72 | 680 | 20/02/2020 | 7200 | 792 | db |
"db" is an example, i could select "da" or any other...
Thank you averyone for your support.
Massimo.