Find Jobs
Hire Freelancers

Transforming dataset into a different layout - Formula or Array Formula only

$30-250 USD

Tamamlandı
İlan edilme: 5 yıldan fazla önce

$30-250 USD

Teslimde ödenir
Hi, Please take a look at the attached document. This shows an example of my 'dataset', and the layout of how I would like it to be transformed... 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 example. I have colour coded the data to make it easier for you to understand what's happening. Please take a look and let me know if you are capable of helping me. Thank you very much.
Proje No: 17973733

Proje hakkında

18 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 5 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
Hi I m here to assist u inthis project I am an ACCA U.K member currently working in finance dept of a leading airline of the world I have more than 4 Years of accountancy and finance experience and have great skill and experience in Power BI , Power Pivot, DAX. Functions, Financial planning , advance excel formulas and Excel Dashboard preparations ****** You can read client reviews on my profile for my ExcelSkills********** Can assist you with high regards Plz share more info to proceed in project. And we can discuss more details in chat and also have a short call to discuss project Thanks in anticipation Looking forward for this project Regards Obaid
$72 USD 3 gün içinde
5,0 (18 değerlendirme)
4,0
4,0
18 freelancers are bidding on average $103 USD for this job
Kullanıcı Avatarı
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Statistics, Visual Basic. Please ping me for more discussion.
$160 USD 3 gün içinde
4,9 (300 değerlendirme)
7,7
7,7
Kullanıcı Avatarı
Hi, it's a very tricky task since you want just formulas... I propose the following : if you are okay, you an award the project and create the milestone. I ll not accept the project before getting it resolved. If I can't do it I ll refue the project. Thanks
$100 USD 2 gün içinde
4,9 (263 değerlendirme)
7,4
7,4
Kullanıcı Avatarı
Hello, I’m an Excel expert and I would like to help you with your formula. Please send me a message so that we can discuss more.
$50 USD 3 gün içinde
4,9 (282 değerlendirme)
7,2
7,2
Kullanıcı Avatarı
Hello, I have a solution to allow transforming dataset into a different layout using formulas only. I can submit a file immediately. Best regards, Duong
$50 USD 0 gün içinde
4,8 (24 değerlendirme)
6,2
6,2
Kullanıcı Avatarı
Hello, I have created the formulas already! It was a challenge but I have done it :) No macros, no pivot, no array,no filters. Only plain formulas. Please open a chat with me. Kind regards, Sorin
$30 USD 0 gün içinde
5,0 (44 değerlendirme)
4,9
4,9
Kullanıcı Avatarı
"Hi, I would love to help you in your Current Project and it would be with confidence and satisfying results. I'm look forward to hearing from you about the project. Best Regards"
$30 USD 3 gün içinde
4,9 (15 değerlendirme)
3,4
3,4
Kullanıcı Avatarı
Hello, Yes, it is possible but with some constrains. Your data must be put in some restrict styles and places in order for formulas to work because Excel formulas work base on cell positions. If you want to change the positions of your data block then you must understand the formulas to make corresponding changes. I had done some works on your file and it seem very promising. Please pm me for further discussion. Thank you!
$35 USD 3 gün içinde
4,8 (9 değerlendirme)
2,8
2,8
Kullanıcı Avatarı
Dear, I'm mechanical engineer from Bosnia and Hercegovina with good experience in computer sciene I can finish this job very fast and quality. Best regards.
$200 USD 3 gün içinde
5,0 (1 değerlendirme)
1,6
1,6
Kullanıcı Avatarı
Dear Sir, I write in light of your promotion searching for an information passage aide. As an extremely competent information passage right hand, I would bring an inventive, self-composed, and enthusiastic aura to this part. I have a skill for basic reasoning and capacity outstandingly self-sufficient and with little oversight. I respond to requests in an advantageous way and am capable at organizing different progressing ventures. My experience, certifications, and references are immaculate; I am sure you'll see me to be a prevalent contender for the situation of Data Entry Assistant. I am anticipating got notification from you and much thanks for your opportunity and in addition any thought you may give me. Best regards, Moudud Ahammad
$35 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I can help you with anything with Excel. To prove it, I'm bidding the lowest. you can trust me with any Excel related. I'm rated 4.2/5 in ExcelChat(onine excel tutoring platform)
$35 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
hi there, i used to create a template almost like your requirement for my previous company uaing google spreadsheet and using formulas only. no macros at all. i think this job can be done by me.
$166 USD 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
i just did this excel only with formulas like: index, look, count....
$166 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Yes - it is possible by using formula - However some sets of data will return blank Example: Ref 4 Match1 Ref 4 Ref 4 Thats the only way without using some automated manipulation
$88 USD 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hello. My name is Alejandra Baptista I am an accountant, administrator and financial graduated. I am very fast typing and good in redaction or transcription. I have a lot experience with Excel, SPSS Modeler, customer service, accounting and payroll software, working under pressure, leadership, data mining, data entry, web scraping, data analysis and another fields. I like to work very structured. I speak Portuguese and Spanish fluently. My Oral English is basic, but I can read and write very well in English. I have read your specificafions and I am capable of helping with your project, maybe SPSS. Thanks for the opportunity
$100 USD 2 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I can help you un Excel More details
$155 USD 5 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I just saw ur example can u explain more about this.
$222 USD 5 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi! Good day! With regards to your project, i was trying to attached my sample hat I put formula but I can't, anyhow I am interested in working for this project and I assure you that you will not regret choosing me for this job as I have strong attention to details, easy to communicate and hardworking. We can discuss other details if you give me a chance to do this for you. Sincerely yours, Maica Yver Reyles Applicant
$166 USD 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED KINGDOM bayrağı
IPSWICH, United Kingdom
5,0
5
Ödeme yöntemi onaylandı
Tem 6, 2002 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.