medical

Hi Experts! I need to get the maximum DAY dates of the following clients Client Max day dates A 15 B C Here is the source data: CLIENT CATEGORY DATE RECEIVED A MEDICAL 7-NOV-19 A DENTAL 15-NOV-19 A VISION...

I'm looking for a formula that will provide one single value based on several drop down lists selection. For example : Department (drop down list) : Medical | Marketing | Customer Service Country ( drop down list) : Japan | US | Brazil Expenses (drop down list) : Consulting Fees | Adboard |...

Hi, I need help to solve this issue, Like i have to many customer codes and they all have zeros before numbers like, <colgroup><col><col></colgroup><tbody> Current Shape Required 000003 3 PAK LAND CHEMIST 000005 5 KHALID MEDICAL STORE 000006 6 CHISHTI MEDICAL STORE 000025...

Hello, I have a spreadsheet with 5,000 plus rows and many of the rows containduplicate data. What I am trying to do is if Column A has a duplicate thencompare the data in those rows and if the entire row is a duplicate to somehowidentify them from conditional formating or a formula like...

Hello, I am looking for some assistance in using a Scripting Dictionary to read a column of data and store unique values for output into a list. The problem i am coming across is the Scripting Dictionary is parsing lines in separately when it sees a comma. For example: AL - Medical Group...

Hi all, i would like to turn duplicate rows into unique using VBA. Therefore the data start from "A2" and the code should run through col. "A" and where the rows are duplicates, should place a number (serial number) on left of description. below i present the original data and the expected...

Hi all, I've been trying to piece this together but my experience is limited -- thought I could accomplish this with a simple formula initially, but now not sure. Appreciate any help. I have a workbook that lists jobs for a company that has 3 divisons. I need to start maintaining separate...

Hi I have column K which if the word 'research' is in there, then I want column G to then be looked at and if the word 'medical' is in there, then I want the sum of those research/medical figures in column M to be added. The red bit below works on it's own just for adding up all the medical...

Hi, I am trying to convert pounds to kilograms in a column. I know how to do that for a single number =CONVERT(1,"lbm","kg"). My question is there a way to do a range of number? From 90-300 pounds. The sheet I am creating is for medical purposes and individuals weight varies. Thank you FMash

I have the following measure which is returning 100% for every row. Voucher Spend as Pct of GL:= [Voucher Amt] / CALCULATE ( [Voucher Amt], ALLSELECTED ( Vouchers[Account] ) ) Voucher Amt:=SUM(Vouchers[Voucher Amount]) What I would like is for when I select certain accounts that the measure...

Hey guys, im trying to get the vba code to insert every other cell basically starting with cell r3 it would insert this function =IF(Q2="pride Mobility products Corporation",O2*-0.02,IF(Q2="Quantum rehab",O2*-0.02,IF(Q2="Drive Medical",O2*-0.01,0))) then it would insert it into r5 r7 r9 r11...

I intend to categorize Employees in 4 Groups with in a Department:- <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Data showed in MS Access <tbody> Group A B C D Medical Centre1...