Search results

Nebu, Thanks, your solution worked perfectly. I chose to eliminate the extra helper column by embeding the concatenate function. Marcus

Hello, I asked a simlar question on May 27th ('Extracting data from multiple worksheets') and was able to use the suggested formula successfully. Since then, I have expanded my project from consolidated income statements (IS, ie. the highest level available) to lower level deptartment IS...

Deepak, Thanks for the quick reply. The 'Address' function was key and the one I was looking for. Marcus

Hello, I have searched the forum and have not not found an answer to my question, perhaps someone here can assist. I am analyzing past monthly income statements (IS) and would like to extract certain values from all of the worksheets and put them in a summary worksheet. Each IS is on its own...

Thanks for the responses. Azumi, the array formula works great. I will see if I can understand it for other applications as well. Asheesh, The formula you provided returned the data from column A (that is, a, b, c, d, e). Any thoughts on this? Or perhaps I made a mistake. Marcus

Hello, I apologize if this was answered in another post. I have searched the forums and cannot find a solution to this question. If you can recall other posts where this was answered feel free to direct me there. I have two columns of data one of which I need to condense by excluding rows...

Thank you for responding. I do not know how to program VBA but I will try to solve the problem with it. In the meantime I created an inelegant but effective solution with a lot of helper columns, If statements and Concatenate. Marcus

Hello, Did anyone have an opportunity to consider this problem? I am still trying to sort through it. Thank you, Marcus

Sorry for the delay. I posted a cleansed, sample file to: https://dl.dropbox.com/u/95519877/Sample%20Correlation%20Matrix.xlsx I included a legend in the file to describe some of the columns, rows and cells. The desired output in column AQ which is driven by intermediate output in...

Hello, I have an array (to use a general term) of data where the X and Y axis are identical. The purpose is to identify relationship and correlation among the 30 odd categories (text values/ names). Since the axis are identical half, along the diagonal, of the cells do not contain data as this...

Luke, Your suggestion worked and the exact formula that I used is: =IF($AO$4:$AO$40>=LARGE($AO$4:$AO$40,$AQ$2),AO4,"") Where: AO4:AO40 is the reference range AQ2 is the top 'n' value desired AO4 is the value from the reference range that is returned if True "" return a 'blank' cell...

Hello, I am trying to identify the top 'n' (ie. 7, 10 etc) values in a list of data. There may be duplicates and these need to be included. Thus if I need to identify the top 10 values and there is a duplicate then 11 values need to be identified. Unfortunately the data cannot be sorted or...