Reputation
7,327
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 9 23
Newest
 Reviewer
Impact
~594k people reached

8h
comment Easy Sum formula
Please mark this as the answer if you want to say thank you.
1d
answered Change pivot table layout into “more columns”
1d
answered What is this drop down selection thing and how do I select an option from the keyboard?
1d
answered Easy Sum formula
1d
revised Easy Sum formula
formatting
1d
revised Excel Drop down lists
added 734 characters in body
1d
answered Excel Drop down lists
2d
revised How do I fix cells whose colors are mismatched with the ones next to them?
added screenshot
Jul
26
comment Count rows matching criteria for every row in excel
Make up your mind. You can't use one product and ask a question about another. Excel and Google spreadsheet are not the same. And, Yes, there IS a way to build column D (and C) dynamically in Excel. Use a Pivot Table, as I have shown above. Refresh the pivot table when you add more data to the data source. I don't understand what you mean with "I am realy telling the forum look at C2, C3" etc. What forum?
Jul
26
answered Count rows matching criteria for every row in excel
Jul
23
answered Searching for multiple sub-strings within a single parent-string
Jul
21
comment Counting number of each item assigned to customer with unlabelled columns
Can you post the Countif() formula you would use for that? Countif() only has one condition. If anything, Countifs() could be used, but the ranges need to be the same size for each condition, so you would have to add several Countifs() function results together. Or, what exactly did you have in mind?
Jul
21
answered Counting number of each item assigned to customer with unlabelled columns
Jul
15
comment How can i add numbers using sum function in vba between ranges
Why the loop? You are overwriting sumx with every step of the loop, but you are not using the result. It does not make sense.
Jul
14
comment How can i add numbers using sum function in vba between ranges
What is the purpose of the nested loop? Please provide more context. Or don't. Unless you want to get help.
Jul
14
answered Excel 2010 - Vertical alignment of text simply not working
Jul
14
comment How can i add numbers using sum function in vba between ranges
It is not clear what you are trying to sum. What is the value of lastrow and lastrowx? More context, please.
Jul
13
answered Possible to create and switch between views/configurations of a pivot table
Jul
13
comment Filtering data in Excel using multiples of a number
@fixer1234, why don't you post that as an answer instead of a comment. You have my upvote.
Jul
7
answered VLOOKUP where the column to look for is a drop down list?