# Project excel formula jobs

Hi
I have **excel** sheets. I wanted to merge coloumns in Address field. Experienced **formula** candidate contact me. This is a small fee **project**. If you are on the right path I have more projects like data mining etc. upcoming [login to view URL] me soon.
Budget: 5USD
Regards
Scott.

All commetns are imbbded in the **Excel** file Dashboard SHEET

I need someone who can implement some formulas in CPLEX for optimization using c++

i am building a spread sheet for my manufacturing business. i need to select a machine and tick its options to be built with on sheet 1. Sheet 2 will need to retrieve and sort data from other sheets and produce a build plan i have a sample layout but it requires the formulas and some experience to set up properly

I need an algorithm that will find the keyword difficulty on google. Factors: -Competing pages -Search Volume -Ranking Position for example i did some seo for my website, then my website shows up on the second page, taking into consideration all the factors above it will find keyword difficulty. -Logic of scientific discovery

I have a cell in **excel** containing numbers 1 to 90, formatted for example as below
5,68,88
1,75
3,16,68,77
12,34,80
etc
I need a **formula** that will count how many times a cell contains numbers specified, being 1 to 29 and also 1 to 79. These would be presented in 2 new cells as follows based on the above example:
5,68,88 1 2
1,75

Column D has hours delivered for each day of a month, If there is a 'Yes' in column E then the hours in Column F should be D*2 rather than if blank then the result will be the same as in Column D.

Writing a pdf file in latex with the formulas. Very small so dont overbid and i need it now

I require a specific output of information from details which are in my **Excel** worksheet.

I have some work, in an **Excel** spreadsheet. I am in charge of ordering cash refills for ATM machines. The total cost is comprised of several factors, Interest, volume, truck fees etc. The job is pretty simple. My objective is to find the optimum amount for each refill and how often should the refills be. It sounds simpler than it is though. All machines

Create straddle at any time (start time and end time). in amibroker

...document with 20 entries. I send it to my coworker and he sends me a second document with notes on specific entries. Each entry has a case number assigned to it. On the first **excel** sheet (the original sheet) I have 20 entries. On the second document I only have 8 entries with specific case numbers. I need to merge the notes with my original document. See

I need to find name of the column based on the value position in the table. Only **Excel**, no VBA.

Need to include an indication bar on top or bottom of a Stochastic indicator

need to kno **formula** in **excel** to do columns under coulmns
need to kno **formula** in **excel** to do columns under coulmns
need to kno **formula** in **excel** to do columns under coulmns

Hi i need transform mathematical formulas into php.

**EXCEL** **FORMULA** WANTO TO KNOW
COLUMNS UNDER COLUMNS REQUIRED RESULT IN ENCLOSED **EXCEL**
WILL GIVE 2 $

The syntax (or sentence structure; that is, the way the commands are organized in the **formula**) of an **Excel** IF statement is: =IF(logic_test, value_if true, value_if_false). IF statements are used in all programming languages and, although the syntax may vary slightly, the function provides the same results.

I want a **formula** find the consecutive days in a column that are more than zero ( those days should be 3 or more only , if only 2 then ignore it) then I want to multiply the number of these days in the highest no ( i.e ( 4days *3 ) + ( 3days*4) = 24))
1
3
2
2
0
1
4
1
0

...when in reality their rent is supposed to start in March. This lack of a proper **formula** is also a problem if a rent increase happens later in the year like in June...it will apply my increase starting in January and affects the balances Jan-May. I am hoping to find a **formula** that will pick from a date list and only populate the correct month. I have attached

We are trying to make a dynamic calculation on our "Bid Sheet". The Bid Sheet should be where the calculations final output will be. The "Products/Services" and "Rates" sheets are for reference for the calculations. We want the drop down menu “Item" and “Model" on the Bid Sheet to select the appropriate item on the “Products/Services"...

I am a children's hair salon owner and my partner is a children's hair stylist. We would like to create two all natural shampoo and conditioner formulas for children that smell like chocolate and raspberry. 1 shampoo chocolate, 1 shampoo raspberry, 1 conditioner chocolate, 1 conditioner raspberry. We would like our products to be free and clean: no sulfates, nano-particles, parabens, ...

I need a **formula** written into cells to identify patterns and then count specific data. The pattern data that first needs to be identified is spread across column B through I. The **formula** should first recognize the pattern within these cells. THEN according to the search criteria, the **formula** should match one of three values and produce a value of either

I need a **excel**/google sheets **formula**/script to compare the values of:
B2|C2|D2|E2|F2|G2
Which ever is the cheapest (ignore cell if there is no data in it to compare):
1 put the value in (I2) and olour code to the supplier
2, Show the diference in value to the next cheapest supplier in (J2)

I have some work, in an **Excel** spreadsheet.

I'm having trouble doing a **formula** for an index array with multiple criteria...

Document the formulas from an **excel** spreadsheet

Would like to automate my **excel** for shipping time.
Taking into account that we have shipping time and that there is no delivery in the weekend and on monday.
**Formula** has to do something like Friday = Tuesday and Wednesday = Saturday.

Need **project** timeline created in **excel**, not a very difficult task for someone with **excel** skills and can create a **formula**. Do not contact me if you do not know how to use **excel**, I need this turned around today. Extract info from word doc and then create a timeline in **excel**

Hello, I would like to have a **formula** or calculator that will give me the true cost of long distance billing that has a per minute cost but bills at a minimum 6 second and then in 6 second increments. This way I can compare those rates to rates that have a per minute cost but bills at 1 second minimum and 1 second increments.

Mapping **formula** of Cash Flow statement from Balance Sheet and P&L. I will send you BS and PL. and template of cash flow, will require you to put **formula** at the cash flow statement so that it will automatically calculated.

I need help to make a **formula** in **excel** to calculate total investment with compound interest during "x" years.
a) Years (Can be edited by user)
b) Inflation % (Can be edited by user)
c) Yearly investment (Can be edited by user)
d) Total Invesment + Inflation "b" during "a" years
Need to get a **formula** NOT using **excel** FV function.

...proprietary plant-based organic supplements. We have lists of the supplements our manufacturers offer to create our own proprietary blend. This is extremely helpful. However, if the **formula** we need to create falls outside of what they offer we will need to shop a new manufacturer.
We need your help to bring a new level of effectiveness, safety, and transparency

...have a **excel** document with several sheets and pages in each sheet.
In addition to all the sheets and pages, I have one sheet with instructions on how many copies are needed of each sheet and page when printed. Today I manually have to print each sheet and page by itself in the correct number of copies.
The **project** is to make a **formula**/script that

please check attached file
i want to match Column C-2 of sheet2 with Column-C of sheet3
if matched, then Column-M of sheet2 reflects in ...i want to match Column C-2 of sheet2 with Column-C of sheet3
if matched, then Column-M of sheet2 reflects in Column-M in sheet1, otherwise INSTOCK
i'll pay 5$ for this **formula**
i am looking to discuss
thanks

**Excel** **Formula** Needed For My Inventory.
I have 2 Sheets
1ST Sheet is my Inventory Sheet named "2018"
Serial Numbers are placed in Column "C" in Sheet 2018
2ND Sheet is my Sold sheet named "Sold05/02/2018"
Serial Numbers are placed in Column "c" in sheet "Sold05/02/2018"
In sheet "2018" Column M has the value...

find the **formula** for position based on the other 2 variables and give a quick explanation of how you did it for 5 extra GBP. budget for **project** is 15 gbp + 5 bonus

in column A I have the value OAR: OAR9134 (1 record) and I need the **formula** to give me the value OAR9134 .. ie I need the **formula** to give me the value between : and (

The **project** is to adjust an advanced **excel** **formula** used in a commission calculator.
The requirements of the **formula** are outlined in the below scenarios:
CURRENT **FORMULA**
June billed revenue 100,000
July voided revenue -100,000
A negative threshold carryforward applies at a fixed value 34,999 applies to July which will carryforward to payables

**Formula**/Template Print different address on the brochure

...1914 in your message. Any who do not do so will not get a response.
I am given price files in Microsoft **Excel** from Vendors daily. Many of them are not formatted in the way I need them.
Some **formula**(s) could help me out.
I need an **Excel** **Formula**(s) that I can use over and over again to:
1. Start with a value in a column marked 'UPC'
2. Find the same

create a macro or **formula** to convert text to number in column "G" and place the number value in column "L"
Example
"-975 " is in column "g" it is stored as a text,
place the number value in column "L", remove the spaces
This can either be performed as a **formula** or vba macro
This is a micro **project**, budget $5/ to be complete...

Hi Sai Sree A., I am a PhD student working with a large animals breeding data set in **Excel**. I'm running into problems completing the organization of the data set, running formulas for QC, etc., as it's getting larger. I'll have various problems/issues to solve as I go along, and would like somebody to become familiar with what I'm doing over time and

I have a color **formula** that I'm having trouble with. Most color variations yield the correct color but the at least one variation is incorrect. ie. yellow and green is resulting in red rather than yellow.

I WOULD LIKE TO CREATE A COMPLEX **FORMULA** IN **EXCEL** THAT SPLITS THE TEXT IN A SINGLE CELL AND CONVERTS IT INTO MULTIPLE COLUMNS.
THE CONTENT OF THE CELL IS TEXT, THEN A NUMBER,
IN CERTAIN SITUATIONS, THE CONTENT OF THE CELL IS TEXT/NUMBER/,/TEX/NUMBER WHICH MEANS THAT WE NEED TO SPLIT THE CONTENT INTO 4 COLUMNS

Help fix **formula** in my model. Need fast turnaround time (few hours)

I need a **formula** that will return the list of completed courses for an individual when there name is chosen from a drop down menu