Sorting of table using formulae

I have a table. In the 1st column there are voltage levels i.e. 400,300,200,100 V etc. In the 2nd column, the short description of items related to voltages in 1st column, there may be many items for single voltage level. In the 3rd column there are dates in chronological order by which the items in 2nd column came in existence.

(using COUNTIFS i have done with the abstract in nos.)

NOW I WANT ANOTHER TABLE IN WHICH THESE ARE SORTED WITH ALL 400V ITEMS AT TOP WITH CORRESPONDING ROWS FOLLOWED BY 300V,200V …. AND SO ON AUTOMATICALLY. KINDLY SUGGEST FORMULAE IN EXCEL. 

 

By: MD

Leave a Reply

Your email address will not be published. Required fields are marked *