❤😢🎉😊

Kid L.K.G Descending order3

Need to find 2nd or nth instance with "multiple conditions" with index _small_ if _row function in excel. I tried to use the below formula, but it is showing errors =IF(ROWS(DEntry!$S$6:$S6)>H$1,"",INDEX(DEntry!E:E,SMALL(IFS(tbl_Data[Mount Dt],"<="&G1,tbl_Data[Mount Dt],"<>"&"",tbl_Data[Remove Dt],"="&"",ROW(tbl_Data[Mount Dt]),ROWS($E$6:E6)))) Plz help

Thankyou so much, to the point and great explaination

Good job on explaining things

Thank you, it was really helpful for me

Aapki video ka volume kuch bhi sunai nahi de raha isliye kuch bhi samaj nahi aa raha

Very helpful

Can you please show the reverse of this sir. I have date in rows and need to bring it to column.

not for beginner .

Sir. I want to use this formula. Nestedindex sum please share more tutorials on this topic. Waiting reply plz. Regards.

Good morning. Your nestedindex tutorial is very informative and very helpful to understand but I want to know more examples regarding nestedindex with sum topics. Awaiting please . Regards. Naeem.

hello. do you know a way I can type in bundles into a very big spreadsheet when I have 2 items that I bought separately but sold them together.. I don't want to make a separate spreadsheet

Bro aur videos kyu nhi daal rhe ho

I need index match with multiple dates condition like start date and ends date

Thank you very much it helped me a lot

very good info same my lots of time doing manual work

Thanks Buddy

Its F4 key to lock ,not A4 key

Thank you Bro.After Searching for hours you were the one who solved my problem.

how to search at once using list of names in sheet full of information and return the text searched in one formula?

Poor english plus poor accent plus poor explanation

Thanks for this tutorial my friend! I was able to do my task today, badly i need to download all the deliverables list with link from aconex system and then vlook up with our existing internal drawing register. Because of this video I was able to put the link in just a seconds! normally by doing the link, you have to copy the link from aconex and paste it one by one each drawing number. With this tutorial my work was done in just 5 minutes. We are talking about a thousands of drawings with aconex link. Because of this video, I am now your subscriber!

How to write a code for combination of all results in excel using vba

Yeah… once you get to 20+ arrays this formula definitely crashes

Thank you man this is REALLY HELPFUL!

Thanks a lot, man!!! 😎

Hello sir, if I have 53 table array than what sir, how many iferror formula apply ?

Thankyou ❤

finally ! thank you can you just explain why you put K5 please ? Can we use juste de number of the column directly starting from our fist colum in the table (in you case B1 so if we want to sum every 3th cell we put 3 instead K5) ?

The use of 4 in the formula was not unclear

Is 4.50% interest rate in month or year?

thanks, worked.

Plz msg back i need help

Unable to use this formula

this isnt vba...

Hello, I would like to split a document by destination (for example) and create automatically various specific files (for each destination) with the relevant pivot chart. How to do to update the data source of the new pivot charts each time (Spain, Italy, France...) ? As they keep the original data source with all destinations (Europe). Thanks Dim pt As PivotTable Dim MyData As Excel.ListObject Set MyData = Application.Range(Europe).ListObject For Each pt In ActiveWorkbook.Worksheets("Chart - City").PivotTables pt.ChangePivotCache ActiveWorkbook.PivotCaches.Create _ (SourceType:=xlDatabase, SourceData:="MyData") Next pt

How to get multiple matches row wisely when this blue ,green and red kept downward (now in this video it’s rightwards)

Thank you for this sir! Please update me if you have a shorter formula for this because what if i have 20 more table column? I'm afraid my excel will crash bc of formulas.

Thanks a lot . Well explained

Y

Can it be used with match index formula ?

how to get the annual interest rate, if you are paying every 10 days or 3x monthly

Thank you

my goodness life saver haha

how do i find multiple search terms in excel?

Y its coming in minus for me

Lol cool, thanks

Well done. Thank you.

Thank you! Great example. How about if the available dates are not in one column but in different cells here and there?