treatment

Hello everyone, First of all, I would like to mention that I'm not an expert with Excel. ? So, I have a column with two different units (GB and TB): Space PV 104.10 GB 1.7 TB I will need this values to do some calculations, but I can't do nothing because I need to replace: "." for...

Hi, I'm not sure how to use Match with an IF statement, or if it's even possible to do. Here is what I am hoping to achieve; Car Type B14:B23 Tax Treatment E14:E23 Private % F14:F23 Input Data B28:B37 I would like the Input Data B28:B37 to be pre-populated depending on what the Tax...

I have been given a list of patient info relating to treatments offered. Its in the form of a new line for each treatment. Some patients have a single treatment, others have multiple treatments. All treatments are identified as either "Primary" for the first treatment, and "Secondary" for all...

I am hoping to be able to calculate a date range when an initial scan would be required for a patient treatment by working backwards from the date of a patient treatment and factoring in different variables. Variables would include varied timeframes based on differing complexity and staff leave...

Hey folks Have a column (R) to populate with data depending on the answers in several other columns. I've started it with .... =IF(S5<>"",VLOOKUP(S5,'Look Up Tables'!$T$2:$V$29,3,FALSE),"********") Then in the ******* I need these options from cols AA, O & P to enter the correct treatment AA...

I have data in longitudinal format for patients. Each row denotes a treatment with patient column for Patient ID and date of treatment. I need a formula to work out an ordered count for each patient for their first treatment, second treatment, third treatment etc.

Hello folks I am tracking the effect of using hormone disruption to control moths and I did 2 treatments, treatment 1 om May 12,2017 and treatment 2 November 17,2017.I want to mark off these 2 days on the chart so that the reader can see the effect of each treatment. Month Year-2017 Jan 6,2017...

I have a cell AP11 that has a IF function in it here it is "=IF(K11="","",VLOOKUP(K11,$I$2:$J$8,2,FALSE))", it returns either the value NONE, or one of many text stings such as E300R191M or E1595R19 that are in the range I2:J8 or remains blank. I need to have another cell AW11 return a 0 or...