I have a series of columns containing numbers and zero values, I need to read these values but display only non zero valuesin a diferent column, please see below.
A
1 0
2 0
3 9
4 12
5 7
6 0
7 0
8 0
Need to display in A column only as follows ignoring zeros
10 9
1112
12 7
Please help
try in B1
then drag
Please Login or Register to view this content.
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
of course if this list needs to be from the top down and not matching you could do this
(entered with CONTROL+SHIFT+ENTER)Please Login or Register to view this content.
see attached
values.xlsx
Hi norms,
try this solution explained in attachment. If I well undestand you need a new column ignoring zero values and without blank lines...
C column is result column... be careful, B column defined as array.
Regards
If a post helps press star sign 4 my reputation
mnjofra that is a nice attempt although you might want to avoid the use of indirect. in large books it can really slow down a spreadsheet.
Hi twiggywales thank you for the answer but I cant seem to make it work if I start the table at a different row that 1, I am working in a sheet at row 1073. It works in any column if the values start at row 1 and run down.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks