V
vane0326
I have a problen how to create a pacific formula. Look at C:14, How t
make a formula that regornize WITH PATTERN CHANGE sum C:13 then it als
sum D:8 only if it has a Code next to that value that code is in E:8 (
). I would like to run a macro for this workbook using that kind o
formula. I'm going to post the other part of this workbook with anothe
question. Oh yeah my sheet changes daily. I transfer this data from th
AS/400 to the excel workbook everyday. everything stays in the sam
collumn but the changes, meaning if the code could be in E:8 bu
tomorrow it could be in E:20 plus I have other formulas in C:13 an
C:15 if we can create all in one formula that will be great.
Thanks
make a formula that regornize WITH PATTERN CHANGE sum C:13 then it als
sum D:8 only if it has a Code next to that value that code is in E:8 (
). I would like to run a macro for this workbook using that kind o
formula. I'm going to post the other part of this workbook with anothe
question. Oh yeah my sheet changes daily. I transfer this data from th
AS/400 to the excel workbook everyday. everything stays in the sam
collumn but the changes, meaning if the code could be in E:8 bu
tomorrow it could be in E:20 plus I have other formulas in C:13 an
C:15 if we can create all in one formula that will be great.
Thanks