Help with finding a row number

  • Thread starter Thread starter JRB
  • Start date Start date
J

JRB

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
 
You could use Data>Advance filter and select unique records only.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox filtering 2
Search and Replace, or Add New Row 5
Copy a range instead of just one row but with condition 8
finding unique values and removing all duplicates 4
How to find a matching row and Insert Data 4
Count unique numbers multiple criteria 3
Find Specific Rows in Range and Create New Tab 18
VBAscript for data matching excels 0

Back
Top