G
Greegan
consider I have a 24 lines of data
i receive a file that updates the current 24 lines of data
column C is the original data
column B is the numbered lines of the 24 rows which needs to be separated
from the file
I just want a formula that would add an astrisk (*) on any row where a
number in column B exists in column C.
is this possible?
I'm hoping i can do this with only a formula
help is appreciated
B C
1 1
3 2
4 3
5 4
7 5
8 6
9 7
11 8
12 9
13 10
15 11
16 12
17 13
18 14
20 15
21 16
23 17
24 18
19
20
21
22
23
24
i receive a file that updates the current 24 lines of data
column C is the original data
column B is the numbered lines of the 24 rows which needs to be separated
from the file
I just want a formula that would add an astrisk (*) on any row where a
number in column B exists in column C.
is this possible?
I'm hoping i can do this with only a formula
help is appreciated
B C
1 1
3 2
4 3
5 4
7 5
8 6
9 7
11 8
12 9
13 10
15 11
16 12
17 13
18 14
20 15
21 16
23 17
24 18
19
20
21
22
23
24