good day is there a formula for a column that will give me a value on column REMARKS. In my sample I have column G for girls and column B for boys column C is their group and column D is the remarks where I want to put a formula. if column A names is within a group Remarks will give me text "Girls", like on my example Anna Marie and Juliet is within Group A thats why remarks give me text "Girls", as you can see in my example cell A5 has no name and because it is within group a i want it also to have Girls on remarks. thanks
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | G | B | Group | Remarks | ||
2 | Anna | A | Girls | |||
3 | Marie | A | Girls | |||
4 | Julet | A | Girls | |||
5 | A | Girls | ||||
6 | Ben | B | Boys | |||
7 | Ron | B | Boys | |||
8 | B | Boys | ||||
9 | B | Boys | ||||
10 | Liza | C | Combined | |||
11 | Arthur | C | Combined | |||
12 | C | Combined | ||||
Sheet1 |