Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-26-2019, 07:07 PM
GCarpenter GCarpenter is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Posts: 1
GCarpenter is on a distinguished road
Default How many people within given distance

(SOLVED) - sorry for cross-posting. didn't know rule until after



I have a similar issue, but I'm trying to get counts, (COUNTIF). Would anyone know how to accomplish the attached?

For each store, I'd like to see how many people are within 25 miles.

Appreciate any help in advance!


Edit Mod : related to http://www.msofficeforums.com/excel/...ing-lat-2.html



Last edited by Pecoflyer; 02-27-2019 at 12:35 AM. Reason: cross posted by accident
Reply With Quote
  #2  
Old 02-26-2019, 09:45 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,390
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Cross-posted at:
https://www.mrexcel.com/forum/excel-...ce-points.html
https://www.excelforum.com/excel-for...ce-points.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-27-2019, 12:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,386
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome
please do not hijack existing threads but start one of your own eventually with a link to any relevant thread.
As you do not have 10 posts, post the link as plain text.
Thank you
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
(Out-)Distance of Line on Header michissimo Word 3 06-23-2018 09:51 AM
page number distance from bottom suma Word 2 11-17-2014 12:12 AM
Fixed distance between number and heading? Katarina Word 2 03-27-2014 06:23 AM
change shadow distance cheech1981 Word VBA 2 02-14-2014 06:02 PM
Why do we have this distance above the footer? Jamal NUMAN Word 4 04-14-2011 04:55 PM


All times are GMT -7. The time now is 10:00 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft