# Formula excel jobs

Melakukan sejumlah pekerjaan **Excel** 1. Fungsi **formula**= operasi penjumlahan,pengurangan, perkalian, pembagian, aritmatika lanjut.
2. Alamat relatif, alamat absolut, alamat semiabsolut.
3. Fungsi statistik.

Melakukan sejumlah pekerjaan **Excel** Mampu mengoperasikan Ms **Excel**
Mampu mengoperasikan Ms Word
Mampu mengoperasikan Adobe Photoshop
++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw
++mengoperasikan Ms **Excel** dan menguasai VBA project dan **formula** pada **excel**.

We are looking for consultants to help us with some urgent short term projects. Using your well established, expert cosmetic formulation skills, you will assist us in reformulating existing products to meet key product performance criteria. This may including sourcing raw materials in line with our strict ethical requirements.

One of the major calculations is error-ing out

I need (IN **EXCEL**) to know when two times overlap.
Please see image for visual example. Below is written example.
1) You will notice that Sales Person 3 and Sales Person 4 both worked a shift.
2) There was overlap from 08:03 thru 08:21
3) There was no overlap from 8:00 to 08:03
4) There was no overlap from 8:21 to 08:22
I need to know (REQUIRED)
1)

i have csv files, in one file is categories for opencart, in another file is products. Problem is, in categories file , all categories have numeric ID. but in product file categories have also numeric ID, but subcategories is just as text. i need it to import in opencart (i have module) , but i need it convert categories and subcategories in opencart>style>to>import

I have **excel** file for some calculation, I need a single **formula** for calculate no of days. Like Opening day-closing day = no of days.
This is simple task, I wanted to know about your experience **formula** so that I can use you in future.
File is attached.

...I want to automatically convert in another format in **excel** and calculate the total time.
The source will always be in the "Employee attendance" format and should be converted to the Proper Format workbook.
We should be able to copy new time data in the Employee Attendance format and the **excel** workbook Proper Format should be automatically generated

I need an **excel** expert to create an **excel** file that allows the follow:
- I have 3 lists of words (40 words on each)
- I need **excel** to randomly select 30 words (10 of each block) without repeating them. All in the same space (so I can easily copy and paste).

...distinct Name's automatically from the records tab
The "Example Results I Want" tab shows what should be the end results you program into the Results tab
This must work in **Excel** 2007 and Deadline is Thursday the 19th
The Date column is used to get the records only for a date period I want
The Name column list here is automatically generated from finding

Summarize data from **excel** file into a summary report (template provided). Can either be done by script, **formula** or manual entry. Summary reports can be either on a single sheet or an individual sheets for each header.
Summary report(s) to be filterable on dates.

The on tab in my **excel** file does not match the exepected result and I cant see why. I just need someone to check my file.

We require 3 different sets of Macro for 3 different **excel** files. Please contact us to further disucss

I need the **formula** written for Microsoft **excel** that will do the following:
I do not know the correct way to express my formaula professionally but i have tried to write it our below. I am willing to discuss with you any questions before you start.
At this point there are 2 **excel** spreadsheets involved. (sheet1 and shee2) i have put this after each

I need help for someone to develop a template in **excel** with formulas and formatting so that I can input the data and everything will work.
Need asap by Friday happy to pay

Requirment:
Understand **excel** well and conditional formatting
Requirements:
Help me create a **formula** that changes row colour based on value in a cell
Help me create a **formula** that sums up values based on cell colour
Help me do this via a screenshare / zoom if possible

Hello, We would like someone to write a patent for our company using standard patent template. We will provide all the details, claim, art work, etc... Previous experience required.

1. Add Header and FooterMS **Excel** allows us to keep header and footer in our spreadsheet document.2. Find and Replace CommandMS **Excel** allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.3. Password ProtectionIt allows user to protect their workbooks by using password from unauthorized

I have some work, in an **Excel** spreadsheet. entry data using **excel** spreadsheet
use **formula** for computing

...platform:
1- Ecommerce platform must accept payments and execute each transaction as seamless as possible keeping safety in mind.
2- Inventory UPDATE should be manageable via **EXCEL** seamlessly (With very little effort). ** THIS PART IS VERY IMPORTANT **
3 - Should have the ability to list each product with price. Should have the ability to CONTACT SELLER

Would like to setup a **formula** for the following **excel** file.
If columns E+F is between 0-9.99, column I should be [(E+F)*4 ]+ (H*175).... (Assuming H is 1. If H is greater than 1, the second half should be (1*175) + ((H-1)*150).
Also want to include the following in the same **formula**...
If columns E+F is as below, it should be multiplied as stated below

I have an **excel** file with several spreadsheets, I just need a **formula**.

I have an **excel** file with several spreadsheets, I just need a **formula**.

Hi Team,
I need somebody to write a complex **formula** that will look up barcodes and return the results accordingly.
I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas.
Watch the video of what I want: [login to view URL]

I have a spreadsheet that has needs to be sorted into multiple sheets. I don't think it's extremely complicated, but more than I can do. There are only 3 columns. I need to pull info from the first column - but not based on the entire col A info - not day, date - just the name of the city.

I need an **excel** workbook for pricing steel buildings. We have set dimensions with attached prices and add-on items. Want to be able to check a box for the height, width, height, roof style certified/noncertified, etc and have the **formula** calculate the price based on the selected options.

I have some work, in an **Excel** spreadsheet. I usually do some data in ms. **Excel**, because it is easy to arrange and helpful for the **formula**.

I have a **excel** file and a test Power BI. I need help to create a DAX **formula** to calculate attrition. The test file has a hire date and a term date. Need to get the start headcount by removing anyone hired during the selected month or quarter or in the future. Remove any terminated employees that were terminated during the month or quarter selected or

I need a **formula**/query in Access that will give me the same result as the attached **excel** file for column B. This would be in an update query where B would be the calculated field. In **excel**, the **formula** would be Countif(B$2:B2,B2) and would drag down so that the result would show the number of times that field has been seen above. I have millions of

I need you to develop **formula** or coding for me in **excel** using VBA Macro

I have some work, in an **Excel** spreadsheet. Maintenance work
Spare entry
Using **formula**

...complex **formula**. I have a good understanding of **Excel**, but when it comes to very complex formulas I need some help. Basically I am looking for someone that can hop on a screen share video conference occasionally and I can go down several questions I need solutions for. Happy to discuss different pricing structures (by hour or half hour, by **formula**, etc)

I have a spreadsheet, 1st column is dates & time, 2nd and 3rd column are numbers. I want to a) average the data in columns 2 & 3 when the date in column 1 matches a date in a column I've made somewhere else; I also want to find the min and max for the column 2 & 3 data. The data have been gathered every few minutes. I want to graph as avg, min or max per every 24 hour period. ...

I have a spreadsheet that i am trying to use a **formula** to assign a number to duplicate rows. I need someone to show me the correct **formula**. Easy money for someone.

Looking for a Freelancer to use provided **Excel** template and columns H:M to identify winning (Yellow highlighted) and losing (Red Highlight) patterns for every horse (broken down by rows) in the spreadsheet. There should only be 2 patterns/algorithms per horse.
Please make sure that your solution is **formula** based so new data sources can use. Preferably

Looking for a Freelancer to use provided **Excel** template and automate data manipulation for rest of spreadsheet using the following instructions
1. Complete 4 columns C:F using information contained within every second row in column B.
2. Using Yellow conditional formatting for where column A has an entry starting with "1 of"
3. Use Red conditional

Have **excel** sheet. I need to remove the name based on slowest time.
i.e in this case, it will be 0.79 for ausbred
and 0.85 for sapeince.
But there could be 100's of duplicates that are grouped in the distance field.
800M
Ausbred Petal 0.75
Ausbred Petal 0.79
900M
Sapience 0.84
Sapience 0.85
I need the **formula** now. I don't have time to

my **excel** data compile with another **excel** sheet

Hi, I need an **excel** sheet creating that I am sure will take minutes for someone with **excel** skills, I have non and not enough hours in the day to learn.
I can download data in CSV format I then need to import it to **excel** and create a simple **formula**
if actual number is greater than previous and greater than consensus give it a score +3
if actual

...quick and simple project for an analyst or expert in **Excel** to add **formula** to **Excel** template to populate it to show the revenue received from orders placed by customers.
See the video blow that describes the background and the requirements.
[login to view URL]
An Expert in **Excel** should take no more than 15 - 20 minutes to populate

I have some work, in an **Excel** spreadsheet. Help with formulas, what i would call embedded lookups. Pulling value based on multiple ranges in another sheet.

Need **formula** for google sheets I have a link attach to this.
- need to get the sum from T2:T49 for cell O54 but sum need to be filtered by services from column S2:S49.
- need to get the sum from T2:T49 for cell O55 but sum need to be filtered by Insurance from column S2:S49.
-need to get the sum from T2:T49 for cell O56 but sum need to be filtered

Important: IF YOU KNOW YOU CANT DO IT, PLEASE, DONT BID!!!
Check the video with the task.
Need to use the code function of wpDataTables (the function that imports **excel** and csv files) so it works for users from Frond-End too, in 2 steps(select the file and import it, showing it right away in the Front-End).
Also need to use the function of WooImporter

...using various **formula** and reporting the data on a web page for each individual logger in a graphical format including dials and graphs (similar to the pictures). There must be an administration section for maintenance which can access all loggers for configuration and viewing. The platform must email the customer every month with an **excel** compatible file

...the macro, MS Access will export summary report in **excel** format and exit
open 1st **excel** and copy data form particular sheet and range
open 2nd and past data in required raw or column or end of the previous data
refresh pivot table and **formula**
select a fixed range data and copy form 2nd **excel**
open outlook new mail and past on the mail body

A one cell **formula** for
A1 A2
24532 = 16
62453 =20
72392 = 23
Simple math
2+4+5+3+2=15
6+2+4+5+3=20
7+2+3+9+2=23

I have some work, in an **Excel** spreadsheet. 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.

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.