INDEX MATCH Error

**oeldere** · 08-16-2014, 04:43 PM

#5 from cbatrody

In Column M: RANK(L10,$L$10:$L$26,0)+COUNTIF($L$10:L10,L10)-1

Change the L in D =>

In Column M: RANK(D10,$D$10:$D$26,0)+COUNTIF($D$10:D10,D10)-1

**rikapple** · 08-17-2014, 01:56 AM

Hi

This did work to an extent but only did the top three names the rest of the top ten was just #?N/A

Must be something simple im sure but not seeing it.

Rx

**rikapple** · 08-17-2014, 02:14 AM

I have included a sample file to explain the problem.

I am trying to create a table to each of the columns listed E - J.

Obviously from the offices in Column C.

Thanks again for any help.

Rebecca x