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
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!
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 !!

Active Discussions

Lansweeper Clearing Thermal State Warning
by  calmed-anodises   Go to last post Go to first unread
Last post: 5/20/2022 6:28:27 PM(UTC)
Lansweeper Quality problems with Lansweeper
by  Hendrik.VE  
Go to last post Go to first unread
Last post: 5/20/2022 3:43:44 PM(UTC)
Lansweeper Bitlocker keys
by  SWResearch   Go to last post Go to first unread
Last post: 5/20/2022 1:34:18 PM(UTC)
Lansweeper Lansweeper Helpdesk instructional webinar
by  Erik.T  
Go to last post Go to first unread
Last post: 5/20/2022 10:40:30 AM(UTC)
Lansweeper Outlook task and calendar
by  ITVTECH   Go to last post Go to first unread
Last post: 5/20/2022 8:26:51 AM(UTC)
Lansweeper SCCM scanning incorrectly reporting last seen results
by  SWResearch  
Go to last post Go to first unread
Last post: 5/20/2022 12:34:52 AM(UTC)
Lansweeper Scanning certificates
by  EagleEyeJoe   Go to last post Go to first unread
Last post: 5/19/2022 7:39:24 PM(UTC)
Lansweeper Lansweeper Cloud Location
by  FrankSc  
Go to last post Go to first unread
Last post: 5/19/2022 7:07:49 PM(UTC)