Prev: Maintain lowest value in an "external connection" cell
Next: excel conditional formatting
From: srg_rector on 30 Mar 2010 18:35
I went to the page you linked:
http://office.microsoft.com/en-us/excel/HA012260381033.aspx

The page referred to the command: enter the following array formula
(CTRL+SHIFT+ENTER)
However, nothing happened when I pressed those keys together. The formulas
could not be entered without Excel saying there were errors in them.

What is this (CTRL+SHIFT+ENTER) ???


"Gary''s Student" wrote:

> The general idea is to first identify all the rows to be extracted and
> extract the data. Something like VLOOKUP() (as you are aware) will find
> first the FIRST occurance on data like "GNP" on the Main sheet and return the
> associated data, but you need all the rows matching "GNP"
>
> See:
>
> http://office.microsoft.com/en-us/excel/HA012260381033.aspx
>
> for a description of the techniques to accomplish this.
> --
> Gary''s Student - gsnu201001
>
>
> "srg_rector" wrote:
>
> > I am using Office 2003. I have a large Excel data file that I need to pull
> > specific info from.
> >
> > I want to be able to have a worksheet that automatically pulls
> > specific/limited data from the Main Worksheet to a number of Result
> > Worksheets. There can be no blank rows in the Result Worksheets. The
> > result worksheets can have ONLY the data from Columns M-Q in them.
> >
> > I have looked at: lookup, vlookup, index, match, and other functions, but I
> > cannot figure out how to get this to work.
> >
> > The NGP/CNF/CNT codes will not be grouped in the Main Worksheet; the Main
> > Worksheet MUST be sorted by Date: Descending.
> > The Result Worksheets must update themselves whenever the Main Worksheet
> > data changes.
> >
> > Result Worksheet NGP:
> > Criteria to select data record: Main Worksheet Column G must have the text
> > "NGP"
> > Data to write to Result Worksheet NGP: Main Worksheet same data record
> > Columns M-Q
> > There can be no blank rows in the Result Worksheets.
> >
> > Result Worksheet CNF:
> > Criteria to select data record: Main Worksheet Column H must have the text
> > "CNF"
> > Data to write to Result Worksheet CNF: Main Worksheet same data record
> > Columns M-Q
> > There can be no blank rows in the Result Worksheets.
> >
> > Result Worksheet CNT:
> > Criteria to select data record: Main Worksheet Column I must have the text
> > "CNT"
> > Data to write to Result Worksheet CNT: Main Worksheet same data record
> > Columns M-Q
> > There can be no blank rows in the Result Worksheets.
> >
> > Please tell me how to write these worksheets!
> >
> > Thanks!!!
> > Sheri
 | 
Pages: 1
Prev: Maintain lowest value in an "external connection" cell
Next: excel conditional formatting