looking for fractions
I have a huge table in which I want to want to filter one of the columns
according values that are not an integer. (i.e. 3.7 boxes, 2.4 boxes, etc.) What formula or function can I use? I DO NOT WANT TO CHANGE THE VALUE TO AN INTEGER. Thanks Rosa |
looking for fractions
I don't fully understand what it is that you are trying to do but would a
'helper' column of =INT(A1) etc. then filter on that helper column do what you want? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Rosa59" wrote in message ... I have a huge table in which I want to want to filter one of the columns according values that are not an integer. (i.e. 3.7 boxes, 2.4 boxes, etc.) What formula or function can I use? I DO NOT WANT TO CHANGE THE VALUE TO AN INTEGER. Thanks Rosa |
looking for fractions
A helper column with the formula
=mod(a1,1) dragged down then filter this and your data column for 0 Mike "Rosa59" wrote: I have a huge table in which I want to want to filter one of the columns according values that are not an integer. (i.e. 3.7 boxes, 2.4 boxes, etc.) What formula or function can I use? I DO NOT WANT TO CHANGE THE VALUE TO AN INTEGER. Thanks Rosa |
looking for fractions
EXCELLENT! I had to look up the meaning of that function, but now I've got
it. Thanks so much. Rosa "Mike H" wrote: A helper column with the formula =mod(a1,1) dragged down then filter this and your data column for 0 Mike "Rosa59" wrote: I have a huge table in which I want to want to filter one of the columns according values that are not an integer. (i.e. 3.7 boxes, 2.4 boxes, etc.) What formula or function can I use? I DO NOT WANT TO CHANGE THE VALUE TO AN INTEGER. Thanks Rosa |
All times are GMT +1. The time now is 08:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com