| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with wildcard in complex formula... help?
On Mar 12, 7:57 pm, wrote:
On Mar 12, 7:06 pm, "Bob Phillips" wrote: =IF(AND($A$79<"",E$99<""),IF($E$94<0, SUMPRODUCT((ISNUMBER(FIND($A$79,$K$8:$K$74)))* (ISNUMBER(FIND(E$99,$C$8:$C$74)))/$E$94),0),"") Thanks for the corrected formula man, really appreciate it. Found another couple of threads in the meantime that discussed how wildcards cannot be used with SumProduct arrays... so frigging annoying. Okay, so this introduces another wrinkle, maybe you can help? My original formula was geared for two dimensions, but I had planned on trying to make it a three dimensional formula for some other calculations I need to do. The introduction of Find (which I believe only works in 2D) would appear to put a wrinkle in this plan... So the question: is there a way to make this formula work in three dimensions? Thanks again for the help. -Rick Anyone? A little help? -rt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex Look Up Problem | Excel Worksheet Functions | |||
| Somewhat complex timesheet problem. | Excel Worksheet Functions | |||
| COMPLEX PROBLEM | Excel Discussion (Misc queries) | |||
| Complex Problem | Excel Worksheet Functions | |||
| Wildcard Problem.... | Excel Discussion (Misc queries) | |||
Threaded Mode
