Recent content by Sajan

Hello Karthik, Try: =SUMPRODUCT((UsersList=B2)*(FromTime<=C2)*(ToTime>=D2)) It will provide a count of overlapping times. Anything with a count greater than 1 would be a duplicate. Cheers, Sajan.

Hello, To handle cases where the criteria for Issue and Sector are not met, use a formula like the one below: =LOOKUP(SUMPRODUCT((IssueList=Issue2Find)*(SectorList=Sector2Find)), 1/FREQUENCY(-99999, -SUMIFS(Sales, IssueList,Issue2Find,SectorList,Sector2Find, NameList, NameList)), NameList) It...

For the benefit of other readers, I am posting the response I sent to Supat based on his private query to me... ------------- Hello Supat, It is best to ask questions in the general forum since I don't always get time to check this forum in a timely manner. Here is something quick and dirty...

Hi, Here is one more approach: =LOOKUP(2,1/(B1:B4<3),A1:A4) Cheers, Sajan.

Hello, Here is one more approach to get the ID of the fruit with the highest Q1 revenue: =LOOKUP(1, 1/FREQUENCY(-(9^9), -MMULT($C$4:$H$63,TRANSPOSE(--(MONTH($C$3:$H$3)<=3)))*('Unit Price'!$C$4:$C$63)), $B$4:$B$63) enter with Ctrl + Shift + Enter Cheers, Sajan.

Hi Luke, Congratulations on becoming a dad! (I somehow missed your original post on the subject!) Even with all of the sleepless nights (and I can relate since my son is now 17 months old), it is an absolutely joyful experience! Enjoy! Regarding your age, based on your "profile picture", I...

Congratulations Somendra! It is very impressive that you surpassed 1000 posts in a few short months! Keep up the great work! -Sajan.

Hi Villalobos, If your question has been answered by Jake, please feel free to ignore these questions... If not, I would be interested in learning a little more before offering any suggestions. I am still not clear on the relationship between column C and column D. Are you saying that the...

Hello Villalobos, Can you clarify how column D is to factor into the calculations? In the sample workbook, the explanation on the right does not reference column D, whereas your sample formula does. -Sajan.

Hi Lori, Thanks for revisiting an old problem. I had actually forgotten about it... Since I am a strong believer in inductive chain learning, a good one to revisit! I have not had a lot of time to visit this forum recently... but I am looking forward to studying the above formula in the next...

Hi, The definition of what is considered Advanced Excel might vary from person to person. For example, I consider VBA programming pretty basic, while many formulas require more thought. I think another way to look at usage is the degree to which Excel is used in a situation, and what type of...

Hi, If you hold down the Ctrl key while clicking a cell, Excel will automatically insert the delimiters between arguments in the SUM function. For example, =SUM(A1, B1, C2, X3) can be setup by typing "=SUM(" and then Ctrl clicking the required cells or ranges. Once you have selected your cells...

I have Save Undo Redo

Hi, Can you elaborate on what you mean by analysis and design phases? Are you referring to the life cycle of a software development effort for an inventory application? Or something else? If you are referring to software development, there are a lot of sites that explain that. If you are...

One thing I forgot to mention... the above formula would count a match if values are out of sequence... i.e. {A";"B";"C"} and {"C";"A";"B"} will match. If you need to respect the position of a value in the array, the above formula will need to be tweaked.