L
Lise
Hi Biff - sorry your #1 Pain again!! I did put this in a thread but don't
think it went through.
all is working well (+ I've made some changes based on other tips from you
on previous notes) however there are still issues with duplicates.
Currently I have as an exampl
=IF(COUNTIF(Tasks!B$2:B$576,A59),INDEX(Tasks!A$2:A$576,MATCH(A59,Tasks!B$2:B$576,0)),"-")
On the tasks sheet row 59,60 and 61 column B are all the same which is the
same as the number listed on the current sheet in A59, A60 & A61 - but the
data I'm collecting from the tasks sheet in columns D, F & J (same rows)
change on each row which the formula isnt picking up
The formula gives the correct answer for A59 but when I drag down to use for
A60 and A61 it only provides the row 59 answers again.
Gosh I hope this makes it clearer Biff its the only way I can think to
clarify for you.
Any assistance as always appreciated
Lise
think it went through.
all is working well (+ I've made some changes based on other tips from you
on previous notes) however there are still issues with duplicates.
Currently I have as an exampl
=IF(COUNTIF(Tasks!B$2:B$576,A59),INDEX(Tasks!A$2:A$576,MATCH(A59,Tasks!B$2:B$576,0)),"-")
On the tasks sheet row 59,60 and 61 column B are all the same which is the
same as the number listed on the current sheet in A59, A60 & A61 - but the
data I'm collecting from the tasks sheet in columns D, F & J (same rows)
change on each row which the formula isnt picking up
The formula gives the correct answer for A59 but when I drag down to use for
A60 and A61 it only provides the row 59 answers again.
Gosh I hope this makes it clearer Biff its the only way I can think to
clarify for you.
Any assistance as always appreciated
Lise