Originally Posted by
comprendrien
So Should I put manually a =IF(A26<MAX($A$4:$A$21),A26+1,"") like formula for each product in compagny A, B, C..and it will automatically pulldown the list in "country"? or should I have to manually put the name on each product in the "country" part ?
I currently have a loooooooooooooooooooooooooT of product and my problem is that I cannot search the product on by one in each compagny....and if I simply copy paste it I will have 15-16 time the same product each time.....
Have you tested the file? Try to replace one item in A or B company and see what happen in "country"?
What the only things your have to do are:
* Make sure the data of company A->Z is coverred ALL in MAX function. (i.e line 4 to 21 in example)
* Type below code once in A5 only and copy down to last line of Z company. Kindly replace the old with:
Make sure the C column, btw the 2 company tables are left blank or non numeric cells. Because I use C column to guide the function to be filled down automatically.
* Last, take a hot coffee cup.
Tks for your feedback,
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks