ExcelBanter - Help with finding a row number

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help with finding a row number (https://www.excelbanter.com/excel-programming/375329-help-finding-row-number.html)

JRB

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

[email protected]

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

All times are GMT +1. The time now is 10:04 PM.