Hello there,
I would like some help, i don't know if i can use formulas or if i should use VBA.
What i want is, to excel to find a the first line on the column b with name and return that name on the column j, i am thinking about the IF formula to assign a chief of the family, but the range would be dynamic regarding to lines.
suggestions?
I would like some help, i don't know if i can use formulas or if i should use VBA.
What i want is, to excel to find a the first line on the column b with name and return that name on the column j, i am thinking about the IF formula to assign a chief of the family, but the range would be dynamic regarding to lines.
suggestions?
FOLHA ASS 2022 m03 03-02-2023.xlsm | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
41 | ||||||||||||
42 | 168 | GUILHERME ERNESTO BARBOSA DE LOUREIRO | 706/01 | 01/07/1996 | 09510416657 | FU/DC | M | GUILHERME ERNESTO BARBOSA DE LOUREIRO | ||||
43 | sem comorb. | |||||||||||
44 | sem comorb. | |||||||||||
45 | ||||||||||||
46 | 169 | RITA DE CASSIA BATISTA CAROLINO | 706/04 | 29/08/1978 | 700003251529301 | CA/SM/DC/DOMC | F | RITA DE CASSIA BATISTA CAROLINO | ||||
47 | FABIANA VIEIRA SOARES | 26/12/1998 | 700906940831696 | PUERPERA | F | |||||||
48 | MARIA EDUARDA SOARES | 30/03/2011 | 702605296732249 | sem comorb. | F | |||||||
49 | THIAGO SOARES DE MORAES | 04/04/2019 | 708207191367642 | CRI | M | |||||||
Folha de Assinatura |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J42,J46 | J42 | =B42 |