# Project excel formulaJobs

1. **Formula** for Markup
2. **Formula** for Volume Pricing
A. I have 3 files, same format on each file. Each file has Inventory Sheet & Markup sheet.
I (amatear) have used (If) **formula**, I know you can do better.
B. I have try to have volume discount **formula** and failed.
I use hidden columns.
I use Teamviewer.

...pricing program in **Excel** and need assistance finishing it.
For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet.
The winning person will:
*Have advanced knowledge of **Excel**.
*Be able to start immediately
*Be available for hourly work over the next 10 days to assist me complete the **project**.
*Normally works

Need **formula** to calculate day and time for my **excel** sheet

I have some work, in an **Excel** spreadsheet.
It’s very simple.... basically just want a match **formula**

...square meter (m2) price. I need a **formula** for pricing. Example: A sign is A:190mm x 190mm for $30 (works out to $831/m2). A sign B:290mm x 290mm sells for $58 (works out to $689/m2). If I only work on the Square meter price of Sign A, Sign B would be $69.88 and would be too expensive. So I am looking for a **formula** that should a sign increase in size

I need a **formula** or macro to extract URL’s and text between <a href> and </a> tags.
There could be up to 20 occurrences per cell.
All links merged into one column, and all the text between the anchor text in 1 column.
I do have a **formula** in sheet 1, cell D, but its not correct. I need it to be extended to cater for 20 occurrences per cell, as well

I have three Formulas A, B, C, t...this post is public to freelancer.com.
What I Need is mathematical **formula** or algorithm that states, Based on the % that totals 100%, a paragraph, will be made up of those % percentages. Say Common Nouns is 10%, there would be 10% nouns in the paragraph.
This is for an English **project** I have for school. Please help.

Need someone who can help with matching two different sheets in **excel** i.e. GDP growth rates for specific countries in specific years (in one sheet) and matching this with a new column ''GDP Growth'' in a sheet with premiums for M&A-transactions.

if Column 1 AND column 3 are the same, then these rows should be together in column 2, divided by a comma

**formula** for calculate payout of double chance

The template needed is to facilitate garment costing for production cost.
...template needed is to facilitate garment costing for production cost.
The **excel** template should have the requirements
Component table
Product table
**Formula** to tabulate component table to result in product actual cost
Please contact for more information on the **project**

Need a google sheets array that identifies running 7 days
Example of my weekly **formula** that returns if its in a week or not.
now i really want running 7 days
=ARRAYFORMULA(if(weeknum(today())=weeknum (A2:A19526),"Week",""))

I need someone to design cars chassis,body panels,upright and hub,intake,and fuel tank. knowledge of vehicle dynamics and suspension working is required .

Need a **formula** made and perfected.

Hi,
I need an **excel** **formula**, I want to break the link and remove after breaking.
Please check attached.
Thanks

Hello. I have an issue with open office, please see the attached spreadsheet. As you can see, the boxes that are highlighted I would like those 2 numbers separated and put into the next cell over. Example, Under the FG tab in K10 there are 2 numbers which appear as 29-70. I would like the 29 to stay in K10 and the 70 to move to L10. For all of the highlighted boxes to move over into the next cell ...

I am a retail trader having 2-year exp in trading. I want an AFL on conditions. BUY SIGNAL = I heikanshi candle turns green and closed, I want system to fire buy order to my broker terminal. SELL SIGNAL = If heikanshi candle turns red and closed in red, I want system to fire sell order to my broker terminal. I will be using (1 & 5 ) min candle chart for trading.

...have the dimensions laid out in this **Excel** spreadsheet in columns and rows - 2", 2.25", 2.5", etc... And I have some of the prices filled in. I didn't anticipate this getting so complicated, and I need someone to build me a pricelist using this data. If you think you can see a **formula**, and want to build an **Excel** file that calculates the prices on thei...

On the link below you will find a Google Sheet:
[log ind for at se URL]
A need a **formula** on columns F2, F3, F4, F5 that shows the word coincidence between the columns on the left. For example, the sentences "Hello, this is an example." and "Hello, this is an example." have

**Excel** quick task, just need to find duplicate records and display data based upon that
and filters for based upon dates etc.

i want a sustainable chemical **formula** and manufacturing method to remove argulus(fish lice) in rohu (labeo rohita) & katla (catla catla) fish. it shouldn't have adverse effect on fish.

