Peter L.
Reputation
807
Top tag
Next privilege 1,000 Rep.
 Jan 11 awarded Yearling Jan 11 awarded Yearling May 2 awarded Constituent Apr 22 awarded Caucus Jan 11 awarded Yearling May 20 awarded Fanatic Mar 23 comment How can I get the hex value of an 8 row column with depending on background color? +1 for the great effort and samples! Mar 23 comment Computing an average based on conditional criteria So what is your question? Mar 11 awarded Enthusiast Mar 10 comment Find Array Intersection of 2 Match Array Formula Now I don't understand what do you mean by intersection. And `since space is operator for intersection of range` is also a discovery for me) Mar 10 comment Find Array Intersection of 2 Match Array Formula Are you sure you're able to enter this function as it is typed above? Mar 8 comment Excel formula sorting data by date but group by column value @Grimlockz please see the updated answer Mar 8 comment Excel formula sorting data by date but group by column value @Grimlockz it does make sense, but please provide one more sample with more groups and elements as your desired output: I got the idea, but nuances such groups placement and dates inside groups placement are still not precise. Mar 8 comment Excel formula sorting data by date but group by column value `but the different groups aren't sorted chronologically` - what is the exact sorting criteria here? Mar 8 comment Excel formula sorting data by date but group by column value @Grimlockz I don't understand exactly what you mean, but perhaps you may want to swap sorting order of columns. For the sample and expected result you provided the solution works as expected. Mar 8 answered Excel formula sorting data by date but group by column value Mar 4 revised How to use “=IF” in Excel impoved formatting Mar 4 reviewed No Action Needed Subtract files from one another recursively between two similar directories Mar 4 comment How to use “=IF” in Excel For the details see: Accepting Answers: How does it work? Mar 4 suggested approved edit on How to use “=IF” in Excel