Tamamlanmış

Excel File - Data Filter and Sorting

Attached is the list of information. I need:

a. On tab "MasterSheet.RFS.20180709.Year.V" filter and put into Year tab (2015, 2016..) respectively and label into different color based on year. The identification of year is based on the field "rfsdate".

b. Mark down the unique "LongLat" field in Year tab with YELLOW COLOR since there are many fields duplicates.

Refer: [login to view URL]

Beceriler: Veri Girişi, Veri İşleme, Excel, Microsoft Office, Visual Basic

Daha fazlasını gör: difference between filtering and sorting, sorting and filtering in excel 2013, sort and filter in excel definition, sort and filter in excel 2016, sort grouped rows in excel, filter grouped data in excel, sort and filter in excel 2007, sort and filter in excel 2010, vendor product excel file data sheet, excel file data points, vba code import excel file data access table, insert excel file data database using jsp, excel file data manipulation, insert excel file data mysql jsp, imdb excel file data

İşveren Hakkında:
( 1 değerlendirme ) Petaling Jaya, China

Proje NO: #17351504

Seçilen:

ShivamShahi1

Hello, I Bid for less amount because I am new here on this platform and I wish to get my first project. I will give 100% to make my first project satisfactory to my client. I have done several web scrapping project Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(0 Değerlendirme)
0.0

Bu iş için 34 freelancer ortalamada $25 teklif veriyor

schoudhary1553

Hi there, Warm Greetings We came along with your request for Excel File - Data Filter and Sorting and we reviewed your project description. We'd like to help you with confidence and satisfying results. We Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(270 Değerlendirme)
7.6
prameswara

Hello Sir Im excel VBA macro and formul Expert :) i can do Data Filter and Sorting job like u need Sir :) please give me this job and im able to start working today Thank You Sincerely Galih AP

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(327 Değerlendirme)
7.0
sohandas

can't open the google sheet, kindly change the sharing setting............................................................thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(185 Değerlendirme)
6.6
best4best

Hi, I am an Excel expert and ready to filter and sort your spreadsheet as per your requirement. Regards Soni

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(190 Değerlendirme)
6.5
leelakalidas32

Hello Sir, i am Ajay from India without wasting our both time i want to work for your sample file for selection for this [login to view URL] allow me to start sampling .contact me anytime i am always here. Relevant Sk Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(119 Değerlendirme)
6.2
luckypmba

I am expert in excel Handling, i can create macro to sort out/remove any unwanted data(even from urls or from any where in the sheet). I have done 300+ excel tasks like matching the results, comparing using macro and Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)
6.5
devi222

Hi Sir, Im expert in excel. I can finish this task in just 1 hour starting right now. Pls leave a message i read the project description

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(134 Değerlendirme)
6.2
citijayamala

1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Ex Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(47 Değerlendirme)
5.2
andreeafanea

Good afternoon! I am a reliable, hard-working and results-driven professional who is seeking freelancing opportunities in the area of virtual assistance. I excel working under tight deadlines and I have a strong wo Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(31 Değerlendirme)
4.5
nurnga1218

Hi, I'm an excel and VBA expert. So filter and sorting absolutely not problem at all for me. But from the link you provided, I can't access it yet. I'll try to make a concept and show you once I've got the file. I hope Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(39 Değerlendirme)
4.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(20 Değerlendirme)
4.1
Diliphero

Greetings, I am a professionally qualified Accountant from Sri Lanka with A degree in Management & Finance. I am a QuickBooks Pro-Advisor. I have 17 years of experience in Audit, Accountancy, Direct and Indirect tax Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
3.8
vandana1986

Hi, I can do the task accurately and perfectly. I understood this project's requirements exactly. I am representing my bid as a core interest and available to further discussion. I am waiting for your reply to discuss Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
4.4
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
3.8
ttthivi

Hi, This excel work is simple for me. My only question is when do you need this to be done. Lets have chat about this. Thanks Thiviyan

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
2.9
sevillajk01

hi! let me help you with your project. I have done similar project like this in excel. thanks your data needs to be fixed because it's too large for a file like that.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.1
juvigy

Dear Sir/Madam, Please consider my offer for this project. BR, Stoyan Delchev ........................................................................

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
2.2
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.7
lovelyfaheem

I read your job post and Understand your requirement. I will do it in a short time as soon as possible and In a low budget. I will do Data Filter and Sorting. My specialty is providing high quality work in a timely fa Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.2
rahulishq9999

"I will use all my computer and internet skills to help attain high-quality results, on time." HIRE ME! I am nice and professional and guarantee a WOW experience.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0