Found nothing useful on google...bunch of BS actually, unless you want to get into programming.
What worked was taking the list of IP's in excel, adding a column before the IP's column and filling the ping command in, then adding a column after the IP column and adding >>c:\result.log. After this is done, removing all blank spaces in the spreadsheet with find and replace "alt+255" for the ascii space character, and replacing it with nothing at all, to get rid of errors in syntax from the spreadsheet formatting, then selecting all three columns, copying that selection to a blank notepad file, saving it as pinlglist.cmd and running the file.
Basically the resulting pinglist.cmd file look like this:
ping 10.x.x.10 >>c:\result.log
ping 10.x.x.20 >>c:\result.log
ping 10.x.x.30 >>c:\result.log
ping 10.x.x.40 >>c:\result.log
It pings every IP in the list and appends the result to the result.log file.
After it completes, all I have to do is import the results and filter by 100% packet loss to show all the machines that were no longer present.
If you havent guessed something like why I am doing this, it's to help figure out and verify servers in our inventory actually exist.
Thanks