747 reputation
1313
bio website a1qa.com
location Minsk, Belarus
age 32
visits member for 1 year, 6 months
seen Jul 24 at 10:23

QA Manager with comprehensive, cold-blooded, goal-driven approach, determined in achieving success for any project I'm involved in.

Tech strengths and expertise:

  • Excel: from pure-formula to advanced 3rd-party based integrated solutions for data access, gathering, analysis and processing.

My greatest SO achievements so far:


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 suggested edit on How to use “=IF” in Excel
Mar
3
answered Is there a way to add multilevel list to excel
Mar
3
awarded  Critic