Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adv filter wont accept criteria
I am trying to advance filter a spreadsheet containing housing information.
Namingly, one column is titled "lot type" with the corresponding data in that column reading "Type 1" or Type 2,3 etc. I wish to sort the lots by my choice of number from one to 11. nothing seems to work. I think perhaps I don't know the correct code that excel will accept. Maybe an issue of text and numerical data in the same cell? being brand new to filtering doesn't help either! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adv filter wont accept criteria
Consider using Autofilter. It will allow you to specify exactly what you want.
-- Gary's Student "daniel" wrote: I am trying to advance filter a spreadsheet containing housing information. Namingly, one column is titled "lot type" with the corresponding data in that column reading "Type 1" or Type 2,3 etc. I wish to sort the lots by my choice of number from one to 11. nothing seems to work. I think perhaps I don't know the correct code that excel will accept. Maybe an issue of text and numerical data in the same cell? being brand new to filtering doesn't help either! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adv filter wont accept criteria
It's definitely an issue of text and numbers ,however you can use a formula
as the advanced filter criteria, assume the whole date including headers are A6:D500 and the "lot type" is A:A500 with the different "Types" starting in A7 Let us assume the criteria range is $H$1:$H$2, put the type number in G1 (1, 2, 3 etc) Leave H1 blank and put this formula in H2 =--(TRIM(SUBSTITUTE(A7,"Type","")))=$G$1 apply the filter so if you put 3 in G1 it will filter all Type 3 lots -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "daniel" wrote in message ... I am trying to advance filter a spreadsheet containing housing information. Namingly, one column is titled "lot type" with the corresponding data in that column reading "Type 1" or Type 2,3 etc. I wish to sort the lots by my choice of number from one to 11. nothing seems to work. I think perhaps I don't know the correct code that excel will accept. Maybe an issue of text and numerical data in the same cell? being brand new to filtering doesn't help either! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter criteria | Excel Discussion (Misc queries) | |||
How do I identify Filter criteria or variable graph title? | Excel Discussion (Misc queries) | |||
How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
Advanced filter and Criteria Range | Excel Discussion (Misc queries) | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) |