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: 25
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
Options
hirogen
#1hirogen Member Original PosterPosts: 25  
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!
0
hirogen
#2hirogen Member Original PosterPosts: 25  
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 !!
SOLUTION 1

Active Discussions

Lansweeper NVIDIA May 2022 Vulnerabilities
by  Esben.D   Go to last post Go to first unread
Last post: 5/20/2022 8:46:35 AM(UTC)
Lansweeper HP BIOS Vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: 5/20/2022 8:44:52 AM(UTC)
Lansweeper Firefox 100 & ESR 91.9
by  LANGuy   Go to last post Go to first unread
Last post: 5/18/2022 8:31:26 PM(UTC)
Lansweeper Add column to report to show Intune data
by  eatkins   Go to last post Go to first unread
Last post: 5/18/2022 5:44:54 PM(UTC)
Lansweeper I can't get htblnotes to show properly
by  brother123   Go to last post Go to first unread
Last post: 5/17/2022 11:44:50 PM(UTC)
Lansweeper help getting ticket details text in into this report
by  brother123   Go to last post Go to first unread
Last post: 5/17/2022 5:43:56 PM(UTC)
Lansweeper Distinct user logins per PC location map
by  Steven Coomans   Go to last post Go to first unread
Last post: 5/17/2022 12:53:26 PM(UTC)
Lansweeper Report to show Office 2013 installs still using basic auth
by  EtienneB   Go to last post Go to first unread
Last post: 5/14/2022 9:41:49 AM(UTC)