Category "formula"

Is there any function in google sheets by which we can remove some numbers in google sheets?

Suppose there is a sheet in which there are 100 contact numbers and I want to bring the numbers in different google sheets after removing selected numbers. How

Choosing a drug for a patient ( according to contraindications)

Can anyone please help me in choosing the suitable drug the case: patient A is suffering from hypertension & Kidney disease Drugs: Classified according the

How to use an entry in a vba textbox as the "Link Location" within the hyperlink formula?

I'm still reasonably new to VBA and I'm trying my best to learn, but this one has stumped me. I have a Userform where one of the textboxes is for a user to ente

extract a date from a cell containing text string in excel

For the Twelve Months Ending Thursday, June 30, 2016 I have the above text in excel and I need an excel formula to extract ONLY the date June 30, 2016. The for

Excel copy cell from a column if value is starting with Formula

I have this kind of column in my Excel: A B gbgdf, dsfsd, gdgdf, TC-EVTgfdsfs, gdfgd, I am willing to copy every cell that is NOT starting with

Formula to find week numbers from the Total [closed]

Any one please help me to identify the formula or mathematical term on the below example. Predefined sets stored in the system, 1 = Monday 2

Google apps script - Auto Fill Column?

I've just learnt about arrayformula and continue for keeping formulas into new rows, now im trying to get a single string to copy into new rows "N". How can I a

Formula to see if you're on track of monthly budget

I'm not sure where to post this question but I thought here would be a good spot. What would be a Google Sheets formula to see if I am on track to stay within m

Using column numbers not names in lm()

Instead of something like lm(bp~height+age, data=mydata) I would like to specify the columns by number, not name. I tried lm(mydata[[1]]~mydata[[2]]+mydata[[3]

Excel formula to take string value from cell and sort its characters in alphabetical order

Can you please help me to make Excel formula that takes string value from cell and sorts its characters in alphabetical order? Ex. original cell value: 'BACR'

Excel formula to find the rightmost column containing a value in a table

I have some data structured like this in an Excel spreadsheet: A B C D E F 1 1 1 2 x 2 3 2 1 1 1 2 2 3 3 3 3 3 3 4 4 I am trying to formulate an E

How to render Latex markup using Python?

How to show an easy latex-formula in python? Maybe numpy is the right choice? I have python code like: a = '\frac{a}{b}' and want to print this in a graphical