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
 Find the first and last non-zero index in a column		  New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1280 Posts
Posted - 10/18/2026 :  04:44:19 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
OriginPro 2026b (64-bit) 10.3.5.222
Windows 10 Pro for Workstations 10.0.19045.7725

Greetings!

How would I make two formulas to search for row numbers (indices) of the first (from the top) and the last non-zero element in a worksheet column?

I plan to use the formulas as User Parameters in Label Rows.

Thank you.

---
Andrey
   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