Datetag example.xlsm
What would be a way to tag the ID and name fields at the side of the data which belongs to the name and ID? The changes are in column F and G.
I was thinking of doing a find on the name/ID then finding it's nearest start and end to find the range for the tagging then find after once the tagging is done but I'm not sure how to go about doing that and if it is the best way.
Original and desired outcome worksheets in the attached file.
Last edited by dwx; 10-12-2013 at 02:12 PM.
Dutch F3 = [CODE=ALS($A3="Company:";VERSCHUIVING(F3;3;-4;;F2)][/CODE]
Englisch F3 =See the attached file.
=if($A3="Company:",offset(F3,3,-4,,),F2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thank you for the rep(utation).
So I gues the question is solved.
Will you mark the question as solved?
another alternative in F3 & G3:
=LOOKUP(2,1/(A$3:A3="Company:"),B$6:B6)
=LOOKUP(2,1/(A$3:A3="Company:"),B$7:B7)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks