Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to dinamic cell that searches for "value1 & value2" in table.
Hi
I have an excell sheet with columns city and comercename i would like to make a dinamic cell that searches for city=Lisbon & comercename=cars and it would search the entire database and crate an output with all entries witch respected city=lisbon and comercename=cars. How to? |
#2
|
|||
|
|||
Hi
Have a look at Data/Filter/Autofilter. -- Andy. "armindo" wrote in message ... Hi I have an excell sheet with columns city and comercename i would like to make a dinamic cell that searches for city=Lisbon & comercename=cars and it would search the entire database and crate an output with all entries witch respected city=lisbon and comercename=cars. How to? |
#3
|
|||
|
|||
Auto filter does not change when the variable chnges, i need a dynamic cell
not a pontual situation |
#4
|
|||
|
|||
Maybe you could use a combination of Data|filter|autofilter (or
data|filter|advancedfilter) and a worksheet event that did the work when you typed something into those two cells. armindo wrote: Auto filter does not change when the variable chnges, i need a dynamic cell not a pontual situation -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to create a table inside of a cell? | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Excel error using Dinamic Table | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |