I went to the page you linked:
http://office.microsoft.com/en-us/ex...260381033.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/ex...260381033.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