Hi Experts!
I need to fill in the count of the following clients:
Category ClientA ClientB ClientC
Medical
Dental
Vision
Here is the source data:
Client Category
ClientA Medical
ClientA Dental
ClientB Vision
ClientC Dental
What should I do?
I need to match a value in an array to a value in the first row. See Below:
<tbody>
Medical
Dental
Voluntary
Voluntary (2)
Voluntary (3)
Voluntary (4)
Medical
Dental
Pediatric Dental
Basic Life
AFLAC
STD
LTD
</tbody>
<colgroup><col><col><col><col...
Hello,
I need help writing a nested if statement:
I need to pull a value into cell A53 on sheet "SL Estimate" from sheet "Year 1 Rates" based on drop down selections in 5 different cells on sheet "SL Estimate".
Drop down cells used:
Cell E8, named "Cov_Level", has either Single-1 or...
<tbody>
Name
Reporting period
Condition
Location
Feed
ID1
June 18
headaches, dental, eye
UK
Nil
ID1
June 17
blood,urinary, dental
UK
Nil
ID2
June 18
brain, blood, urinary, dental
US
Tube
ID2
May 17
brain, urinary,dental,eye,
US
Tube
ID3
April 18
eye, dental
Can
Drip
ID3
April 17
eye...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.