filter data where digit before and after decimal point should be same like 103.3

**ganotra** · 08-19-2017, 08:29 AM

is is possible to filter data where digit before decimal point is equal to digit after decimal point
like 685.5,453.35, 407.7,272.2, if possible please help me out
excel.jpg

**samba_ravi** · 08-19-2017, 08:44 AM

I think it needs helper column

**Phuocam** · 08-19-2017, 08:47 AM

Create helper column:

=--(INT(MOD(C2,10))=INT(MOD(C2*10,10)))

filter data where digit before and after decimal point should be same like 103.3

LinkBack

Thread Tools

Rate This Thread

Display

filter data where digit before and after decimal point should be same like 103.3

Re: filter data where digit before and after decimal point should be same like 103.3

Re: filter data where digit before and after decimal point should be same like 103.3

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert Percentage to 5 digit number without decimal point

insert decimal point after first digit

[SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash

[SOLVED] How to select a specific digit within a number that has a decimal point.

Add decimal point from last 2 digit

[SOLVED] Display a digit before or after the decimal point in another cell

[SOLVED] In excel, how can i delete 1 digit and the decimal point?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions