LinkBack URL
About LinkBacks
pick44 
in I3
=MIN(IF(A3=A$3:A$19,C$3:F$19))&" - "&=MAX(IF(A3=A$3:A$19,C$3:F$19))
Array formula, use Ctrl-Shift-Enter
and copy down the column
in I3
=MIN(IF(A3=A$3:A$19,C$3:F$19))&" - "&=MAX(IF(A3=A$3:A$19,C$3:F$19))
Array formula, use Ctrl-Shift-Enter
and copy down the column
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
After I ran the formula, I found that some street numbers had "0" as the min. This happened when the mapping program I use did not have a beginning address and it places a "0". Can the formula be adapted to have a value "1" or higher?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks