Converting from one table to another

**function** · 10-05-2007, 04:05 PM

well,
in the last few years the tips in this forum always soved all of my problems without any need to post anything of my own.
now - i'm in trouble. i hope you can help.

my question is best asked using the picture attached.
i need to create a new table (right) from the table on the left.

i can phrase this questions SQLly...

SELECT COLA, COLB
FROM TABLE
GROUP BY COLA, COLB;

Thanks,
Oded.

**VBA Noob** · 10-05-2007, 05:04 PM

See if this helps

=IF(SUMPRODUCT(--($A$1:A1=A1)*($B$1:B1=B1))=1,1,0)

Assumes Data in Col A and Col B
Filter on the 1's

VBA Noob

**Flintstone** · 10-05-2007, 05:07 PM

Hello Oded:

This should do it.

Matt

**function** · 10-06-2007, 11:00 AM

Hi Flinstone!

I really appreciate you taking the time to solve my problem. i tried to solve it by myself unsuccessfully. the truth, i didn't understand the solution - i just copy pasted it and it works wonderful!
thank you very much!
oded.

**Flintstone** · 10-06-2007, 06:55 PM

Glad to be of help.

Actually VBA Noob has the better solution, replace the formula in column D with this one and delete the contents of column C.

Please Login or Register  to view this content.

Matt

**VBA Noob** · 10-07-2007, 05:17 AM

Thanks Matt (Flintstone) for saying so.

VBA Noob

**function** · 10-09-2007, 07:40 AM

i actually combined the two and it work perfect.
thanks again.

**VBA Noob** · 10-09-2007, 08:56 AM

function,

Glad it was useful

VBA Noob

Converting from one table to another

LinkBack

Thread Tools

Rate This Thread

Display

Converting from one table to another

Thank You Flintstone!

Thank you both

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions