Reputation
208
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 8
Newest
 Yearling
Impact
~15k people reached

Apr
28
awarded  Yearling
Sep
24
awarded  Autobiographer
Apr
29
awarded  Caucus
Mar
5
answered Excel countifs criteria neither this nor that
Mar
4
comment How to put conditional formatting in a cell from another excel worksheet
What is the question? Are you trying to summarize patient visits by month?
Mar
1
answered How to CONCATENATE with variable rows
Mar
1
answered What can an Excel table do?
Mar
1
comment How to create drop down column OR filters
If you can add a new column to the worksheet, the formula =OR($A2="X",$E2="X") can serve as the simple toggle filter.
Mar
1
comment How to CONCATENATE with variable rows
Is that exact formula you are dragging down? Are you certain there are no "$" in the formula?
Feb
25
comment Excel: identifying if all values in a row are not equal
You can do this without the helper column as well. Put =NOT(AND($C1=$D1,$C1=$E1,$C1=$F1,$C1=$G1)) directly in the conditional formatting formula.
Feb
23
awarded  Tumbleweed
Feb
20
answered Merge 2 sheets, always keeping the value from sheet 1 if there are duplicates?
Feb
2
awarded  Editor
Feb
2
revised How to merge rows with same Name merging data of each ?related column
Niced table formatting
Feb
2
awarded  Critic
Feb
2
suggested approved edit on How to merge rows with same Name merging data of each ?related column
Feb
2
answered Check if first letter in cell is within provided range in Excel
Jan
31
comment Excel, sort through columns
In your example, how do you know "CA" is a member of "States"? Is this perhaps derived from the list of all state values in column B (regardless of association with column A)? If this assumption is correct, a pivot table might work.
Jan
31
awarded  Commentator
Jan
29
comment VBA Syntactic Sugar
You can also assign a range to an array variable and vice-versa.