Hi,
I need an **Excel** **formula** or VBA function that will extract all occurrences of a string, it’s an src=“[log ind for at se URL]*/*” string, where the * can be different text.
There can also be multiple src strings in one cell.
I need all the src strings to be copied into a new column.
File will be shared in messenger.

Have an existing qlikview dashboard and would need to calculate YTD (Year to Date) amount. Just need one **formula**. Require anydesk to show you the dashboard. Thanks.

hi I have this sheet attached and I need a **formula** for column E to give that result
ie if the value in column A is
OAR: EMP02717 (1 record)
then the result in column E is
EMP02717

...products (problem here is that there are more than 200k lines (200000)
But could split them into several sheets
Example is within the sheets link aswell, I basicly just need a **formula** that is able to calculate every below cells until the next empty cell.
https://docs.google.com/spreadsheets/d/1TS-OkJ8aokBqXyut0_XWCDp5RQ38-WnqBlU_z8fPNlU/edit#gid=0

...generate the following **formula** please:
- Column E on our **excel** sheet has times populated in them
- the times are usually minutes (for example 21 minutes OR 30 minutes OR 33 minutes OR 1 hour 10 minutes) etc
- we would like a **formula** creating which we will place into an adjacent new column (let's call this column X)
- the **formula** should automatically result

...in sheet 2 a **formula** which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all **formula** based, maybe

...a certain period X (variable, in # of days). So if X is 30, the **formula** would look at the average frequency of 'actions' (ie: in days) over the past 30 days. If X is 60, over the past 60 days, etc.
See sample under Additional **Project** Files. I'm looking to fill C10:C2033 with a **formula** that would check, over the last 30 days from a certain date (CELL

Hello i wold like to buy the **formula** that are used in this website:
[log ind for at se URL]
The **formula**, must be in **Excel**

I need a new website. I need you to design and build it based on my specification.

I need two spreadsheets to be merged together. Then using formulas I need to update one spreadsheet using the others information, without it updating blanks.

I NEED AN **EXCEL** **FORMULA** CREATED FOR A HYDRAULIC LOSS PIPE CALCULATOR, I WILL PROVIDE A VIDEO OF ME DOING IT THE LONGHAND WAY (BY HAND) I WILL THEN NEED YOU TO CREATE AN **EXCEL** PROGRAM FOR THE CALCULATIONS TO BE AUTOMATED - THE CALCULATIONS WILL BE BASED OF INPUT DATA EXTRACTED FROM A COMPUTER PROGRAM, THIS DATA WILL INCLUDE PIPE SIZES, LENGTHS ETC.

Only people with knowledge of DAX syntax and Powerpivot apply please. i need a pivot table that has in one of the columns the total amount of th dataset. Please see attachment.

My name is Pilar, I am working on building an **excel** for tax calculation purposes and I am running into some trouble with a **formula** that I cannot build-in on my own.
The **excel** is basically an annual gain/loss stock portfolio statement that takes the dollar amount of the purchase and sale proceeds and converting it into the official Mexican peso rate

This should be a quick **formula** to pass my way.
Just need an "IF" **formula**.
As you can see, in Column "A" I will be selecting the status of the MSR, and need it to auto fill the applicable total to the appropriate cell on the right (Received, In Progress, Complete, Shipped)
No need to bid on this, as I have a freelancer already lined up

Help me with Sensitivity analysis, Monte Carlo simulation, optimise the LCOE **formula**.
I have done some part of the work and I need you to improve the overall paper and also help with Sensitivity analysis, Monte Carlo simulation, optimize the LCOE **formula**.
More details will be shared.
Thanks

I NEED AN **EXCEL** **FORMULA** CREATED FOR A HYDRAULIC LOSS PIPE CALCULATOR, I WILL PROVIDE A VIDEO OF ME DOING IT THE LONGHAND WAY (BY HAND) I WILL THEN NEED YOU TO CREATE AN **EXCEL** PROGRAM FOR THE CALCULATIONS TO BE AUTOMATED - THE CALCULATIONS WILL BE BASED OF INPUT DATA EXTRACTED FROM A COMPUTER PROGRAM, THIS DATA WILL INCLUDE PIPE SIZES, LENGTHS ETC.

Hi there, I have two documents. One shows: * Post code * Names of customers The other shows: * Post code * Longitude * Latitude I need the first document to ALSO show long & lat for all listed postcodes. that's it. So, long/lat' from sheet 2 need to be put onto sheet 1 I need it immediatetly. Very easy job.

I need my **excel** spreadsheet finished with **formula** ,it cant be done with VBA or Macro because only **formula** is alowed .

I made a robot it has 2 motors and 2 encoders attached
the encoder....motors and 2 encoders attached
the [log ind for at se URL] reads the value from the wheel and display on ROS and I can see the movement on RVIS but the movement is not correct so the **formula** might need to be fix
[log ind for at se URL] works fine but I will like to combine that code with [log ind for at se URL]

I have ongoing work related to our previous **project** 'I need an **Excel** expert to help me find a solution to this problem via a **formula** or macro'

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

...every kind of nail polish. Thermal color changing, neon, magnetic etc.... I need someone to create a new nail polish **formula** for me. all ideas are welcome. when u bid please submit a possible idea so i know u understand this **project**. you don't have to tell me the entire concept i just need to know u understand what i'm looking for. what ever concept

Hi, I have a complicated **excel** **project** underway which someone else designed - now one of the formulas doesn't work so I need help on how to extablish the error and then fix it.
I need someone who can skype or do some kind of video call and screen share as I'd perfer to talk it through with someone..
I do not want to upload files as they are personal

I have a difficult **excel** set up which someone else built for me - One of my formulas is not working and I need help to work out how to fix it.

I need a **formula** or macro that will find in file [log ind for at se URL] values (article code searched) as in uploaded files values like in [log ind for at se URL]

Create a probability **formula** relating to blockchain Proof-of-Work systems: Given: 1. a hash of N bits, 2. a 'difficulty' of L leading zero bits, 3. a matching hash (generic solution S) is found on average in M minutes. (by varying a part of the input data, nonce) Someone selects one predetermined hash fitting the above requirements and searches only

Hi,
I have an **excel** spreadsheet that I need to calculate the vector angle of the three plot points I have.
Please modify my **excel** spreadsheet to memorize this conversion and input results in F column for each row.
Also, please give me the math algo equation written on a notepad to calculate the vector angle. This way I can use it in other projects

hello, i need an **excel** **formula** which would count the number of occurences in a column , attached is the sample file, the result should give me the list of codes that are present in column A , and count how many times it appears in the whole column.
this is a very simple task, expected budget is 5$

Knowledge about Waveguides is a must.
I will provide you with the code and the **formula**.
The code is an implementation of a 2d rectangular waveguide.