Hello all,
I have a spreadsheet with some information in (see a sample in example 1) and I would like to populate the columns based on the entry at the end of the row. I'm really not explaining this very well (it's been a long day!), so if you have a look at example 2, that shows the desired result I am aiming to achieve.
Many thanks in advance.
Simon
Last edited by ssss2005; 10-27-2015 at 03:30 PM.
Try the attached
Please Login or Register to view this content.
Jindon,
Thank you very much, this does indeed seem to do exactly what I am after!
Maybe:
Please Login or Register to view this content.
Also seems to work perfectly John - Thank you
You're welcome. Glad to help out and thanks for the feedback.
Actually John, yours worked on the sample data but when I tried it with the full data it doesn't seem to work. In total there are 5 columns, columns A and B all seem correct but columns C, D and E are not working properly.Originally Posted by JOHN H. DAVIS
What do you mean by not working properly. What's not happening that you want to happen? How does Column E come into play in your scenario?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks