Hey everyone.
I have a range of numbers (ex. 111111111-555555555) and i have a column of 2000 9 digit numbers in different spreadsheet. Is there away to create a formula that will tell me if any of the numbers in my range are in the 2000 numbers in the column? I hope that made sense.
Thanks in advance
That sounds like a COUNTIFS() function: https://support.office.com/en-us/art...c-aa8c2a866842 =COUNTIFS(range of 2000 numbers,">=111111111",range of 2000 numbers,"<=555555555"). If the result is 0, then none of the entries are in that range. If the result is 1 or more, then there are entries in that range.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks