I have a table of data. i also want to have a search box. So what ever i put in that box it searches for in the table. I also need it to highlight the results and do a count on some values.
What would be the best way of approaching this.
I have attached a sample to hopefully show what i want to achieve.
conditional formatting and sumif
Copy of test.xlsx
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
1) =$c19=$b$18
2) =sumif(c19:c29,b18,d19:d29)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
To CF : select C19:D29 and enter =$C19=$B$18 as formula then format as needed
What do you want to count ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks