# Excel formula find instanceJobs

We need to implement certain trading strategies for our portfolio management and automate it using Amibroker **Formula** Language(AFL)

....
I would like to accomplish the "End Result" with the use of a **formula** only - and NO helper columns. - Array formulas are also fine.
** I don't want to use macros **
** I don't want to use pivot tables **
** I don't want to use filters **
I just want a **formula** or array **formula** to transform the dataset, into the End Result as shown in the exam...

Need to convert this **excel** **formula**: =-((G2+(G2*F2))*(((1+F2)^(C2))-1)/F2)
to a javascript, according to this:
[log ind for at se URL]

I have an **excel** doccument, which I need to create a **formula** to search information by inserting the name of a student.

...
This shows an example of my 'dataset', and the layout of how I would like it to be transformed...
Ideally, I would like to accomplish the End Result with the use of a **formula** only - and NO helper columns.
I have colour coded the data to make it easier to read.
Please take a look and let me know if you are capable of helping me.
Thank you very

We need help configuring a loopback server **instance** with a mongodb connector. Please help with this and building a few REST api endpoints with business logic.

1. Help **find** 60 mom&baby, shopping, or baby product related to Facebook or Instagram accounts
2. Reach out to the accounts and ask them to help post product related posts
3. Increase the brand exposure and awareness over FB/IG

I have a row of cells. each cell has an index match **formula**. I need a **formula** that will return the first value in the cell that is not ""
Attached is the sheet.
I want cell F11 to display the result from range G11:Z11

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.

...even consider your offer.
I have written a complicated 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

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

We have Magento installed on Amazon eC2 and S3. The site and domain are active but we need to install an SSL. The domain is hosted on Godaddy. We are fine with either setting up an SSL that amazon provides or we can buy one on Godaddy and you can install it. We need someone who knows how to do this. Should only take an hour based on my chat with Amazon. Thanks.

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

...need to work with Google Cloud and install a new Ubuntu **instance** in order to train my model in machine learning with GPUs. I currently have a server dedicated to this use, but there is now too much data to ensure an acceptable training speed. So I need an expert to help me install this **instance** and test first to make sure everything works on this new

...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

...VERBS
% DETERMINERS
% ADVERBS
% PRONOUNS
% ADJECTIVES
The % is defined, but not in above example, since 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

I have a site hosted on AWS, but lost the .pem private key - need someone to create a new **instance**, so I can get a new .pem private key generated.

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

AWS EC2 **instance** connection problem.
No supported authentication methods available (server sent: publickey)

You must be willing to do all the work in our Wordpress **Instance**.
You must be willing to collaborate with multiple people (Design/Copy/Project)
You must be willing to overlap sometime with CEST Europe timezone
I expect a high amount of iterating over the next 3 weeks and hope to complete by the 17th of October.
Copy (words) will be delivered

I am having some OS / PHP / Permission issues with a virtualmin **instance** running EspoCRM a php / backbone CRM server.
Getting some invalid server response. Perhaps things like missing php-ldap or permissions.

**formula** for calculate payout of double chance

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.

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.

I have a rocket chat **instance** with 10,000 active users. I need assistance setting up multiple instances and linking them together, which is described in this documentation: [log ind for at se URL]
Please make sure you understand Ubuntu, node.js, nginx and setting up reverse

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

1. Adjust script to **find** duplicates with more than 30k lines without crashing (maximum run time exceeded)
https://docs.google.com/spreadsheets/d/1TS-OkJ8aokBqXyut0_XWCDp5RQ38-WnqBlU_z8fPNlU/edit#gid=0
2. **Find** a way to identify out of stock products (problem here is that there are more than 200k lines (200000)
But could split them into several sheets

...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.

[log ind for at se URL]
the above php website need to be setup as initial configuration on our EC2 **instance** and show it to us asap.
Code is available in the above page itself for download.

We currently have a website and application running in Azure, basic application and sql service. We would like to migrate this to AWS.

I have a Wordpress blog running on AWS EC2 **instance** which needs correction over a few final issues. The work would mainly involve:
1. Configuring SSL (https, using lets-encrypt) for the site.
2. Fixing theme issues related to title and post tags.
3. Modifying the multiple page display in post, menu items and adding social links.
4. Redirection of About

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.