|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#21
June 25th, 2007, 01:48 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit to nested IF(ISNUMBER(SEARCH)) functions?
On Sun, 24 Jun 2007 16:13:01 -0700, Jonathan Horvath
wrote: I have to wait until I get in the office tomorrow to double check with the full list but I think this will work! Thanks!!! Jonathan Let me know!! There can still be problems if you have data that includes a high priority ID that is embedded in such a way that it should not be counted. But you'll need to examine your data set to see if that is a problem. (There are solutions even for that). --ron 
|
|
#22
June 25th, 2007, 07:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit to nested IF(ISNUMBER(SEARCH)) functions?
Ron,
It worked. I have several entries that have multiple identifiers however using the prioritization array allowed me to pluck the unique ones off one by one and the remaining ones were all grouped into a single, and appropriate, bucket. thanks! Jonathan
|
|
#23
June 25th, 2007, 08:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limit to nested IF(ISNUMBER(SEARCH)) functions?
On Mon, 25 Jun 2007 11:04:01 -0700, Jonathan Horvath
wrote: Ron, It worked. I have several entries that have multiple identifiers however using the prioritization array allowed me to pluck the unique ones off one by one and the remaining ones were all grouped into a single, and appropriate, bucket. thanks! Jonathan Good to hear. Thanks for the feedback. --ron
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
