Search results

Have a look at the uploaded file, you will see that I have used an extra column A for the sheet names. cheers kanti

Did you adapt or adjust the formula to suit your data/setup?. If you upload a file you will get the exact formula

Hi have a look at the attached file for an example of the INDIRECT function.

Hi Fran, Always good to know you are in good/bad company. Let us know if you need help with the VBA

Hi Fran, Sorry cannot offer any further suggestions, but I have come up against this inconsistency as well and cannot explain it. cheers kanti

Hi Kiran, change the *.xls to *.xl* in both cases cheers kanti

Hi Kiran, where is your code? kanti

Hi Fran, Here is screen shot of the Autocorrect

Hi Fran, Not sure but here are some pointers, Is it a TABLE or an array of data, with a TABLE, you may have to click on the Autocorrect arrow (Overwite all cells in the column with this formula) that appears after you enter the formula. cheers kanti

Hi Jack, It has been a long time, so please specify, what you are doing to refresh my memory and we can take i from there. cheers kanti

Hi Spencer, I was faced with a similar problem when building an Interest/Capital/Time model. I ended up using extra cell for the calcs. Look at the attached file the light blue cells are input, you can input any 3 of the variables and always get the full set of results. The solution is not...

Hi Narayan, I am not sure if this should be an ARRAY formula, it worked for me only after I converted it to an ARRAY formula kanti

Thanks Smallman. kanti

Hi Smallman, I like your code, what does the (2) do at the end of rng.Copy line?

Hi Jack, Here is a less elegant solution on Sheet 5 Hi Somendra, Confused, because beyond my capacity and comprehension.

Hi @Somendra Misra , Confused and bewildered but absolutely in AWE! kanti

Hi, I think that you should search for inventory management. kanti

Thank you for your response. Basically the macro does the following: Establish the range of the data using CurrentRegion, the number of rows and columns in the range Copy the Range to an Array Loop through the rows of the array, and in each row loop through the columns of the array and copy...

Hi Nabil, Look at this post it has a file with a Macro to do the Advanced Filter http://chandoo.org/forum/threads/generic-advance-filter.13613/ cheers kanti

Hi Vinod, I am not sure where to start, but you can use the file I sent you as it is without any modification, provided your source data is on the sheet Data as it is in the file, you then run the macro and you should get the result as per the result sheet. Once you have the results you can...

Hi Kevin, I get all except the last row that does not have ZUXXXPHRATSE This was obtained using Advanced Filter, the criteria is on the row 13&14 of the calc sheet. If you are not sure how to use the function please let me know. I will try to explain

Hi Vinod, have a look at the attached, it makes provision for a row of data to column ZZ, but that can be changed. it is important that the structure remains the same, so you will continue with LOT NO followed by Utilised Amount. It is also important that LOT NO is exactly like "LOT NO" By...

Hi Jack below is a link to a file that is an Excel Function Dictionary, with great functionality and examples of use of the functions. http://www.xlfdic.com/ cheers kanti

Try this, it rounds anything below .5 to x.50 and anything above to the next whole number =IF(MOD(A1,1)>0.5,ROUNDUP(A1,0),ROUNDDOWN(A1,0)+0.5) kanti

How do you know which is the correct value?