Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filter for decimals
Hi,
I have a list of number in one column. I want to see the number which has decimals Eg: 23.96 23.00 22.17 24.00 When I put filter for the above number the result should be 23.96 and 22.17 Can you please tell what the condition I need give in filter option? |
#2
|
|||
|
|||
Filter for decimals
Hi,
I don't know how to define that condition in the filter but you can easily work it around with an extra column where you test if it's a number with decimals. If your number to test is in column A2, input : =IF(INT(A2)<A2,"decimal","integer") Bye "vishu" wrote: Hi, I have a list of number in one column. I want to see the number which has decimals Eg: 23.96 23.00 22.17 24.00 When I put filter for the above number the result should be 23.96 and 22.17 Can you please tell what the condition I need give in filter option? |
#3
|
|||
|
|||
Filter for decimals
Hi Marco...thanks a lot
"Marco" wrote: Hi, I don't know how to define that condition in the filter but you can easily work it around with an extra column where you test if it's a number with decimals. If your number to test is in column A2, input : =IF(INT(A2)<A2,"decimal","integer") Bye "vishu" wrote: Hi, I have a list of number in one column. I want to see the number which has decimals Eg: 23.96 23.00 22.17 24.00 When I put filter for the above number the result should be 23.96 and 22.17 Can you please tell what the condition I need give in filter option? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Pivot table and filter | New Users to Excel | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions |