| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find double instances of a row
Hi! I am new at Excel programming but not at VBA(I usually use Access). Here is my problem: I have a huge worksheet whith some double rows in it (all cells are indentical). I need to find them and hide the second instance. Can anyone help me with a macro that can do it in Excel 2000/2003? Thanks in advance Fran -- fran_dk ------------------------------------------------------------------------ fran_dk's Profile: http://www.excelforum.com/member.php...o&userid=32435 View this thread: http://www.excelforum.com/showthread...hreadid=522084 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find double instances of a row
Have a look at DataFilterAdvanced filter
HTH -- AP "fran_dk" a écrit dans le message de ... Hi! I am new at Excel programming but not at VBA(I usually use Access). Here is my problem: I have a huge worksheet whith some double rows in it (all cells are indentical). I need to find them and hide the second instance. Can anyone help me with a macro that can do it in Excel 2000/2003? Thanks in advance Fran -- fran_dk ------------------------------------------------------------------------ fran_dk's Profile: http://www.excelforum.com/member.php...o&userid=32435 View this thread: http://www.excelforum.com/showthread...hreadid=522084 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find double instances of a row
I looked at "Advanced Filter" ... I need to know the kriteria for the search and I don't :( I have 41 columns and about 1000 rows. Out of those I might have 5 double rows. It is a pain to find them manually. That is why I would like to find some kode to get them. Fran -- fran_dk ------------------------------------------------------------------------ fran_dk's Profile: http://www.excelforum.com/member.php...o&userid=32435 View this thread: http://www.excelforum.com/showthread...hreadid=522084 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find double instances of a row
Leave the Crtiteria field empty
-- AP "fran_dk" a écrit dans le message de ... I looked at "Advanced Filter" ... I need to know the kriteria for the search and I don't :( I have 41 columns and about 1000 rows. Out of those I might have 5 double rows. It is a pain to find them manually. That is why I would like to find some kode to get them. Fran -- fran_dk ------------------------------------------------------------------------ fran_dk's Profile: http://www.excelforum.com/member.php...o&userid=32435 View this thread: http://www.excelforum.com/showthread...hreadid=522084 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find double instances of a row
and select unique records only
|
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find double instances of a row
Thanks for yoour help. I got it to work after a few trials Fran -- fran_dk ------------------------------------------------------------------------ fran_dk's Profile: http://www.excelforum.com/member.php...o&userid=32435 View this thread: http://www.excelforum.com/showthread...hreadid=522084 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to find instances of a word | Excel Discussion (Misc queries) | |||
| find instances & report neighboring values | Excel Discussion (Misc queries) | |||
| find all instances of text in string | Excel Programming | |||
| Find all instances in formula string | Excel Programming | |||
| Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
Linear Mode
