i need to return the farthest right vlaue for each of the colomns on the mating tab. returned to teh main colomung
ie.
B2 = Last Pairing
( find the farthest right vlaue for R2 in the pairing column (E, I, M, Q ect>
and the same for each of the otehr main titles other than the paired with column
Attachment 269287
It might help if you added some data and showed a few sample answers ?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
ok no problem will do
Attachment 269293
has sample data in the mating sheet
OK not sure if this is what you wanted?
=IFERROR(INDEX('Mating Sheet'!B2:AZX2,1,COUNTA('Mating Sheet'!B2:AZX2)-1),"")
no..its giving me a circular reference now wiht that
what i need is like in row 2 it returns the respective data for the farthest right of eahc of the specific colomuns
Date last paired is the farthest right paired column
date of last sac is the farthes right sac data
last sac size is the farthest right sac size for each of the rows
Thats exactly what it is doing. I put that in Molt Sheet C2, copied down.
Where did you put it, and where do you want the answer to be?
not teh molt sheet..in the mating sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks