Function to extract Exact values

[panyagak]

Hi Mrexcel-ians

Google has failed me!!

I need a function to extract in a column in a range of only values (no text), any exact number of my choice, like: 1.00 or 2.00, then filter them out separately.

Regards

 

[palaeontology]

Can you elaborate on what you want.

Perhaps make a dummy set of data and a dummy set of results you'd like so we know what you're exactly looking for.

Kind regards,

Chris

 

[panyagak]

Any range, say A1 downwards, is appropriate:

Assuming in Cell A1:A5
3.56
2.02
1.99
45.88
3.86.

Then in Cell B1 assuming I need only 3.86 (same for the rest), then it should show this:

3.56 FALSE
2.02 FALSE
1.99 FALSE
45.88 FALSE
3.86. TRUE

thanks

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

a​

[/TD]
[TD]

b​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

3.56​

[/TD]
[TD]

true​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

2.02​

[/TD]
[TD]

true​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

1.99​

[/TD]
[TD]

true​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

45.88​

[/TD]
[TD]

true​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]3.86.[/TD]
[TD]

false​

[/TD]
[/TR]
</tbody>[/TABLE]


B1=ISNUMBER(A1) copy down

 

[panyagak]

MARZIOTULLIO.

No no: ISNUMBER(A1) would return all, TRUE

You did not understand my problem: compare your results & mine. ALL ARE VALUES (NONE IS TEXT!!)

I only need 3.86

 

[Stiuart_W]

Try

=IF(B2=3.86,"True","False"). Format should be "General"

 

[istiasztalos]

If the desired output is TRUE or FALSE you don't even need an IF function, just add "=B5=3.86"

Excel by default evaluates relational operators in formulas like = < > and returns TRUE or FALSE