Dropdown that filter by 1 word in a cell
Closed
Estall
Posts
1
Registration date
Thursday February 24, 2011
Status
Member
Last seen
February 24, 2011
-
Feb 24, 2011 at 04:02 AM
Estall - Mar 28, 2011 at 07:57 AM
Estall - Mar 28, 2011 at 07:57 AM
Related:
- Dropdown that filter by 1 word in a cell
- Fnaf 1 download pc - Download - Horror
- Gta 1 download - Download - Action and adventure
- Fnia 1 - Download - Adult games
- Tentacle locker 1 - Download - Adult games
- Igi 1 download - Download - Shooters
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 25, 2011 at 10:31 AM
Feb 25, 2011 at 10:31 AM
Sorry Estall,
Failed to understand you.
It looks like you would like to expand your validation list, which should be no problem since you already created one?
Could you reexplain in more detail?
Best regards,
Trowa
Failed to understand you.
It looks like you would like to expand your validation list, which should be no problem since you already created one?
Could you reexplain in more detail?
Best regards,
Trowa
Okay, will expand!
I have a dropdown on tab#1 with some phrases on.
On tab#2, there is a row of entries and a column which has the same phrases appear in.
Back on the tab#1, there is a vlookup formula, which reads which phrase is selected on the drop-down, looks at the column in the tab#2 for that phrase and, back on the tab#1, populates the cells.
(It also looks at a unique reference to ensure which row goes where).
So, on tab#2, the column with the phrses in sometimes has multiple phrases in it!
What I want is that when, in tab#1, I select (for example) 'bearcub' in the dropdown, the formula picks up all the cells in the column with that single phrase in, but ALSO all the cells in that column where the phrase appears (when it's not the only phrase).
Does this help?
Ultimately, using a dropdown, I want tab #1 to be populated with entries where the column in question has the phrase 'bearcub' (for example), regardless of whether it's own or not.
In the column in tab#2:
cell 1 - bearcub
Cell 2 - Aircon
Cell 3 - Cliffrichards
Cell 4 - bearcub Aircon
When I select 'bearcub, in the validation on tab#1, I want to formula on tab #1 to pick up columns including cells & 4 (as they both contain 'Bearcub').
If I switch the dropdown to Aircon, the formulas should pick up 2 & 4.
I hope this makes sense!
Thanks.
I have a dropdown on tab#1 with some phrases on.
On tab#2, there is a row of entries and a column which has the same phrases appear in.
Back on the tab#1, there is a vlookup formula, which reads which phrase is selected on the drop-down, looks at the column in the tab#2 for that phrase and, back on the tab#1, populates the cells.
(It also looks at a unique reference to ensure which row goes where).
So, on tab#2, the column with the phrses in sometimes has multiple phrases in it!
What I want is that when, in tab#1, I select (for example) 'bearcub' in the dropdown, the formula picks up all the cells in the column with that single phrase in, but ALSO all the cells in that column where the phrase appears (when it's not the only phrase).
Does this help?
Ultimately, using a dropdown, I want tab #1 to be populated with entries where the column in question has the phrase 'bearcub' (for example), regardless of whether it's own or not.
In the column in tab#2:
cell 1 - bearcub
Cell 2 - Aircon
Cell 3 - Cliffrichards
Cell 4 - bearcub Aircon
When I select 'bearcub, in the validation on tab#1, I want to formula on tab #1 to pick up columns including cells & 4 (as they both contain 'Bearcub').
If I switch the dropdown to Aircon, the formulas should pick up 2 & 4.
I hope this makes sense!
Thanks.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 28, 2011 at 03:42 PM
Feb 28, 2011 at 03:42 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.
Note: your data need not be to be real data but a good representative of how data looks like
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 1, 2011 at 09:56 AM
Mar 1, 2011 at 09:56 AM
OK Estall, it's getting more clear to me know. Just don't know what result you would like to see?:
Let's say,
Sheet 1, cel A1 contains dropdown in which you select bearcub.
Then in sheet 1, cell B1 you would like to see:
1, 4 or
bearcub, bearcub Aircon
or do you want to populate two cells like:
B1: 1
B2: 4
or
B1: bearcub
B2: bearcub, bearcub Aircon
Answering Rizvisa's request is also a wise move, since he can solve pretty much any query!
Best regards,
Trowa
Let's say,
Sheet 1, cel A1 contains dropdown in which you select bearcub.
Then in sheet 1, cell B1 you would like to see:
1, 4 or
bearcub, bearcub Aircon
or do you want to populate two cells like:
B1: 1
B2: 4
or
B1: bearcub
B2: bearcub, bearcub Aircon
Answering Rizvisa's request is also a wise move, since he can solve pretty much any query!
Best regards,
Trowa
Hi, having a bit of trouble getting a document on.
I wonder if this will help, in the interim.
I can do a COUNTIF on the first column. This observes SDS wherever it appears (be it on it's own or with other words)
=COUNTIF(F4:F40,"*"&I110&"*")
(I110 = SDS, say)
I can also do a SUMIF of all the rows where SDS appears in the F column that also have 'Green' in the T columns.
=SUM(IF(T4:T40="Green",IF(F4:F40="SDS",1,0)))
So, any cell in the F column that says "SDS" will be counted, but not if it says, say "SDS TP RGB" I want it to count ALL F column cells that include SDS in it.
Sorry I haven't got a document to show at this time, does this help?
=SUM(IF(T4:T40="Green",IF(F4:F40="SDS",1,0)))
I want this formula to count ALL instances where SDS appear in the column.
I wonder if this will help, in the interim.
I can do a COUNTIF on the first column. This observes SDS wherever it appears (be it on it's own or with other words)
=COUNTIF(F4:F40,"*"&I110&"*")
(I110 = SDS, say)
I can also do a SUMIF of all the rows where SDS appears in the F column that also have 'Green' in the T columns.
=SUM(IF(T4:T40="Green",IF(F4:F40="SDS",1,0)))
So, any cell in the F column that says "SDS" will be counted, but not if it says, say "SDS TP RGB" I want it to count ALL F column cells that include SDS in it.
Sorry I haven't got a document to show at this time, does this help?
=SUM(IF(T4:T40="Green",IF(F4:F40="SDS",1,0)))
I want this formula to count ALL instances where SDS appear in the column.
