unearthed Posted April 26, 2017 Share Posted April 26, 2017 Hi all I have a series of objects where I'm entering plant species codes (e.g.ULance_CopBru.Meu) into Object_Info_Data and then doing calculations in a worksheet - =Area etc. How do I extract the Name from e.g. =Area(N='ULance_CopBru.Meu') and print it to the same line in the worksheet? Quote Link to comment
Pat Stanford Posted April 27, 2017 Share Posted April 27, 2017 Since you are using the Name field, that means that species can only be in the drawing once as each object must either have no name or a unique name. Better to add a custom Record/Field combination and use that for the name, then you can get a total of the area of all the different plants with the same species. You probably also want to read up on database rows. If you want to continue with what you are doing, do it the other way around. Rather than type the name into the =area function, type the name directly into the cell where you want the name (Maybe A1) then set the area formula to =Area(N=A1) Ask again if I misunderstood your question. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.