Lengkap

Microsoft Excel formulas and tables

I need someone who knows how to use excel functions and tables and things like that to fill out the highlighted portions in the sheet labeled “Mo 1” and “Jan 1” by using the data in Sheet 1.

Sheet 1 is a list of People with ID numbers in column A with their payment history in columns D and the amount they paid in Column E.

In the sheet labeled “Mo 1” I want to see the amount they paid in the first month they made a payment, and then the amount they paid in each subsequent month. For example, if John Smith made their first payment in February ’17 and Bob Smith made their first payment in April ’17, those months would be “Month 1” for those two people.

Then in sheet “Jan 1”, same thing except it is broken down by the actual month.

I have attached a link to the spreadsheet – if you are interested in the project, please only respond “I have filled out the two people in the sheets you’ve requested” and then fill out sheet “Mo 1” and “Jan 1” for the Identifier or Name of these two people 1) 387187Edwardo Conde and 2) 617171sadagat kamalifard

If you do not follow the instructions exactly in the above paragraph, you will not be considered, Thank you

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Microsoft Office, Visual Basic

Lihat lagi: excel structured reference specific cell, absolute structured references in excel table formulas, excel table reference absolute, excel table formula autofill, excel table formula, excel table reference, =table excel, =table() excel, www microsoft excel formulas, microsoft excel formulas, microsoft excel formulas cheat sheet, microsoft excel end chapter project open bidding, microsoft excel spreadsheet template project management, supply chain formulas microsoft excel, microsoft excel project

Tentang Majikan:
( 38 ulasan ) Los Angeles, United States

ID Projek: #16386319

Dianugerahkan kepada:

sunprah2018

As you mentioned "I have filled out the two people in the sheets you’ve requested” and then fill out sheet “Mo 1” and “Jan 1” for the Identifier or Name of these two people 1) 387187Edwardo Conde and 2) 617171sadaga Lagi

$30 USD dalam sehari
(6 Ulasan)
3.8

28 pekerja bebas membida secara purata $34 untuk pekerjaan ini

cgullapalli

Hi, I am good at Excel formulas and vba. I have referred the requirements. I would like to discuss it further to start work on the project. I have filled out the two people in the sheets you’ve requested Pleas Lagi

$30 USD dalam 0 hari
(719 Ulasan)
7.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD dalam sehari
(271 Ulasan)
7.1
TonmoyRoy111

I have filled out the two people in the sheets you’ve requested Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you wil Lagi

$30 USD dalam sehari
(258 Ulasan)
6.5
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME [login to view URL] allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL Lagi

$25 USD dalam sehari
(65 Ulasan)
5.7
satishtl

- Went through the descirption. - Can have the lead amount paid month wise from the beginning month and the other Jan to Dec. - Can be done in a day, I cant attach sheets here so here is the data. 387187 Edwardo C Lagi

$25 USD dalam sehari
(45 Ulasan)
5.5
whitehorsetechn

Greeting, I have understood your Microsoft Excel formulas and tables task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Entry, Data Lagi

$50 USD dalam sehari
(13 Ulasan)
5.2
beltran0404

Good day, I have filled out the two people in the sheets you’ve requested. I am Luis and I can help you with your Excel project. Please contact me by chat and then we could discuss better your project! Kind reg Lagi

$25 USD dalam 2 hari
(89 Ulasan)
5.1
laurajiannaras

I have filled out the two people in the sheets you’ve requested. Since there must be a least 100 characters to my proposal, here is an explanation of my implementation to accomplish the results, as I have already ap Lagi

$30 USD dalam sehari
(6 Ulasan)
3.7
Ahmed818

Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft Lagi

$10 USD dalam sehari
(20 Ulasan)
3.5
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas etc. thanks

$25 USD dalam sehari
(11 Ulasan)
3.3
ReneRondon

I have filled out the two people in the sheets you’ve requested. Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you a Lagi

$30 USD dalam sehari
(12 Ulasan)
2.8
andrewmikhail95

hi my name is andrew mikhail i can do this for u in less time and u will get a perfect work i can send u more than 1 sample ;)

$10 USD dalam sehari
(3 Ulasan)
2.3
mdahdoli

A proposal has not yet been provided

$30 USD dalam 7 hari
(1 Ulasan)
1.0
SureshXobos

I have filled out the two people in the sheets you’ve requested. 387187Edwardo Conde April '17 $39.00 617171sadagat kamalifard June '17 $495.00

$15 USD dalam sehari
(2 Ulasan)
0.7
$25 USD dalam sehari
(0 Ulasan)
0.0
veniaminspivak

I wrote a small program, with which I had already done half of the work. The program already selects the first payment of people to the "Mo 1" sheet. If you are interested in my results, contact me and we will discuss Lagi

$15 USD dalam sehari
(0 Ulasan)
0.0
ParadoxEditor

i will work properly. i have proper knowledge about copy typing , data entry , data processing . I am expert in excel . I have proper knowledge about web searching . I assured that you don't frustrated by me.

$21 USD dalam sehari
(0 Ulasan)
0.0
Jahidj

Dear Sir, I’m interested in this [login to view URL] of your terms and conditions.I’m confident to perfect delivery about this project. Thanks and regards.

$25 USD dalam 7 hari
(0 Ulasan)
0.0
johnp9603

I love doing data entry and I am certain I will do a good work for you and even be considered a long term partner or freelancer Relevant Skills and Experience Well versed with excel and data entry

$25 USD dalam 2 hari
(0 Ulasan)
0.0
JohnPantazis

Hello, Please attach the correct file. I am an Excel Expert and I can help you right away. You are making reference to a file that is not attached. I am new to freelancer.com but i have more than 15 years of busin Lagi

$30 USD dalam 0 hari
(0 Ulasan)
0.0