copy data if two coditions are true

[pedersenn]

Hi

i want to copy data from column A on column C and two conditions are on column B

condition 1 if on column B are at list five similar and consecutive data copy data from column a on column c on same rows

condition 2 this similar dat must be specified in formula in my exmple is ex.

Please see the atachment and put formula in the file.

[José Augusto]

Try this and drag down

Please Login or Register  to view this content.

[pedersenn]

the condition is

if at list five consecutive data a prezent copy from column A on C

example

3 ex not copy becose are not at list five of ex consecutive
4 ex not copy
5 ex not copy
1 skip
2 skip
3 skip
5 ex copy 5 becose are at list five ex consecutive
7 ex copy 7
6 ex copy 6
5 ex copy 5
8 ex copy 8
7 ex copy 7

[José Augusto]

Try this in C3 and drag down

Please Login or Register  to view this content.

I suppose your data in A3:B14 and C2 is empty.

[pedersenn]

thank you

The formula worked for five consecutive "ex" but I want to work for ex>=5

[José Augusto]

Replace "*ex*" by "*ex *" , that is, put a space in front of the ex and use >=5 instead =5

[pedersenn]

I don't understand

Look at the attached file the result must be like there.

[José Augusto]

Hi
COUNTIF(B3:B7, not COUNTIF(B3:B8,

[pedersenn]

ok Mr. José Augusto thanks!