LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 75
Default Last Value Greater than Zero in a column

In a column of 121 numbers which can be positive or negative or zero, is
there a function to find the last positive value in the column?

Or do I need to build a UDF?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to average a column of numbers that are greater than 0? JimNColorado Excel Worksheet Functions 13 December 11th 07 01:22 AM
Greater than less than total in a column cream puff Excel Discussion (Misc queries) 1 October 8th 07 09:54 PM
Sum values greater than x and less than y in a column Rookie_User Excel Discussion (Misc queries) 1 July 20th 07 05:19 PM
How do I search an array for values in a column greater than zero letsagmj Excel Worksheet Functions 0 July 26th 06 02:41 AM
Adding a column based on greater than a date Toni G. Excel Worksheet Functions 4 March 17th 05 08:06 PM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"