• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

buscando todos los valores ZERO y put next columna, pero valor de anterior celda

Miguel B

New Member
buscar todos los zeros de :
B con valores de A igual fila, escribirlo en columna E hacia abajo
C con valores de A igual fila, escribirlo en columna F hacia abajo
D con valores de A igual fila, escribirlo en columna G hacia abajo
Col A - Col B - Col C - Col D - Col E - Col F - Col G ……. Buscar todos los zeros y escribir los valores de la celda de la columna A , en la Columna C

[Google Translate:]
search all the zeros of:
B with values of A equal row, write it in column E down
C with values of A equal row, write it in column F down
D with values of A equal row, write it in column G down
Col A - Col B - Col C - Col D - Col E - Col F - Col G ....... Find all the zeros and write the values of the cell in column A, in Column C



1 1 0 3 2 3 2 2
2 2 1 0 0 1 3 7
3 3 0 0 1 5 8 9
4 4 0 2 4 9
6 5 2 5 2
7 6 1 9 0
8 7 1 0 6
9 8 0 5 0
10 9 1 8 1
11 10 2 1 1
12 11 4 2 1
13
14
15
 
Last edited by a moderator:
Back
Top