Search results

Hi The attached sheet having Sheets of Formulation and Batch card with VBA code which is giving desired results from the sheet "Formulation" according to the C4 and F4 cells value in the sheet "Batch Card". In the cell E3, I have a Date and also in the sheet formulation Column A, I have a...

Could anyone explain the below codes? Line 3, If Target.Count > 3 Then Exit Sub (What is count 3 mean by) Line 10, K = 7 (What is 7 mean by) Line 15, celda = b.Address (What is Address) Line 18 to 26 (Totally I did not Understand what it does) If you are explaining the above lines, I can...

Hi The attached sheet has a below VBA code to calculate the expected results. Here I want to understand each line of the code what it does and where it is looking the data. Because I want to rewrite the code according to my other requirements which are the similar worksheet or nearby same...

The code is working and gives desired results. Please check the attached file for your information. I do not waste others time to working on the answered post. This is what I shared the code immediately.

Hi I was trying to delete this post as I got the desired code from another forum but I did not find the option to delete it. That's why I put the code here to avoid others working on this post.

Hi I got the code as below. it is working well. Function GetData(ProductRng As Range, Criteria As String, InvoiceRng As Range, ResultRng As Range) As String Dim T As Long For T = 1 To ProductRng.Cells.Count If ProductRng.Cells(T, 1) = Criteria And InvoiceRng.Cells(T, 1) = 0 _ And...

In the attached sheet, I got multiple results in the sheet COA and cell B8, B10 and B16. To get the results I have a helper column in the sheet Master Data Column M, N and O. How can I avoid those helper columns to get the results in the sheet COA and cell B8, B10 and B16 as like now...

Thanks for your valuable reply.

Hi I have Excel workbook with a memory of 8MB which is having normal formulation, array formulation and macro codes. I saved the same file in binary format then it is reduced to 5MB. I want to determine which formula is taking more memory or what are all taking memories in the sheet. Can...

Yes, it is also working fine. Thanks

It is a macro code suggested by another forum. please check the attached file for your information.

hi The below UDF code and steps are working fine. Function MaxSpecial(DateRng As Range, Year_ As Integer, NumRng As Range) As Long Dim cel As Range Dim T As Long, TA As Long T = 1 For Each cel In NumRng If Year(DateRng.Cells(T, 1)) = Year_ Then M = Split(cel, "&") For TA = 0 To...

What do you mean by cross-posting? I never post the same question with the different name and different section. It is my opinion to create many accounts in different forums to get a better solution. Till now I did not get the answer from any forums. it is not that your given answer is...

Hi the below formula is finding the highest values =AGGREGATE(14,6,--MID(SUBSTITUTE(K8:K10921,"&",REPT(" ",30)),{1,30,60,90,120},30),1) But I need to get the results within the range of 4001 to 5000. I don't know how to include this range in the above formulation. Please suggest Thanks...

Can anyone suggest?

Also, Please find the attached sheet which is having Date. I want to find the highest value with this year entry only. I think this will help you find the highest value without defining the name ranges.

Dear Bosco Thanks a lot for your suggested formula. In the attachment sheet 2, I have used below array formula in cell K7 to find out the missing number from given the minimum and maximum value in cell Q4 and R4, Note that this formula works without defining name ranges...

Hi sometimes I need to enter a number in the format of "2097&2098&2099" in one cell. In this case, your suggested formula is not considering all three numbers to calculate the highest value. Can you please suggest another formula which can consider this kind of multiple entries too. Thanks...

Thanks a lot, Bosco!

Hi I have numbers from 1 to 100, 1000 to 3000, and 4000 to 5000 in column B. I need the highest value from the number 1000 to 3000 in cell C5. Expected answer in cell C5 is 2999. Please find the attached sheet. Can anyone help me out? Thanks in Advance.

Dear Mr Hui The below code is for your information and it is working perfectly. Sub Run_Calc() ' ' Run_Calc Macro ' ' Keyboard Shortcut: Ctrl+w ' Set myrng = Intersect(Selection.Areas(1).EntireRow, Range("S:DK")) Range("S2:DK2").Copy myrng Calculate myrng.Value = myrng.Value Calculate...

Dear Mr Hui Sorry for the delay in reply. Please check the attached screenshot and the error message for your information and further slight modification.

Dear Mr Hui Thanks a lot for your suggestion and your effort. Here I explained my observation and required details for your study. My apologies if my explanation very hard to understand. Firstly, As you said, After deleting row 28 to 32 and select I27 the macro is running (It means it will...

Dear Mr Hui This changes made nothing happen after running the macro. check the attachment and run yourself and see the result. Please modify and send as an attachment. After getting successful running, I need to implement this to nearly 10000 rows excel sheet. I hope there is no much change...

Dear Mr Hui I have added as you suggest. after running, it is pop up GO To menu and asking the cell reference. Please find the attached copy. Here I would like to request you to replace the existing code with your new code and send with attachment. So that I can easily understand what was the...