Search results

Hi Vinod, Are the number of columns static or can there be additional LOT NO and UTILISED AMT? cheers kanti

Somendra, that part where it shows it is working is actually an OOPs moment, I should have suppressed it

Hi Ravindra, You do not give the 3 ways you want to calculate the result, however, look at the attached it uses SUMIF to obtain the results that you have. kanti

Jack, here is an alternative to Somendra's great solution, it is VBA driven, please try it out cheers kanti

Rumshar, Please ignore your pivot table and tell us what you want to achieve from the raw data, it may be possible to use some other method to achieve your outcome. With your explanation, give some examples as well kanti

Hi Joey, please send a file together with an explanation of what you want kanti

Hi Joey, please start a separate thread for any further issues kanti

Hi Joey, Look at the attached file, it has a Worksheet_change macro, whereby if you enter Fail in any cell, the adjacent cell will be have the Formula Now() calculated and then the result will then be converted to a value.

Hi Jack, There is some confusion about your requirements, however, look at the attached file, the result is obtained by using Advanced Filter with the criteria as B1:G7 on Sheet2. This can be automated with a macro and the results can be copied and pasted elsewhere as in on another sheet if...

Hi try this: =LEFT(E2,FIND("~",SUBSTITUTE(E2," ","~",LEN(E2)-LEN(SUBSTITUTE(E2," ","")))))

Hi James, without seeing the actual worksheet it is difficult to give an answer, but you can try the following. I imagine that you can put the Slabs in a table with names or each slab and use a VLOOKUP to use the required slab and the same with the products. So you will have VLOOKUP()*VLOOKUP

Hi Jack, I am back and will re-visit this problem, as you know I had to take a break for my son's wedding. cheers kanti

Hi Wilco, That is to convert a number in text format to number format

Try dropping the Sch5, reference from the formula, in that way the formula can be copied to other sheets and will refer to the sheet it is on Kanti

Hi Jack, I do not have a computer so I cannot test, but I think you can change the extension through Rename. I tried that route on your file before but, the encryption on your files was different from that on normal protected files and coils not crack it. But try anyway Cheers Kanti

Hi Jack From the message it looks like you opened Excel more than once, this happens when you open a file by clicking on a file in the Folder. I suggest that you close all the files open Excel and then open each of the other files by using the Excel Open from the menu. Let me know if this works

Hi, Change the macro below to suit Sub getsheetnames() x = 0 For Each Sheet In Worksheets x = x + 1 y = Sheet.Name Sheets("sheet1").Range("A" & x) = y Next End Sub

In English - "All roads lead to Rome", but the more dramatic is definitely "More than one way to kin a cat"

Jack, Sounds awful, but it may be an opportunity to re-look at what you were doing and set out fresh, let me know if I can help

Hi Imla, I am not sure what you are after, do you want to Copy/Paste Values, from Wba to Wbb? kanti

Hi Jack, Welcome back and a very happy new year to you. Are you trying to add Data to the modules, you can only add code to the modules, not data kanti

Hi Diaz, Here is a calculator that I developed many years ago, you can play around with the parameters and get a list of the different results. Try it and let me know if it helps.

May all your formulas give the answer you want to see in addition to the correct answers in 2014. kanti

Congrats, always enjoy reading your posts

Hi Allyson, Have made changes to your file, please check and change formulas to suit. The formula was from the following Formula Forensic by Luke M http://chandoo.org/wp/2011/11/18/formula-forensics-003/ kanti