How to dinamic cell that searches for "value1 & value2" in table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Auto filter does not change when the variable chnges, i need a dynamic cell
not a pontual situation
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Using Vlookup with Sumproduct to satisfy multiple conditions 9
"too many different cell formats". How to solve this problem? 2
adding fileds to an excel database using vairable criteria 1
NAME function working in reverse?? 1
finding and then moving entire row to new sheet based on cell value 2
IF Statement for Cells in a Range 4
Convert list to UPPER, lower & Proper cases. 21

Back
Top