A couple years ago I defined criteria that did not refer to cells. I don't recall how I did it but it's certainly not obvious. Anybody know how to do this? I tried a bunch of different syntax but can't get it. See attachment. I am trying to populate the Equity column. I've simplified it here. The actual database is getting close to the 256 column limit (we're at column HG now).
Last edited by Alpha Hunter; 12-28-2010 at 03:58 PM.
it's sort of go somewhere and bring something I do not know what. Be more specific or this thread will remain nearly empty.
Please see attachment.
Last edited by watersev; 12-23-2010 at 03:14 PM.
Just a guess, but try this
In C2
Drag/Fill Down
Please Login or Register to view this content.
Adjust to suit your actual ranges.
Hope this helps.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Yes, I already solved it with an INDEX(MATCH,MATCH) but I've come across this challenge so often with many different functions I thought I'd throw it out there.
There must be a simple way to describe criteria without using cells.
do you mean VB arrays, VB inputbox or some unknown for me method?
Last edited by watersev; 12-23-2010 at 04:16 PM.
I thought you could write it in quotation marks or something like that
Nae doot, PM snb
You don't have to use cell references for arguments - you can use constants if you prefer.
orPlease Login or Register to view this content.
the 2nd illustrates an inline array where ; denotes a row and , a columnPlease Login or Register to view this content.
etc...Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
You cannot use D-functions without criteria ranges, if that's what you are referring to.
Remember what the dormouse said
Feed your head
I like where you're going with these examples DonkeyOte, but can you show an example where it acts as the criteria for a function that takes criteria?
I'm afraid I don't follow.... if you are referring to the D-functions then see romperstomper's previous post (ie must be stored in physical range).
ok, I'll give up. I guess I'll call that solved (or unsolveable).
The clearer you are in your requirements the more likely you are to get an (satisfactory?) resolution... thus far everything has been far too vague for anyone to offer anything meaningful in return I'm afraid.
Per the initial sample file it appears as though you want to use constants for the criteria in your DGET call and as has been outlined previously you can't.
Edit: to elaborate on D functions
Given your set up in the original attachment you have an issue in so far as you can't create the requisite range reference (must be contiguous)
You could however use a basic SUMIF with INDEX construct
but again based on response to Marcol's earlier suggestion this is not seemingly what you're interested in.Please Login or Register to view this content.
Last edited by DonkeyOte; 12-28-2010 at 04:09 PM. Reason: edit: added note re: DGET given attachment in OP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks