excel - Showing index of duplicated values -


tim     9/22/2015       joe     9/22/2015       joe      3          tim      2 frank   9/22/2015       tim     9/22/2015       tim      1          frank   #n/a joe     9/21/2015       karl    9/22/2015       karl    #n/a        joe      1 tim     9/21/2015       kim     9/22/2015       kim     #n/a        tim     #n/a luke    9/22/2015       james   9/22/2015       james   #n/a        luke    #n/a 

i trying index of duplicate name in other table. example, third table shows joe located third in first table, tim first, no karl, no kim, , no james.

i used match(name looking for, names in other table, 0).

the problem tim available twice in table #1, table #3 showing index 1.

i trying create schedule check , date overlapping. function other match?


Comments

Popular posts from this blog

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

android - How to create dynamically Fragment pager adapter -

1111. appearing after print sequence - php -