A | B | A | B | |||||
1 | LIST 1 | List without "0" cels - NEEDED | 1 | forumula form the List 1 | ||||
2 | 0 | Johny | 2 | =if(data=true,"Mario","0") | ||||
3 | Johny | Ella | 3 | =if(data=true,"Johny","0") | ||||
4 | Ella | Johny | 4 | =if(data=true,"Ella","0") | ||||
5 | 0 | Maria | 5 | ... | ||||
6 | 0 | Annabel | 6 | ... | ||||
7 | 0 | George | 7 | ... | ||||
8 | 0 | 8 | ... | |||||
9 | Johny | 9 | ... | |||||
10 | 0 | 10 | ... | |||||
11 | 0 | 11 | ... | |||||
12 | Maria | 12 | ... | |||||
13 | Annabel | 13 | ... | |||||
14 | George | 14 | =if(data=true,"George","0") | |||||
... | ... |
<tbody>
</tbody>
Hello,
I need a formula to rearrange information in list number two eliminating cells that contain "0", as can be seen in the example in "B" column.
Ps: As I complete in the excel data sheet some values in column "A" change from "0" to the text such as "Mario".
Thank you
Last edited: