Do some Excel Work

kr192-1600 SEK

完了済み

投稿日:

8年以上前

kr192-1600 SEK

完了時にお支払い

I have a sheet that hold very much information on the first sheet regarding our dealers network. I need a formula that can find a specific dealernumber in the columns and then returns specific values from specific questions. The problem is that the data that is pasted in the major sheet (data sheet) is not always located in the same cells. For example. A dealer with number 111 may not always be present in a specifik column since the number of dealer may chance and then the source data is changed. Also, the data that shall be returned may not always be in the same cells. So, I need a formula that find values on both X and Y-lines and then returnes the values it finds. It must be rather easy for someone with some experience.

Data Entry

Data Processing

Excel

プロジェクト ID: 8650659

プロジェクトについて

12個の提案

リモートプロジェクト

アクティブ 9年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

kr630 SEK 3日以内

4.8

(269 レビュー)

7.1

この仕事に12人のフリーランサーが、平均kr818 SEKで入札しています

@nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards

kr444 SEK 1日以内

4.9

(62 レビュー)

5.7

@andreapellicci

Non hai ancora fornito una proposta

kr330 SEK 3日以内

4.7

(10 レビュー)

2.4

@tanaygoregaokar

A proposal has not yet been provided

kr995 SEK 3日以内

0.0

(0 レビュー)

0.0

@mavibay

Hello, I am experienced in using excel. I am a mechanical engineer and writing even visual basic code macros for excel. Iwant to try your work and we can deal about the price. Let me first see the documents then I will say if I can pepare right now. Regards

kr995 SEK 3日以内

0.0

(0 レビュー)

0.0

@abrarahmadzafar

A proposal has not yet been provided

kr333 SEK 10日以内

0.0

(0 レビュー)

0.0

@ashtavinayak

The syntax of the function is: TREND( known_y's, [known_x's], [new_x's], [const] ) Where the function arguments are as follows: known_y's - An array known y-values. [known_x's] - One or more arrays of known x-values. This is an optional argument which, if provided, should have the same length as the set of known_y's. If omitted, the set of [known_x's] takes on the value {1, 2, 3, ...} [new_x's] - An optional argument, providing one or more arrays of numerical values representing a set of new x-values, for which you want to calculate the corresponding new y-values. Each array of [new_x's] should correspond to an array of [known_x's]. If the [new_x's] argument is omitted, it is set to be equal to the [known_x's]. [const] - An optional logical argument that specifes whether the constant 'b', in the straight-line equation y = mx + b, should be forced to be equal to zero. If [const] is TRUE (or if this argument is omitted) the constant b is treated normally; If [const] is FALSE the constant b is set to 0 and the straight line equation becomes y = mx. The Trend Function as an Array Formula: If more than one new y-value is to be calculated by the Excel Trend function, the new values will be returned as an array. Therefore, the function must be entered as an Array Formula. To input an array formula, you need to first highlight the range of cells for the function result. Type your function into the first cell of the range, and press CTRL-SHIFT-Enter.

kr995 SEK 3日以内