Hi,
I need to create a table in Excel 2010 from a worksheet.
The worksheet has 5 columns, A1:E695.
My intention is to create a table from the selection from three drop down boxes of column A, B and E, and there are values repeated throughout the worksheet. In the table, I would like to show only the details of column C,D and E (In relation to E, only the values selected from the drop down box).
I know I need to use Countifs to know how many values are repeated for column A,B and E.
My problem is I am not sure how to display this information in a table.
I would appreciate your advice and help regarding my query, and if it is convenient to use a VBA code or Excel formula?
Kind Regards,
Dan</SPAN>
I need to create a table in Excel 2010 from a worksheet.
The worksheet has 5 columns, A1:E695.
My intention is to create a table from the selection from three drop down boxes of column A, B and E, and there are values repeated throughout the worksheet. In the table, I would like to show only the details of column C,D and E (In relation to E, only the values selected from the drop down box).
I know I need to use Countifs to know how many values are repeated for column A,B and E.
My problem is I am not sure how to display this information in a table.
I would appreciate your advice and help regarding my query, and if it is convenient to use a VBA code or Excel formula?
Kind Regards,
Dan</SPAN>