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]

	a​	b​
1​	3.56​	true​
2​	2.02​	true​
3​	1.99​	true​
4​	45.88​	true​
5​	3.86.	false​

<tbody>
</tbody>

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