PDA

View Full Version : Solved: product begins with XY



danovkos
01-19-2010, 03:37 AM
Hi all,
pls. i have one question.

How can i do following?

I have sheet „source“. In this sheet i have acounts in column A, subacounts in col. B and products in col. C.
One acc. (A) can have more then one subacc. (B).

I have list of acc. in other sheet „sum“ and i want to each acc assign info, if is there in „source“ in column C for whole acc any product, which names begins with „HU“.

Please how can i do that?

This is table about 6000 rows.

lucas
01-19-2010, 09:47 AM
You will have to provide more information I think.

A sample workbook with some notes would be really helpful to anyone trying to assist you.

danovkos
01-20-2010, 12:49 AM
Here is a sample.

I think there can be a formula in sheet sum in column B2:B17 wich result will be as is it in sample.

Thank you for all your help.

Bob Phillips
01-20-2010, 02:54 AM
Try

=IF(SUMPRODUCT(--(source!$A$2:$A$23=A2),--(LEFT(source!$C$2:$C$23,2)="hu")),"YES","no")

danovkos
01-20-2010, 03:21 AM
yes,
this works perfect
thx a lot:clap:

danovkos
01-20-2010, 03:31 AM
SORRY, only one short question.
It works only for 4000 rows?
becasue if i use 4000 rows as source it works but 5000 not :(

Bob Phillips
01-20-2010, 03:37 AM
Just change the range reference to 5000 surely?

danovkos
01-20-2010, 04:18 AM
Just change the range reference to 5000 surely?
yes i changed it to 5000 but it return
#REF!
It is strange, because i change reference and till 4000 it works perfect , but after 4000 it does not :(
Can by the problem, that my table is devided with blank rows ?

danovkos
01-20-2010, 04:22 AM
SORRRY, I AM STUPID,
now i figured out, that in my column with product was one value ref(error) and this made problem.
Now it is ok.
Sorry one more time and thx.