| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract a range from a range
I am having a range a2:a100 student'sNames,b2:b100-standard(std1,std2
etc...),c2:c100-Marks. Basing on D1 value(say D1=std2) ,I want to extract std2 values of range a2:c100 to D2:F100( all 3 columns data).Blank range shoud shown as Blank("").I don't want to it using filter.So,please don't advise me using filter options on the list.Many thanks if anybody gives me a robust formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
Threaded Mode
