Search results

hello Can anyone help me find the column number of the largest value in a set of values from A1:A7 I want to move some data from sheet1 to sheet2 using vlookup. but i want that to be the largest 3 numbers (only the largest 3) from the values in row 2:2

thanks guys... have another problem.... in the range in which there is 1 number or 2, the formula is resulting in #NUM! error... only when i put a 3rd number it shows the average... I want it to show the average even if I put 1 number or 2... it should take maximum of 3 numbers which is the...

Hello Guys... Can Anyone help me with this # A B C D E F - - - K 1 23 25 0 0 80 52 ? 2 In K1 I Want to find the average of the last 3 figures excluding 0... meaning the average of BEF (25+80+52 / 3) and...

hello again The #NUM! Error has been fixed... mistakenly I wrote $B$50 instead of $B$2 (=IF(ROW(Sheet3!$A2:$A50)-ROW(Sheet3!$B$50) Anyways than you very much... If you have time suggest me what to do for the named range problem.. Bye

Hello Again Hui I've Changed The formula and have got nearly to what I was thinking... But still need help.... Here's the formula I used in the next sheet...

Hello Hui I tried your post to my 1st question and tried it just now which was successful.... thank you... what I want to do now is to take the whole column E to a new sheet and leave the other sheet as it is... The idea is that in a list of inventory items, only the items I mark with an "X"...

Thanks Hui... That worked well but I thought I could use it with the previous post of mine but it didn't work with that.... Hope U remember my last post.... What I'm trying to do is that Sheet1 contains the database and move the entire column E to sheet 2 pls help me

Hello Suppose In sheet1 A1:A5 are given numbers say 1 to 5 and its named as numbers What I'm trying to do is in sheet2 I want to write a formula in B2 the value in sheet1 A4 (not the =Sheet1!A4 formula) I want a formula with the named range

Thanks Luke M... It's not an array but works perfect... :-)

it still don't work... I don't know what's wrong with that.... did u really got it... where am i wrong at???

WOW.... I'll try that again... thank you Hui

Nop... tried that too... doesn't work the way I want it to...

Hello Everyone… Can Anyone Help Me With This Situation… What I'm Try To Do Is: In Column B When I marked with an "X", Column Should Show What Is In Column A... A Bit Comfusing But Here Are The Formula I'm Using. Say In A2 = Product1 In G2 =IF(B2<>"",ROW(),"") In...