Notification

Icon
Error

Exported to a spreadsheet to include the PING red/green icons - - How do sort it in excel or can you add a feature ?

Posted: Thursday, November 25, 2021 12:43:47 PM(UTC)
hirogen

hirogen

Member Original PosterPosts: 21
0
Like
This issue has been solved! Click here to view the solution
I've exported all our W7 machines including the ping feature into excel so the first Column A is full of red and green icons, I can't seem to sort it to show all red icons or all green icons or ideally sort them by red then green ? is there a way?

hirogen attached the following image(s):
Screenshot 2021-11-25 114304.png
hirogen
#1hirogen Member Original PosterPosts: 21  
posted: 11/25/2021 12:54:19 PM(UTC)
Originally Posted by: hirogen Go to Quoted Post
I've exported all our W7 machines including the ping feature into excel so the first Column A is full of red and green icons, I can't seem to sort it to show all red icons or all green icons or ideally sort them by red then green ? is there a way?


I guess it would be better if rather than showing a green or red icon or maybe add an additional column in lansweeper which states failed ping, successful ping then i can easily sort by, otherwise excel just reads the red and green icons as a picture, can't tell the difference, unless I'm mistaken feel free to correct me, cheers!
hirogen
#2hirogen Member Original PosterPosts: 21  
posted: 11/25/2021 2:07:56 PM(UTC)
Originally Posted by: hirogen Go to Quoted Post
Originally Posted by: hirogen Go to Quoted Post
I've exported all our W7 machines including the ping feature into excel so the first Column A is full of red and green icons, I can't seem to sort it to show all red icons or all green icons or ideally sort them by red then green ? is there a way?


I guess it would be better if rather than showing a green or red icon or maybe add an additional column in lansweeper which states failed ping, successful ping then i can easily sort by, otherwise excel just reads the red and green icons as a picture, can't tell the difference, unless I'm mistaken feel free to correct me, cheers!


SOrry just figured it out you can click the ping button and it auto sorts by green or red !!

Active Discussions

Lansweeper SSL with IIS Express Not working
by  fjca   Go to last post Go to first unread
Last post: Yesterday at 8:16:46 PM(UTC)
Lansweeper LsAgent Reliability Problems
by  marck1024  
Go to last post Go to first unread
Last post: Yesterday at 2:09:29 PM(UTC)
Lansweeper 32-BIT Linux LsAgent-linux
by  Anup Chhetri   Go to last post Go to first unread
Last post: Yesterday at 1:30:15 PM(UTC)
Lansweeper Default Scanned item intervals
by  SteelOG  
Go to last post Go to first unread
Last post: 1/25/2022 8:22:45 PM(UTC)
Lansweeper How to delete an asset
by  tgas   Go to last post Go to first unread
Last post: 1/25/2022 4:00:10 PM(UTC)
Lansweeper Can you track local printers attached to Desktops?
by  hirogen  
Go to last post Go to first unread
Last post: 1/25/2022 2:48:22 PM(UTC)
Lansweeper Duplicates - different IP address
by  Lenven   Go to last post Go to first unread
Last post: 1/25/2022 2:12:40 PM(UTC)
Lansweeper Antivirus Up to Date or Not?
by  Lindner  
Go to last post Go to first unread
Last post: 1/25/2022 12:46:21 PM(UTC)