Search results

Hi @Nrpatel You can use sumif for this. =SUMIF($A$8:$A$128,"<="&D3,$C$8:$C$128) Thanks, Vivek

Hi @santhoshkunder, Apology for delay in reply.. here you go =ROUND(IF(A2-ROUND(A2,0)<$I$1,A2-1,A2),0) Cheers! Vivek

Hi @santhoshkunder, Wish you a very happy new year! Here goes my attempt, I have edited cell I1 with 10:00:00 AM, hope that's fine =IF(AND(A2-ROUND(A2,0)+1>$G$1,A2-ROUND(A2,0)<$I$1),"Beyond ","Within ") Cheers, Vivek

Hi @Emmanuel Guido, A small attempt from my side for this problem, =IF(A2<A3,SUMIF(OFFSET(A3,,,IFERROR(MATCH(A2,A3:A$11,0),COUNT(A3:A$11))),A2+1,C3:C$11),B2) Assuming your data is in range A2:B11, you can use below formula. We take the value in column B if row below has same or higher level...

Hi @Nrpatel , Although I know experts have provided some wonderful solutions to your initial requirement, but here is an attempt from me, please check. This doesn't need a master sheet to be created. Best, Vivek

Hi Debraj, First of all apology as I have not followed general guidelines about how this community. This formula is working in a great way for me. Thanks a lot, I was really wasting a lot of time in doing this with Pivot Table. Regards, Vivek Goyal

Hi Faseeh, Thanks for reply But sorry its not working as needed. Its giving result for only one value where time is minimum in your above example it will give answer for only instrument A because time of A is min. If I try for B its resulting in "0" as answer. :( Regards, Vivek

Hello, I have a sheet which Contains Following Column A. Instrument Name B. Date C. Time D. Value I have to find Open Value for i.e. first value for that instrument & Close Value by choosing which latest Value. Could you please help me. Thanks a lot.

Thanks a lot Hui.

Hi I have a set of values say about 1000 out of that i want to delete the value which are not in range, in a way removing outliers .. I have tried calculating range, standard deviation but end up getting nothing is there a quick way... Thanks a lot for help...