halesowenmum
Active Member
- Joined
- Oct 20, 2010
- Messages
- 383
- Office Version
- 365
- Platform
- Windows
Hi, here is an example of the data I am working with which is giving me a problem as it peskily contains two values which are the same (rrrr):
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I only need to see the TOP value - how do I deal with this??? Do I simply take those two figures and average them - would that work??
At the moment I have it set up using conditional formatting to highlight the top value in red and the bottom value in light blue so its just these ones where there's two top values that are giving me a pain in the neck.
Why do these things always happen when you're on a really urgent piece of work?!
162</SPAN> |
227 |
196</SPAN> |
191</SPAN> |
206</SPAN> |
227 |
212</SPAN> |
198</SPAN> |
222</SPAN> |
193</SPAN> |
194</SPAN> |
127 |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I only need to see the TOP value - how do I deal with this??? Do I simply take those two figures and average them - would that work??
At the moment I have it set up using conditional formatting to highlight the top value in red and the bottom value in light blue so its just these ones where there's two top values that are giving me a pain in the neck.
Why do these things always happen when you're on a really urgent piece of work?!