Excel Macros

[tarunshrivastava01]

I am having excel sheet with huge data. I want the vb macros to take out the unique count of Column 'Computer Name' by filtering the column 'Location'. Like:

Row1	Computer Name <colgroup><col width="125"></colgroup><tbody> </tbody>	Something <colgroup><col width="125"></colgroup><tbody> </tbody>	Something <colgroup><col width="125"></colgroup><tbody> </tbody>	Something <colgroup><col width="125"></colgroup><tbody> </tbody>	Location <colgroup><col width="125"></colgroup><tbody> </tbody>
<colgroup><col width="125"></colgroup><tbody>Row2 </tbody>	Desktop1 <colgroup><col width="125"></colgroup><tbody> </tbody>				India
Row3 <colgroup><col width="125"></colgroup><tbody> </tbody>	Desktop2 <colgroup><col width="125"></colgroup><tbody> </tbody>				India
Row4 <colgroup><col width="125"></colgroup><tbody> </tbody>	Desktop3 <colgroup><col width="125"></colgroup><tbody> </tbody>				India
<colgroup><col width="125"></colgroup><tbody> Row5 </tbody>	Desktop1 <colgroup><col width="125"></colgroup><tbody> </tbody>				India
Row6	Desktop3 <colgroup><col width="125"></colgroup><tbody> </tbody>				India
Row7	Desktop11 <colgroup><col width="125"></colgroup><tbody> </tbody>				China
Row8	Desktop12 <colgroup><col width="125"></colgroup><tbody> </tbody>				China
Row9	Desktop13 <colgroup><col width="125"></colgroup><tbody> </tbody>				China
Row10	Desktop11 <colgroup><col width="125"></colgroup><tbody> </tbody>				China
Row11	Desktop13 <colgroup><col width="125"></colgroup><tbody> </tbody>				China
Row12
Row13

<tbody>
</tbody>

First it look for India (Column 'Location') and take the unique count for Column 'Computer Name' from row2 to row6 means filtering by India in column 'Location' i.e., Unique count = 3(Desktop1-3) and then look for Column 'Location' China and take the unique count for column 'Computer Name' from row6-row10.

 

[royUK]

Try using the Macro Recorder to get started. post back for help adapting the generated code

 

[xrichardx]

Excel Filter function should work as per your requirement.

Cheers
Rich