The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 last value of one coumn
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Dodel1234567890

2 Posts

Posted - 11/05/2012 :  05:03:46 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release: OriginPro 8.6.0G (64bit)
Operating System: Windows 7

Hi guys,

sorry for my probably silly question... but I don't know how to help myself.

I have 2 books
Book1: in column A alre a lot of values, but it varies how many values are in this column

Book2: I want in column A in the first cell the last value of the book 1, column A
I know how to get the first value or the 10th or whatever... but as I don't know how many values are there, I can not write a specific number, and "end" instead of a number doesn't work.

I hope you can help me. Thank you in advance!

bye

Kathy_Wang

China
159 Posts

Posted - 11/05/2012 :  05:10:12 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

You could define column A as a range variable, get its size and return to the last value of it. For example you could run the following labtalk script:


range rr=[Book1]Sheet1!col(A);
int index=rr.GetSize();
rr[index]=;//Return the last value in column A




Kathy
Originlab
Go to Top of Page

Dodel1234567890

2 Posts

Posted - 11/05/2012 :  05:19:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Great!
Thank you...
that was it what I was looking for - I just didn't know how to tell Origin what to do! :)

Hope you have a good day, I have a smile in my face now ;)
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000