Search results

Hui, Deepak please receive my big thank you for the help!

Hi Deepak, Thank you for your time. And how do you extend the code until the lastrow of column B? If I use this .Range("$H9:$H" & OutputLastRow2).FormulaArray = _ <-- doesn't work.

Hello Hui, Could you please provide me a sample code because I did the modification as you wrote but something is not working well. Could you see the file please?

Hello, I would need a bit help to set FormulaArray property. In my sample file (on worksheet Evaluation, column H9:H until lastrow) I would like to count the unique "Internal code" per material but I receive Run-time error 1004, unable to set the FormulaArray property of the Range Class...

Yes, this is perfect.

It is ok for me, thanks the help. But is there another way to get the result without helper column?

Hi Nebu, I checked your proposal but the result is 3 instead of 2.

Hi David, Thank you response, I used a similar formula than you in your second file, just the prodlem is that for me the formula take into account the "#". This is the reason why the expected result is 2.

Hello, Could somebody help me how to count only the numeric unique Ship-to Parties based on criteria? A1 (Criteria): 8000430 A2 (Expected result): 2 B1 Material C1 Ship-to Party 8000430 11267004 8000430 11269002 8000430 # 8000430 11269002 8000431 11267030 Thanks in advance!

Thank you the help Marc L, please receive my like.

Hi Marc L, Here is the xlsx workbook.

Hello, I would like to ask that tow to extract only those materials from sheet Data (the data stored in table) to sheet Extraction which are classed as 7920? This code is extract all columns but I need only the materials (classed as 7920). Sub Extract()...

Hi, I use XL2013 and my separator is comma.

Hi Narayan, It is strange, on my side the problem still open. Maybe I have some customizing problem with XL? PS: Do you know any other way to do the conditional formatting by vba?

Hello, I would some help regarding conditional formatting with formula. My target is to change the interior color of cell (in column L until the lastrow -the original file has some thousand rows-) if the formula is turn to "true". Unfortunately I receive "Invalid procedure or argument" error...

Hello Somendra Misra, Narayan, Your solutions are perfect for me, thank you for the help!

Hello, I would need a small help to find a date. In my sample file (the original file contains more thousand rows) I want to find the first departure date when the remaining stock is turn to negative value regarding each unique part number. I attached the expected result also. Thanks for...

I figured out, I placed the date as value in other cell and working well. Thank you the direction.

Thank you the advice but I am sad to read this because i have to handle more thousand materials (number of the materials are changing day by day) in one shot and I want to avoid that to extend the range of the formula manually. But if there is not solution... I change manually.

Hello Narayan, Thank you the file, but my problem still open. My target is to sumifs the turnover in the month (on sheet2) but due to format of the delivery date is not possible. But if I type manually the delivery date on sheet1 the formule calculate as I expect (on sheet2). Could you tell...

Hello, I would like to ask some help how is it possible to change the "Custom" number type to "Date" in dynamic range. I have attached the sample file. Thank you in advance the help.

Thank you Narayan... as always you are the best.

Hi Narayan, Thank you for your proposal.

Hi Pavan.Sada.PS, Perfect for me, thank you.

Hello, I would like to ask some help regarding duplication checking. In my sample file I check that first if: the material number is the same, the storage location is the same, the posting date is the same, the posted quantity is the same, then the formula is turn to "Duplicated entries" in...