Reputation
Next privilege 200 Rep.
See reduced ads
Badges
1 3 15
Impact
~33k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Feb
3
comment How to flag rows with the pattern non-blank, blank, non-blank using Excel
This is a great response and works for the example I illustrated. Do you have a version that will work with either numeric or text? No, is an ok answer since I only recently updated my post. BTW my apologies for forgetting to respond earlier.
Nov
14
comment How to flag rows with the pattern non-blank, blank, non-blank using Excel
Will do. But I won't be able to test it until I'm back in the office on Monday.
Nov
12
comment How to flag rows with the pattern non-blank, blank, non-blank using Excel
@fixer1234 yes that is correct the first situation would also not be flagged.
Nov
12
comment How to flag rows with the pattern non-blank, blank, non-blank using Excel
Only rows with 1 or multiple consecutive blank columns in-between non-blank columns should be flagged.
Nov
12
comment How to flag rows with the pattern non-blank, blank, non-blank using Excel
@fixer1234 Great questions. 1) This would not be counted. 2) Value only in one FY is possible. That case would not be flagged.
Nov
11
comment How to flag rows with the pattern non-blank, blank, non-blank using Excel
My apologies. I edited my post.
Oct
5
comment How do I stack multiple columns into one?
Thanks for introducing me to Power Query. As in my other post this will also work. I am not as worried about requirement #3 since Power Query, I found out, has an alternative way of accomplishing the same thing. If you submit your response as an answer I will accept it.
Oct
5
comment Need unique count of text from multiple columns by category
It was as easy as emailing the file to someone who already has Power Query add-in installed. BTW Power Query was very easy to install (only took a couple of minutes). +1 for introducing me to tool that not only solved this problem but will solve another similar issue. I see myself using this tool a lot in the near future. I would give you +2 if I could. Thanks again!
Oct
5
comment Need unique count of text from multiple columns by category
I have been playing with Power query a bit this morning to see if this will really suite my needs. So far it seems that it will. I am just trying to figure out if sharing a .xlsx with Power queries is as easy as sending the file. Obviously whomever I share with will have to have the Power Query add-in.
Oct
5
comment Need unique count of text from multiple columns by category
This is a great solution! I heard of Power Pivot (not a serious user, played w/ it a bit before) but not Power Query. At first I thought this was going to be a more sophisticated SQL editor then MS query which would have been great as well since I am well versed in SQL. But this is way better!
Oct
5
comment Need unique count of text from multiple columns by category
@wbeard I don't understand how your proposed solution would give me the result I am looking for. For example the last three rows would end up as: zooyup, doehgg, doe which would give me 3 when the result is 4 (refer to my response to MichaelFrank).
Oct
5
comment Need unique count of text from multiple columns by category
@MichaelFrank For Cats the 4 unique labels are: zoo, yup, doe, hgg. Dogs is 2 not because there are two rows with Dog (that's coincidence) but because the two unique labels are: doe and zoo.
Oct
5
comment Need unique count of text from multiple columns by category
@DavidDai Today I can accomplish what I need by manually stacking all Label columns (+category repeats in separate column) then inserting a pivot table on that data set (Category and Label in rows) then copying and pasting that and inserting another pivot table on that to get unique labels by Category. I'm looking to make my process easier since it's something I do often.
Dec
20
comment PowerPivot Bar is grayed out
I figured out how to create a new measure which is ultimately what I was trying to figure out how to do as a next step. But it feels like I ought to be able to do this from the ribbon. I can't. To add a new measure I have right click on the table name in the PowerPivot Field List window. Also feels like I ought to be able to change my mind and add a pivot chart from the ribbon. But again I can't. I have to go back to the linked PowerPivot data table. What am I missing here?
Dec
19
comment PowerPivot Bar is grayed out
But what if I want to add calculated measures?
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
You know I was wondering about that last scenario but didn't even think to press my luck and ask. Thanks again. Great job!
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
Awesome that works! Please post this as an answer and I will accept it.
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
BTW I tried CSE and using sumproduct and using a range instead but still didn't work: {=SUMPRODUCT(COUNTIF(A27:A27,search_items1))}
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
will what I'm trying to do is for each cell (thus the single cell reference instead of a range) count number of instances for example cell A1 might have "LBNL" or "LBL" or both. In the case of the first two the formula should return 1 and in the case of the second 2. For me it only works for the first item in the name range. So it will count a cell with single text of "LBNL" but if it has "LBNL LBL" it will return 0 instead of 2. Are you sure its working for you? Does it return 2 for you in the latter example?
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
btw I am trying to avoid VBA if at all possible