I'm looking for help with an Array formula that does the following:
Generate a list of results that contain:
The value "1400"
The value "1700"
Contains "-F"
Contains "p"
All of these within the same range.
My use of arrays has been with dates, I've been grasping a basic understanding of them with the help I've received on this forum in the past. Any help would be appreciated.
Last edited by Pepe Le Mokko; 01-02-2020 at 04:51 AM. Reason: Removed unnecessary title part
Also, I've asked above with using the same range. Could multiple ranges work? Such as A1:A20 and B50:B70?
Use variants of this:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(Table3133347172[Time])/(ISNUMBER(SEARCH($E$1,Table3133347172[Time]))),ROWS(E$2:E2))),"")
see sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please attach an example of ONE scenario with multiple ranges, so I understand what you want.
Attached is an example with a second range to include
Adapted formulae are in the sheet.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Attempting to implement the formulas into my workbook however, this comes up with partial results. I've replaced table names/columns with actual ranges. Perhaps I interpreted the formula incorrectly. "1400" and "1700" are being searched in first range/table. "*p*" and "*-F*" are to be searched in another range/table.
The first works correctly, listing the 1400's and 1700's as needed. *p and *-F are not.
Last edited by Grizraz; 01-04-2020 at 02:50 AM.
Attached is an exact excerpt of the workbook I'm working with. Worksheet "Map" is where I'm working with the formulas. "Data" is where I'm attempting to pull the data from.
As stated previously, I've managed to pull 1400 and 1700 from range however the results were not correct. I believe I messed up while attempting to follow the formula provided and converting the table name and column name to range.
Also searching "1700" will include "1700-F" for some reason I cannot get it to search only "1700".
Last edited by Grizraz; 01-04-2020 at 03:46 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Also working on a solution at https://www.mrexcel.com/board/thread...teria.1119583/
That's not the only place - please provide ALL links. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks