Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
index question
Thanks Max, i was looking for this formula
please give me solution if in col. c1,c4& c5 having value <=0 then i need answer for all three it would be 1&4&5 can it possible. Thanks find the payment number (column A) where the ending balance is <=0 Assuming data as posted in cols A to C In say, E2, normal ENTER to confirm: =INDEX(A2:A100,MATCH(TRUE,INDEX(C2:C100<=0,),0)) Adapt to suit -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index Question | Excel Worksheet Functions | |||
Question on index | Excel Discussion (Misc queries) | |||
INDEX / MOD() question.. | Excel Discussion (Misc queries) | |||
Index() & Row() Question | Excel Discussion (Misc queries) | |||
Index question | Excel Worksheet Functions |