Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the name of this function...
=(some column array) (some row array)
= the intersection of the two arrays. I need more information on this; I just need the name to search for it. I have many 4x4 tables from which i need to get one value from, both vars could be called independent of each other. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the name of this function...
Maybe =index()
or natural language formulas (I don't use these) for =vlookup() and =index(match()), you could look at Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html hamma_thrower wrote: =(some column array) (some row array) = the intersection of the two arrays. I need more information on this; I just need the name to search for it. I have many 4x4 tables from which i need to get one value from, both vars could be called independent of each other. -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the name of this function...
There is no named function as such. The space character works as
the intersection operator. E.g, =(B1:B10 A4:H4) will return the intersection of B1:B10 and A4:H4, or cell B4. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "hamma_thrower" wrote in message oups.com... =(some column array) (some row array) = the intersection of the two arrays. I need more information on this; I just need the name to search for it. I have many 4x4 tables from which i need to get one value from, both vars could be called independent of each other. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the name of this function...
In article .com,
says... =(some column array) (some row array) = the intersection of the two arrays. I need more information on this; I just need the name to search for it. I have many 4x4 tables from which i need to get one value from, both vars could be called independent of each other. To access a particular element of a 4x4 (or MxN for that matter) range of cells, check out the INDEX and OFFSET functions. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the name of this function...
I see that you've already received several suggestions if you are looking
for worksheet functions, so I won't repeat those. In VBA (since this is the programming forum): The Intersect (rng1,rng2,...) method "..returns a Range object that represents the rectangular intersection of two or more ranges.." The Union method would return the combination of two or more ranges. HTH, -- George Nicholson Remove 'Junk' from return address. "hamma_thrower" wrote in message oups.com... =(some column array) (some row array) = the intersection of the two arrays. I need more information on this; I just need the name to search for it. I have many 4x4 tables from which i need to get one value from, both vars could be called independent of each other. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the name of this function...
Thanks..I was looking for a VBA solution. "Space character" was the
name I was looking for, but intersect works for me. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |