Search results

Glad to help you friend... Kaushik

Hi Raghu, First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here. As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and...

Hi ismailzkhan, First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here. As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this...

Hi srinidhi, As far as I know, there is no way to know if a cell contains a formula using Excel formulas only (Ninjas / experts...plz correct me if I am wrong)!! It can be done through VBA; precisely, using an UDF as follows: Public Function HasFormula(rng As Range) As Variant() Dim...

Hello Shyam, Please download the files from the below locations http://speedy.sh/XHRDs/TestB.xlsx http://speedy.sh/uaXhZ/MyFile.xlsm Instructions: 1)First link contains three files (TestA, TestB, TestC). Download these files and save them in a folder at your desktop; and name the...

Hi Josedv, Can you plz check the file here? http://speedy.sh/Vn6F4/Past-date.xlsx Kaushik

Hi prazad82, I am not very sure what exactly you are after.. Did you try this? Worksheets("your third sheet name").Protect If you are trying to lock / protect entire sheet then above piece of code would be fine. But let us know if your requirement is something different; specific to...

Glad to help you... Come back whenever needed... Kaushik

You are welcome..

Here is mine: IF INDEX MATCH ROW VLOOKUP OFFSET SUMPRODUCT SMALL IFERROR TEXT Kaushik

Hello Aks, If I understand your requirement correctly, then you are looking for the total value for each city across the months (FEB to MAY). Say your unique list of cities are from A13 to A18 as follows (and initial / parent data spread across A1 to E10): London Paris New York Tokyo...

Hello Chintan, Welcome to chandoo.org forum and we glad to have you here. I do not understand you your requirement clearly. It does not matter which side the area column is when you run the sumif formula. Say your data is as follows from Col A to Col C: 10 A 10 20 C 20 30 F 30 22 A 22...

Narayan, Thanks for clarifying....understood now. Let me take an other e.g., say today cycle time of four machines(A,B,C,D) are 10,12,5,8 (respectively). So in the first sum, we are reaching 24 hrs for the first three machines (A,B, and C) and we have remaing 3 hrs for machine C and 8 hrs...

Hi AVNSH22, Welcome to chandoo.org and we glad to have you here. Your question is not very clear to me. I have understood that: 1)A,B,C,D are the products' name and 6,8,18,32 are the respective cycle time of these products 2)Can you plz clarify what do you mean by "I WANT TO SUM UP THESE...

Hi mj29109, This post is started by Kevin with a different objective all together. We, in Chandoo.org, do not encourage cross posting. Request you to please start a fresh post with a relevant subject line. Please read first three green sticky posts at the forum page to understand how this...

Hi Kevin, Can you plz share some sample data layout to help us understand more clearly what exactly you are trying to achieve? Or, consider uploading a workbook. Kaushik

Hi manishranjan, First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here. As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this...

Hi Dhanya, I am really very sorry as your post got completely slipped out of my mind and I lost it. Can you plz download the file from here? http://speedy.sh/cUyWJ/Cosolidation.xlsm.xls However, below here is the code to consolidate the data from "Summary-1" sheet onwards.I have added...

Hi Chaitanya, First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here. As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site...

Hi Serene, Try this: =SUBTOTAL(109,b1:b10) The formula will find sum of values in visible rows only, neglect the hidden rows. If you still face any issue, please consider uploading a file here. http://chandoo.org/forums/topic/posting-a-sample-workbook Kaushik

Hi nintynine, Let me reiterate the steps again: step1: Listing down the name of the sheets and give them a named range....which you have done correctly Step2: From sheet 'mechanics' to 'Warahouse Supplie Chain' perform the same task as follows: insert a column left to the Col A (FIRST)...

Hi Pavi, I do not completely understand your requirement. Could you plz clarify the following? 1)Do you want to fetch the data from sheet1 and paste / place it in sheet 2 every 6 rows interval? 2) is there any specific criteria to pick the data from sheet1? However, could you plz upload...

Ok...that's great. Let me know in case you need any further help regarding this.. Best regards, Kaushik

Hello nintynine, Thank you for uploading the file. I will not be able to upload the file as I am posting this from office network. So please follow the instruction below: 1) Firstly, list down all the sheets name somewhere in "Central Office MasterSheet 1" (say from L2 onwards[L1 is the...

Hi stupidname, can u plz upload a workbook with sample data? Kaushik