Find duplicate rows involving 2 columns with column 2 criteria

Hi

I would appreciate your input in identifying the same entry in column A that in column B has entries that are not zero or blank.

THEN

A. Use conditional formatting to highlight those records (highlight A and B column)
and beginning in A46
B. List the duplicates and count number.

Thanks

edit: ALSO include a formula for number of duplicate records, in this case 1.
(Excel 2002)

are you wanting this one time? or are you wanting to have an auto-updating output that updates when the list updates?

i would just use a pivot table based on your data.
put column A in the Rows section, count of column A in the Values section, and filter column B for everything that isn't blank. Then filter your count of column A to only list entries with a count greater than 1.

if you are not needing it to auto-update, then i am not sure why you would be opposed to a pivot table solution.
without any sample data uploaded, and with a pivot table solution not being possible, I can only give you the steps I would use.

1. Copy the entire contents of column A to a new column ( let say column F).
2. highlight this new column and remove duplicates.
3. insert the following formula in g1 and drag down: =COUNTIFS($A$1:$A$7,F1,$B$1:$B$7,"<>"&"")
4. sort by column g, and delete the rows where the formula only returns 1 (only one entry).


if you have issues, I suggest uploading a sample workbook so a solution can be provided for you right in the excel file.

trying to do this without formulas available in excel 2003 and beyond is..... well, beyond me.
but I did it two seconds in a pivot table. now all you have to do is.
1. replace the data in your list of mock data with real data.
2. change the range of the pivot table data source to extend to your whole data set.
3. copy over the entries with a total greater than one from the pivot table to your list.

you'll need someone else's help with the conditional formatting, as all the formulas I would use are not available to you.
I suppose one way would be to create an if statement that returns true if:

the entry in column A exists in your duplicate entry table, and the value in column B is >0

I added that to the file, and hopefully that works.