Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List the UNIQUE certain fields from the database
Dear Experts,
Please help related to the above subject. From this discussion, got the following formula which is work well and faster for small of database. =OFFSET($G$1,MATCH(0,MMULT(--TRANSPOSE(TRANSPOSE(DATA)=I$1:I1),ROW(INDIRECT("1: "&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1) where $G$1, the first row of DATA. how to convert it to VBA as this time i have a huge database. for Tab Data, Advanced, Unique Record only (works well also, but i need the VBA). basically we would like to do similar like this: Data Sample Vendor Name A B F B C E E E A the Result of Unique Vendor will be A B F C E TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database fields in Excel? | New Users to Excel | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Filter unique on key fields only | Excel Worksheet Functions | |||
List external database Tables and Fields | Excel Discussion (Misc queries) | |||
Vlookup for non-unique fields | Excel Discussion (Misc queries) |