Pull out decimel point data

smittycft99 · Apr 19th, 2002, 09:38 AM

I have the following:

A1=0.5
A2=2
A3=3.2
A4=7
A5=3

I want to find all numbers in column A that have decimal points and paste them into Column B.
I could not configure if statement with wildcard *. statement....

Could someone help, thank very much in advance!

Mark W. · Apr 19th, 2002, 09:40 AM

=IF(MOD(A1,1),A1,"")

smittycft99 · Apr 19th, 2002, 09:46 AM

Mark ,
I pasted this code into B column but it is not populating the cells with the decimal data

Mark W. · Apr 19th, 2002, 09:53 AM

Quote:

On 2002-04-19 08:46, smittycft99 wrote:
Mark ,
I pasted this code into B column but it is not populating the cells with the decimal data

By entering =IF(MOD(A1,1),A1,"") into B1 and copying down to B5 you should get...

{0.5,0.5
;2,""
;3.2,3.2
;7,""
;3,""}

What are you getting?

Diane_E_Thomas · Apr 19th, 2002, 09:53 AM

It does work! I've just tried it. Try having a go again!

smittycft99 · Apr 19th, 2002, 09:55 AM

Mark thanks a million, you were right on, my fault

smittycft99 · Apr 19th, 2002, 10:00 AM

Is there a quick way to remove the empty cells and compact column B?

Aladin Akyurek · Apr 19th, 2002, 11:35 AM

Insert 3 rows before the row where the data start: The data should look like this:

{"";
"";
"";
"Vals";
0.5;
2;
3.2;
7;
3}

where "" blank cell.

In A2 enter:

=MOD(A5,1)>0

Activate A5.
Activate Data|Filter|Advanced Filter.
Check "Copy to another location".
List range should be $A$4:$A$9, if not adjust.
Enter $A$1:$A$2 as Criteria range.
Enter $B$4 for Copy to.
Activate OK.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 09:38 AM	#1
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	I have the following: A1=0.5 A2=2 A3=3.2 A4=7 A5=3 I want to find all numbers in column A that have decimal points and paste them into Column B. I could not configure if statement with wildcard *. statement.... Could someone help, thank very much in advance!

Apr 19th, 2002, 09:40 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=IF(MOD(A1,1),A1,"")

Apr 19th, 2002, 09:46 AM	#3
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	Mark , I pasted this code into B column but it is not populating the cells with the decimal data

Apr 19th, 2002, 09:53 AM	#5
Diane_E_Thomas New Member Join Date: Apr 2002 Posts: 17	It does work! I've just tried it. Try having a go again!

Apr 19th, 2002, 09:55 AM	#6
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	Mark thanks a million, you were right on, my fault

Apr 19th, 2002, 10:00 AM	#7
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	Is there a quick way to remove the empty cells and compact column B?

Apr 19th, 2002, 11:35 AM	#8
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Insert 3 rows before the row where the data start: The data should look like this: {""; ""; ""; "Vals"; 0.5; 2; 3.2; 7; 3} where "" blank cell. In A2 enter: =MOD(A5,1)>0 Activate A5. Activate Data\|Filter\|Advanced Filter. Check "Copy to another location". List range should be $A$4:$A$9, if not adjust. Enter $A$1:$A$2 as Criteria range. Enter $B$4 for Copy to. Activate OK.