I am searching a column for the number 10. I have various iterations of 10, i.e. 10.2, 10.75... How do I find just 10?
I am searching a column for the number 10. I have various iterations of 10, i.e. 10.2, 10.75... How do I find just 10?
Last edited by mknispel; 03-22-2016 at 11:30 AM.
If you are looking for a specific number (i.e. 10) in Column C (for example)
=MATCH(10, C:C,0) will return the row number of the first cell that contains exactly 10.
Is that what you need?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
No. I am looking to find all the cells that contain 10 in the formula within a column.
Contain 10 in the formula? or 10 as a result of the formula? Maybe upload an example file (Go Advanced>Manage Attachments)
If you want the 10's in formula (without 10.2, etc) not sure it can be done unless you know there will always be a space after the 10? Then use the Find window (CNTRL + F)
I was able to find what I needed based on your suggestion. I should've realized what I was looking for. I just needed to include the preceding or following character in the search.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks