## Formula to Extract Text from Cell

I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) …

Microsoft Excel Formulas in Excel

I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) …

Hi I have a spreadsheet with factory name, review date and overall evluation. Some factories may have multiple entires and reviews. I would like the …

I am trying to figure out what formula I would use to track value changes to my Blank Permits. For example, I have an Export Permit # 05064578 with several …

Is it possible to have multiple criteria in a LOOKUP formula? By: hands in

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum …

I want to room students for specific exams. I would like to input a formula or something to allow 24 cells to be populated with the same room number. Is this …

Help with excel formula nested IF statement in simpe spreadsheet using Excel 2016 with Windows 10. Hi, I am trying to include a nested formula in a …

Hi, I am trying to include a nested formula in a spread sheet. the formula is =IF($G22=”S”,$E22-205,””,IF($G22=2,E22)) G22 is either S …

I cannot work out what I am doing wrong. I want to return the highest value if any of the two values in two cells is above 155, otherwise return the lowest …

Hi Guys, I would like to keep a value constant for the first cell link in this and then change it to the next 4 automatically from $2 to $3. Then after …

Hi all, I need some help trying to nut out a conditional formating formula. I need to only highlight cells that contain 3 or more blanks in sequence in a row …

1 F 2 H 2 F 3 H 4 F 5 H …

Sir, I need to create Preventive maintenance plan scheduled for equipment. We will do service for every 250 hours for the equipment. For A-check (250 hrs), …

Hi my question is, i have to do a shipping simulation, based on the stock i have. if i have more than 1000 pieces i would ship my product by sea and when …

I need a formula to compare the text (test will be one of the following: FREQ, PROB, OCC, REM, IMP, INC) in every third column of row 42 (i.e starting at C42, …

I have 2 times say 2:39PM and 5:24PM i can already change the total difference in time to total mins. but in the same formula i need to show that if the total …

Good day Worksheet “Summary” contains information of employees i.e: employee number, name, id, time worked, pay rate, pay etc. Worksheet …

cell d26 that formula should be as followed =(C20+C21-B26-B27-C34-E48)*(12%)+74.6…… The end of that formula is where im having my problem …

Hi all, I have a very complicated formula, that works!, but when I sort the data the formulas look up the wrong value and it stops working. How do I …

Dears , Kindly your support to do below : When we want to weekly upgrade / downgrade capacities we must change all sources and this takes much time to …

In one column, I have a beginning balance of $100(A1). 3 debits: $10, $20, $30 in A2, A3, A4. I want to add A2, A3, and A4 and then subtract that total from my …

HI, I have Office 3565 MSO exell 32 bit on wndows 10 pro i have sheet 1 with a listing on line 1 of my vehicle , a column for current miliage to entered …

What is the formula to calculate X=p% of Y? For example, 10=20% of what number. By: Carson

I am trying to roundup the result in CELL P8, I already have this formula in there – …

ie I need a formula that will identify cooomon words between 2 columns but with the Same Row. ie Say A1 to be Compare to B1 …

I have a list of names in two worksheets listed alphabetically but not identical. The sheets will use filters to sort afterwards. I need to use a vlookup I …

Excel 2010 I have a input cell to enter a period number – Eg 1, 2, 3 …. up to 18 I want to return sum total in output cell that totals for example …

Column a1 to a50 has a mixture of yes and no written in the cells. Column b1 to b50 has a mixture of red and blue written in the cells. What formula do I use …

In conditional formatting, I have =$A$5=”x” (Formats the target cells to Fill Green) Applies to =$B$5:$T$5 This causes cells B5 through T5 to …

=HYPERLINK(“https://cactus.nci.nih.gov/chemical/structure/”&C2&”/smiles”) does not work. the website …

If you have names displayed in various was in one cell is there a formula to correct multiple conditions. For example, one column as these variations: Oprah …

I’m looking for a formula to help me change the month of a date to a specific month of the year. Say the date is 5/6/19. I want to calculate a date the …

I have an excel file that has 243 rows with excel file names in one column. I want to pull data based on that excel document but don’t want to have …

Hi, I have a registration excel list that has names, addresses, and cells that i mark with an “x” if they have prepaid for a tshirt and another …

I have looked all over and not quite found the answer to my question. I have tried a lot of INDEX and MATCH posts which offer COUNTIF or an absolute, like 3 …

I need help with spreadsheet that I have colums with dates by formula and want to use conditional formatting to change color of cell if a manual data …

Good Day, I was wondering what formula I can use for the following scenario? Column A: I have various client numbers, but some are repeated. Column B has …

Need some help, I need to count the number of cells (in a column) that has a certain word in it based on the date in another cell (the date is formatted …

Hello! Here is my problem: Cell- A1 has a date of 3/15/1950 Cell-A2 has number of 65 Cell-A3 has a date of 1/1 (no year) Cell-A4 formula What would the formula …