How to filter the names from a list of names without duplicates

**jayait2000** · 10-07-2012, 03:13 AM

Hi,

I have a daily status report that need to filled by the QC team on everyday basis as and when they work on the loans. This coumn B shows loan numbers and column C shows Processors name. Now I need to create a sheet to classify the number of errors for each processors without the names being dupicated. (I have marked in blue). The issue is the name of processors will vary every day and we dont have a set of fixed processors. Unless I have a list of processors how can I count the number of error etc etc without the names being duplicated. Is there any way to automate this using any formule so that the column J will copy processor name without duplicates?

Note: I cannot use delete duplicate option

Thanks
Jaya

**oeldere** · 10-07-2012, 03:24 AM

Maybe, with an pivot table.

See the example.

**dilipandey** · 10-07-2012, 03:32 AM

Hi jaya,

Try using below array formula:-

{=IFERROR(INDEX(Processor, MATCH(0, COUNTIF($J$1:$J1,Processor), 0)),"")}

Where "Processor" is a defined name.. press Ctrl + F3 to see the logic used there.

See attached:- New Microsoft Excel Worksheet.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**jayait2000** · 10-07-2012, 12:46 PM

Hi DiliPandey,

wow!!! how did you do that? It works fine on the attched excel sheet. But when I used the same on daily status report it doesnt. The reason being I may not be using it in correct way. I did define "Processor" using Ctrl+F3 but it didnt work. The actual report 2 sheets so I need to map the values from one sheet to Error sheet. Sorry to bother you... Can you please help me. I have attached the report and the column is marked in blue (sheet names errors)

Thanks
Jaya

**dilipandey** · 10-08-2012, 01:54 AM

Sure jaya... use below formula:-

Formula:

Please Login or Register  to view this content.

You need to enter this using ctrl shift enter.

See attached :- Daily status report.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

**jayait2000** · 10-10-2012, 05:46 PM

Got it.....!!!! Thanks thanks thanks a lot Sir

You were of great help

**dilipandey** · 10-11-2012, 04:24 AM

You are welcome Jaya....

Cheers

Suggest you to mark this thread as [SOLVED]... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

How to filter the names from a list of names without duplicates

LinkBack

Thread Tools

Rate This Thread

Display

How to filter the names from a list of names without duplicates

Re: How to filter the names from a list of names without duplicates

Re: How to filter the names from a list of names without duplicates

Re: How to filter the names from a list of names without duplicates

Re: How to filter the names from a list of names without duplicates

Re: How to filter the names from a list of names without duplicates

Re: How to filter the names from a list of names without duplicates

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions