198 reputation
8
bio website
location Michigan
age 46
visits member for 2 years, 6 months
seen Dec 6 at 4:55

Andy Holaday is the Actuarial Data Manager at AFHI, the largest non-governmental specialty writer of workers compensation insurance in the United States.

His specialties include applying acute understanding of business requirements to generate data requirements, analysis, acquiring and providing quality data for others, data presentation and visualization, and creating sustainable data architecture.

His passion is adding value with comprehensive analysis, creating data-driven solutions for end-users at all levels of experience, and crafting and improving repeatable workflows.

Favorite database technologies include Oracle and SQL Server.


Sep
24
awarded  Autobiographer
Apr
29
awarded  Caucus
Mar
16
comment Apple Store Content Downloading Errors
I'm thinking my network topology was part of the problem. My LAN was behind two routers. I changed this so there is only one hop to the internet and the issue went away.
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
16
asked Apple Store Content Downloading Errors
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