As for the proposal in post #6, change the formula in columns B:F to read:Formula:
=IF(A2="","",IF(INDEX($I$1:$I$11,COLUMNS($B$2:B$2)*2+1)="",A2,IF(INDEX(ResponseEdits!D$2:D$21,MATCH(A2,ResponseEdits!$C$2:$C$21,0))=INDEX($I$1:$I$11,COLUMNS($B$2:B$2)*2+1),A2,"")))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
JeteMc That is perfect!!!!!
Thank you both so much!!! It's working like magic now!!!
I wasn't certain if Excel could even do this.
You both are lifesavers!
Thank you again!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks