
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-25-2021 12:43 PM
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?
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-25-2021 02:07 PM
hirogen wrote:hirogen wrote:
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 !!
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-25-2021 12:54 PM
hirogen wrote:
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!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-25-2021 02:07 PM
hirogen wrote:hirogen wrote:
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 !!
