Thread: [Solved] Complex array formula
View Single Post
 
Old 02-03-2012, 03:17 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi Andrei,

Fair enough, if you're happy then I'm happy.

Incidentally, if you happened to want to extract a list of values greater than zero, in the order that they appear, then I've attached an example for you.
Code:
=IF(COUNTIF($B2:$F2,">0")>=(COLUMN(G2)-COLUMN($G2)+1),
    INDEX($B2:$F2,SMALL(IF($B2:$F2>0,COLUMN($B2:$F2)-COLUMN($B2)+1),COLUMN(G2)-COLUMN($G2)+1)),"")
Regards,
Colin
Attached Files
File Type: xlsx Sample_data_.xlsx (14.4 KB, 9 views)
__________________
Colin

RAD Excel Blog
Reply With Quote