| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with finding a row number
I have a list of Invoices - three of the columns of data are Account,
Supplier & Invoice Number Using vba I would like to find the number of the row containing a specified, unique combination of the three fields What is the best way to achieve this Regads & TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with finding a row number
You could use DataAdvance filter and select unique records only.
JRB wrote: I have a list of Invoices - three of the columns of data are Account, Supplier & Invoice Number Using vba I would like to find the number of the row containing a specified, unique combination of the three fields What is the best way to achieve this Regads & TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding first number in a row | Excel Worksheet Functions | |||
| Finding number less than 1 | Excel Discussion (Misc queries) | |||
| Finding Number Within Range Then Copying Data Below Number to Cells | Excel Programming | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
| Finding MAX number (excluding a particular number) | Excel Programming | |||
Linear Mode
