Search results

Hi, what is the correct way to include a formula to a filled column range for example Column A is filled from A1: a38 and I want my formula to included in column A39 what should be the syntax? I'm using the following formula to identify the last row lastrow...

Hi, The following code inserts array formulas in the range (c2:AZ63) i specify and then inserts the number of blank rows after every row I need. however, my next step is where i'm stuck at to insert formulas in the blank rows created by the code. any advise? please. Thanks in advance. Code...

Hi, I'm trying to create loop for the following. Loop 1: insert 2 rows for every entry in column A Loop 2: Copy the formula in b1 and paste in b4 and then b7 and then b10 until there is an entry in column A Loop 3: a. Copy the formula in b2 and paste it in b5 and then in b8 and until there...

Thank you Narayan. Kind regards, A!

I absolutely agree with you on this Narayan. I dont know if I can send in an message directly to misra? Thanks once again. Kind regards, A!

Hi Narayan, Thank you for the clarification. I understand that you were referring to VBA only when you referred to as code but when you look in to the code of misra it picks up the column D & H, these columns have values to pick up basedon the formulas index as stated in my earlier reply which...

Hi Narayan, Thank you for sharing this thread which i think should help in a way however, i wasnt sure of the formula that has been used in column d (file of misra). does it try to pick up the reporting senior manager information? if yes, I'm not able to see the relation of the value it picked...

Hi Narayan, since there are sensitive information i wont be able to share information. However, i have tried to explain my exercise that I'm doing right now in the attached spreadsheet with some very high level sample data and I have also included a diagram which provides a visibility of the...

Thanks for this Narayan. This is something I can use as reference and work around with i guess. could this be done using vba? The reason why I'm asking is the file that i have got is more than 20000 entries and have to do loops for about 15 fields like this and that also increases the file...

Hi, I'm trying to pick up multiple results using index and match and from that create another index and match to pick multiple results. I dont know if there is a simpler solution for this. I'm also not sure how to do if there more than 10 results to show up in one cell and then replicate the...

Narayan you rock as always. thank you for solving this riddle. I was not aware that we can use round function to solve this :) made my day...thanks once again.

Hi, I'm trying to get results for a survey and the question is like this. the survery % completed by 62 participants is 48%. 10 participants out of 62 completed 63%. my question is how much the remaining 52 participants complete? can we solve it using a formula in excel? its a simple logic...

Hi, what I'm tyring to do is basically the below: 1. count for all items with cluster data 2. some items like SUV, Basic and Process will not have cluster information but they have related id's based on which I should be able to pick up information. 3. There can be situations in which a item...

Hi, I'm working on related item(s) countifs to populate information. However, I dont know if there is a easier way to show up information for the same thereby I planned to use index. Attached is the sheet with my criterian stated in i11 cell. I would be more than happy if there is an easier...

Hi Narayan, I'm working on related item(s) countifs to populate information. However, I dont know if there is a easier way to show up information for the same thereby I planned to use index. Attached is the sheet with my criterian stated in i11 cell. I would be more than happy if there is an...

Hi, Since I've a large data to work with when I use the array formula its takes a while to generate information thereby if I wanted use vba to generate results for me. However, my code gets a debugging prompt. I'm trying to populate the results in column p with the following formula of excel...

Hi, Im using the following code to convert the number stored as text to number. However, I get out of memory run-time error 7. Am I doing something incorrect here? Range("A2:BZ65000").Select 'specify the range which suits your purpose With Selection Selection.NumberFormat = "General"...

Hi Narayan, I do not have words to thank you for this effort. I was seriously stuck in this step to proceed further and I'm grateful as always, a million thanks. I was not aware that for the indirect I'd have to use "Named range" and I was using the cell header directly which was the issue...

Hi, Attached is the sheet that im working presently. 1. I was able to calculate when all the filtered information is available but as soon as one of the filtering value is not available it does not calculate. (sheet 2) 2. the sumproduct value does not actually calculate the count of values...

Hi, Yes, I use ctrl shift enter as its an array formula. Dont know what is wrong :( Kind regards, A!

Hi Narayan, Thank you for your quick update. I would like to know what if the data is another sheet? the named range should automatically pick up the formulas, isnt it? Please correct me if i'm wrong here I've updated the formula but does not show up values, dont know what am i doing wrong...

Hi Nebu, Thank you for the explanation and i know can understand why sumproduct is not picking some values. However, if I would like to include 'all' like in the pivot table, what should be done? could you suggest, please. Thanks in advance. kind regards, A!

I also realize that it takes in account of blank values of Entity type and shows up in the calculation (e.g. ID # 14 & 15)

Hi Narayan, Thank you for the quick update on the query and explaining what went wrong. However, I would like to know why does the formula does not take in to account ID # 1 - 8? which matches the criteria of a business request? Thanks in advance. Kind regards, A!

Hi, Attached is the sample data and you can clearly see the difference in data using sumproduct against the pivot in sheet 4. Please suggest why is this difference and how do can this be resolved. many thanks in advance. Kind regards, A!