Formula to Extract Text from Cell

andrew walker — Tue, 03 Sep 2019 18:02:11 +0000

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) will be pasted into a single cell, then will want to have the following columns set with the formulas to pull the Lead ID, Name, Email, and Phone without showing it’s Title (Lead ID:) and only showing characters for the entry.

So if this entire Text was pasted into A2, and I want A3 to show the “Lead ID” value of “M-5554444”, what would be the formula to do this? I should be able to take it from there to create the formulas for Name, Email, etc.

Lead ID: M-5554444

Name: Sample Name

Email: sample@email.com

Phone: 8885554444

By: Jon

Excel work Lottery prediction

andrew walker — Tue, 03 Sep 2019 08:59:25 +0000

To whom this may concern,

I have a question in regards to my project which involves working out a secret formula in the determining the odds section to provide the winning lottery numbers every week using number frequencies, probability and statistics.

This is a Microsoft excel project. I’d like to know on how I can send in my work for help? I’d like to know if there is a fee involved?

What I’m looking for is a secret formula in the odds section. I’ve worked out the odds but the next formula is to find the secret formula that works 100% to find the 8 winning lottery numbers. 6/45 2 being supplementary numbers. 7/45 7 winning numbers and 2 supplementary numbers. Powerball 7/35 7 winning numbers. Powerball is 1-20.

I’m happy to send my personal project work to see if you are able to assist.

Thank you for your attention in this matter.

Kind Regards,

Eneece

By: Eneece

Formula Help

andrew walker — Sun, 01 Sep 2019 13:02:29 +0000

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

I would like the overall evluation to return based on the latest review for each factory. Therefore if i have a duplicate factory on two review dates and the latest being accepted and the other follow-up, the value to return is accepted as it is the latest review outcome.

Hope this makes sense.

Thanks in advance

Tami

By: Tami

looking age of last non-matching value

andrew walker — Sat, 31 Aug 2019 22:52:02 +0000

I have data that looks like this (three columns: Date, IGN and AP):

Date	IGN	AP
8/8/2019	Emxmari0	3560
8/11/2019	Emxmari0	3580
8/12/2019	Emxmari0	3580
8/16/2019	Emxmari0	3590
8/17/2019	Emxmari0	3590
8/21/2019	Emxmari0	3590
8/22/2019	Emxmari0	3590
8/23/2019	Emxmari0	3590
8/24/2019	Emxmari0	3590
8/28/2019	Emxmari0	3590
8/31/2019	Emxmari0	3590

I would like to create a new column AGE that when looking up the last value for the IGN column (just showing Emxmari0 in this case) I would like to look up the AP (3590) for last row of the given IGN (the 8/31/2019 date) and then look backwards in time to find the row for the given IGN with a different value in the AP column (the 8/12/2019 date vas a value of 3580), then with the two rows identified give the difference in days using the A column, 19 in this case. If a row for a given IGN isn’t the last row (which presumes the highest date) then the value for AGE would be blank.

Any help toward figuring this out would be appreciated!

By: Joel Breazeale

solution

andrew walker — Sat, 31 Aug 2019 21:30:24 +0000

Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula?

By: peter

Divide numbers

andrew walker — Sat, 31 Aug 2019 12:54:14 +0000

Hi, Hope you’re fine and healthy. I have a time sheet for my employees and the working days of each employees calculates based on projects that employee receive salary. for example: Ahmad salary is 10000 and it charge from five projects. From Project 1: 2000 Pjt 2: 1000 project3 :500 …. I want to excel calculates his working days based on percentage of each project. with thanks

Please response to me ASAP

By: Sebghatullah

Automatic match

andrew walker — Fri, 30 Aug 2019 13:04:16 +0000

Hi,

Would very much appreciate your assistance tackling the following conundrum:
I have two separate sheets.
In sheet 1: I have a column A for numbers and column B for names.
In sheet 2: I have a column C for numbers (some of them are also listed in column A , sheet1) and I would like excel to insert (retrieve) automatically the matching name from sheet 1 in to column D.

Meaning sheet 1:
A;B
256; Max
354; Tom
763; Jim
85; Sara

Sheet 2:
C;D
256; auto insert Max
763; auto insert Jim

What would be the function for that? I hope my question is clear, I tried Vlookup but it didn’t work.

Thanks!

By: Noa Isralowitz

Help with formula, please!

andrew walker — Thu, 29 Aug 2019 20:43:38 +0000

Hi!

I’m hoping someone can help me with this formula. I am looking for a formula to use that take the words that are in separate cells in a column, and populates them into one “master” or “summary cell”

All of this into one cell so it looks like this

By: Samantha Erickson

Change into decimal

andrew walker — Thu, 29 Aug 2019 08:30:30 +0000

I unable to convert the amount i in Ms Excel to lakh in decimal.

e.g. 234567 convert to 2.34

By: Tashi

Tracking value changes to a number

andrew walker — Thu, 29 Aug 2019 03:03:14 +0000

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 items in it with a value of $100,000. Each month I use that permit number to export several items, each item utilities that permit number which brings that total down in value. Each month I also file for new pemit numbers with new values.

What I am trying to do is track each permit number and the value remaing on that permit. This way I dont go over the amount available on that permit.

My problem is trying to find a formula that tracks each permit number and supplies me with a countdown value.

Not sure I have described it clearly enough though….Any help on a formula would be greatly appreciated.

By: Carolyn