View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default existing unique value formula help (index(match(countif)))

It's likely that the numbers in Column E are being recognized as text.
Try the following...

1) Select an empty cell

2) Edit Copy

3) Select Column E

4) Edit Paste Special Add Ok

Does this help?

In article . com,
wrote:

okay i'm not getting an error message anymore, but it's not bringing up
the right information. the formula is bringing up values from "d" with
zeros in "e"; it misses values from d with positive values in "e" and
finally, when you delete one from the top of the list, the rest of the
cloumn should adjust, but it isn't... any clues? if not it's okay, it's
not that much manual work, the original formula is a big help for me
though. thanks again.
jason