Search results

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...

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...

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...

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...

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...