Excel/VBA create table from repeated values

[Dancarro]

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>

 

[venkat1926]

it is not clear what yo;u want. d;o you want remove rows havigduplicates in E.

anyhow this countif formula will be useful (formula sh;ouldbe wlrlitten inany empty cell other than column E)

=COUNTIF(OFFSET(E1,0,0,COUNTA($E:$E),1),E1)

u cam copy down the formula

 

[Dancarro]

Hi Venkant,

Let me explain a little further.

Column A: Country
Column B: Regions
Column C: Description
Column D: Comments
Column E: Code

From the dropdown boxes, I want to select the country, region and codes (all these repeat throughout the worksheet)
A B E
Ex: USA CHICAGO 1123
USA CHICAGO 1003
USA TEXAS 1123

The table will show column C, D and E
Tabale should appear as from the dropdown (USA CHICAGO 1123) as follow:
C D E
Payment Lease 1123

Any suggestions?

Regards,
Dan

 

[venkat1926]

your example gives only three column data (which columns not clear) whereas there are five headings