| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
multiple results search
i am having trouble searching for a value that has multiple entries
from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, then assuming that your data starts at Cell A1 on Sheet2: =ArrayRowFilter1(Sheet2!A1:C5,1,"ab12345") array entered into a range on Sheet1 sufficiently large to accept the output. Alan Beban ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#3
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
Hi
see your respones in Excel.programming P.S: please don't multipost -- Regards Frank Kabel Frankfurt, Germany ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#4
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
sorry, i didn't know the standard in posting a message. this was my
first and just saw an option to do so. i'm not sure were in Excel.programming I should be looking? thanks, "Frank Kabel" wrote in message ... Hi see your respones in Excel.programming P.S: please don't multipost -- Regards Frank Kabel Frankfurt, Germany ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#5
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
Hi
find below reposts from the other NG: --- From Alan Beban: If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook, then assuming that your data starts at Cell A1 on Sheet2: =ArrayRowFilter1(Sheet2!A1:C5,1,"ab12345") array entered into a range on Sheet1 sufficiently large to accept the output. Alan Beban ---- -- Regards Frank Kabel Frankfurt, Germany ruchir wrote: sorry, i didn't know the standard in posting a message. this was my first and just saw an option to do so. i'm not sure were in Excel.programming I should be looking? thanks, "Frank Kabel" wrote in message ... Hi see your respones in Excel.programming P.S: please don't multipost -- Regards Frank Kabel Frankfurt, Germany ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
I'm having trouble using the ArrayRowFilter1 function... How do I get
the function to recognize that I have selected the proper number of cells to contain the resultant array? Alan Beban wrote in message ... If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook, then assuming that your data starts at Cell A1 on Sheet2: =ArrayRowFilter1(Sheet2!A1:C5,1,"ab12345") array entered into a range on Sheet1 sufficiently large to accept the output. Alan Beban ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
If you're entering the function into a range of cells on the worksheet,
if the range is not large enough the function will return a message telling you how many rows and columns need to be selected; if the range is larger than necessary the function will return "" to the superfluous cells. Are you experiencing something else? Alan Beban Paul Valenzano wrote: I'm having trouble using the ArrayRowFilter1 function... How do I get the function to recognize that I have selected the proper number of cells to contain the resultant array? Alan Beban wrote in message ... If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook, then assuming that your data starts at Cell A1 on Sheet2: =ArrayRowFilter1(Sheet2!A1:C5,1,"ab12345") array entered into a range on Sheet1 sufficiently large to accept the output. Alan Beban ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
Perhaps my question is how do I properly enter the function into a
range of cells? It doesn't seem to be filling the range with the function, no matter how I select the cells I want to put the results in. I've tried naming my range, and setting the function while the name is selected. I've also Ctrl+R Ctrl+D filled the selection (didn't honestly think that would work, but I figured I'd try it). Thanks for the help thus far, Alan -Paul Valenzano Alan Beban wrote in message ... If you're entering the function into a range of cells on the worksheet, if the range is not large enough the function will return a message telling you how many rows and columns need to be selected; if the range is larger than necessary the function will return "" to the superfluous cells. Are you experiencing something else? Alan Beban Paul Valenzano wrote: I'm having trouble using the ArrayRowFilter1 function... How do I get the function to recognize that I have selected the proper number of cells to contain the resultant array? Alan Beban wrote in message ... If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook, then assuming that your data starts at Cell A1 on Sheet2: =ArrayRowFilter1(Sheet2!A1:C5,1,"ab12345") array entered into a range on Sheet1 sufficiently large to accept the output. Alan Beban ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple results search
What error messages do you get? Are you array entering (i.e., entering
with Ctrl+Shift+Enter instead of just Enter) the function? Alan Beban Paul Valenzano wrote: Perhaps my question is how do I properly enter the function into a range of cells? It doesn't seem to be filling the range with the function, no matter how I select the cells I want to put the results in. I've tried naming my range, and setting the function while the name is selected. I've also Ctrl+R Ctrl+D filled the selection (didn't honestly think that would work, but I figured I'd try it). Thanks for the help thus far, Alan -Paul Valenzano Alan Beban wrote in message ... If you're entering the function into a range of cells on the worksheet, if the range is not large enough the function will return a message telling you how many rows and columns need to be selected; if the range is larger than necessary the function will return "" to the superfluous cells. Are you experiencing something else? Alan Beban Paul Valenzano wrote: I'm having trouble using the ArrayRowFilter1 function... How do I get the function to recognize that I have selected the proper number of cells to contain the resultant array? Alan Beban wrote in message ... If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook, then assuming that your data starts at Cell A1 on Sheet2: =ArrayRowFilter1(Sheet2!A1:C5,1,"ab12345") array entered into a range on Sheet1 sufficiently large to accept the output. Alan Beban ruchir wrote: i am having trouble searching for a value that has multiple entries from sheet1 enter a value: ab12345 search for all rows that have value ab12345 in sheet2 and paste in sheet1 in sheet2 ab12345 name1 number1 ab12345 name2 number2 ab12345 name3 number3 ab12345 name4 number4 ab12345 name5 number5 if anyone can i help, i would greatly appreciate. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple search results | Excel Worksheet Functions | |||
| Search Results | Excel Discussion (Misc queries) | |||
| multiple results from search / how to? | Excel Discussion (Misc queries) | |||
| multiple results from search / how to? | Excel Discussion (Misc queries) | |||
| How can I view multiple search results? | Excel Discussion (Misc queries) | |||
Linear Mode
