Hi.. Friends....
After long time, i am going post an excel tip for
sorting by color. Yesterday when i was working on excel, i got this probelm. Actually this color sorting is available in excel 2007, but not in excel 2003. some times we have to submit different fields data which was completed by you but indicates by different colors. Then we need to sort by those colors. For that i got a small solution.
We have to give formula in first beside coloumn cell what we are going to sort out. Later copy that formula in remain that coloums cells.
Formula:
=colorindex(A1)
This colorindex command gives different index numbers to different colors, so by using those cnumbers we can sort out our data.
All the best...

Loading...
0 comments:
Post a Comment