What I am trying to accomplish is when using IF functions to seperate data on one specific criteria i place a "true" next to the specific criteria. Of course there may be 8 "true" statements. I am looking for a way to draw out the cell reference/address of each of those true statments from the same column.?
You lost me after "What I'm trying to accomplish".
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I guess what he meant is that he has a range of cells containing IF functions that will return "True" if a certain criteria is met. Then what he will want on one cell is to return the address of all the "True" values in that range. I guess he doesn't want to use Concatenate as his range may be large.Originally Posted by ChemistB
I would probably do it like this:
1. Change the true result for your IF formula to use the ADDRESS function. You can get the the row # using ROW and col # using COLUMN.
2. Then plug this code into a new module.
3. Then use the formula
Assuming that you want a comma (,) delimiter and that the range you want to concatenate is in B3:B10. Change the range as desired.
Please Login or Register to view this content.
See attached example
Last edited by ron2k_1; 05-27-2011 at 12:52 PM.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks