[Anonymous]

NINJA Question –

I feel like this shouldn’t be hard but I’m drawing a blank here, anyone know an easy way to do this?

[Pandarama]

I literally just copied and pasted it with no issues (I had copied the detailed report breakdown).

BEC - 80
AUD - 64, 75 - credit lost, 90!!
REG - 73, 74, 83
FAR - 61, 72, 85

Feels good finishing on my best note. Time to watch the mailbox.

[Anonymous]

me, too. copied the table and analyzed my weak areas. wish there was a function to export, cuz the copy&paste thing took me a long time to fix the layout.

[klmc]

I literally just did this 10 minutes ago lol, just copy normally and then go to “paste special” in excel and choose text instead of HTML

|FAR| - 72, 83
|AUD| - 73, 76
|REG| - 76
|BEC| - 73, 82

ALL DONE!!

[klmc]

another cool thing you can do is highlight the column with your average percentages and go to “conditional formating” and choose “color scale. This will color every cell depending on the percentage: so 100% is green 0% is red and the rest are in between the colors.

|FAR| - 72, 83
|AUD| - 73, 76
|REG| - 76
|BEC| - 73, 82

ALL DONE!!

[Author]

Replies