Selesai

Quick Excel Macro in Excel 2003

I am using Excel 2003. Occasionally, I have a spreadsheet where I need to solve a value. There are unique provider numbers which take up a single row in the spreadsheet. Each provider number belongs to a geozip, has a number of beds, and a Charge1 value. There is a final column to the right called "Selection" which is unpopulated. This column needs to be populated with a provider number that is not the same provider number in column A. Here is the logic to populate this field: (1) Select a provider number within the same geozip; (2) Select a provider number with the highest number of beds; (3) If criteria (1)(2) yield a value, but the Charge1 is identical, then select another provider number with the next highest number of beds; (4) if there are no geozips that meet the criteria, then go to the next geozip+1, geozip-1, geozip+2, geozip-2, geozip+3, geozip-3, until a suitable value is found.

This macro needs to be written to I can use it on other spreadsheets with the same field structures in columns A-D.

I am attaching a sample file, in which the first 12 rows have been completed.

Keahlian: Algoritma, Excel, Matematika, Statistika

Lihat lebih lanjut: logic algorithm, d algorithm, macro, macro excel, macro + excel, quick excel, populate excel spreadsheet spreadsheet, excel row column, excel macro row, excel unique, excel algorithm, excel column row, macro spreadsheet, populate excel spreadsheet, excel sample file, column row excel, algorithm excel, excel column unique value, populate spreadsheets, criteria selection excel

Tentang Pemberi kerja:
( 35 ulasan ) Saratoga, United States

ID Proyek: #1403460

Diberikan kepada:

vserv

Experienced Excel developer. Have a robust solution. Pls check your messages. Thanks

$30 USD dalam 0 hari
(60 Ulasan)
5.8

18 freelancer menawar dengan rata-rata $47 untuk pekerjaan ini

Teloquence

Consider it done. Check your PM.

$40 USD dalam 0 hari
(206 Ulasan)
6.9
koolsidz

Excel Whiz here ;) Please see PMB

$45 USD dalam 0 hari
(110 Ulasan)
6.0
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLS file. This approach makes further use of the macro very convenient by offering the usual Open fil Lebih banyak

$50 USD dalam 1 hari
(53 Ulasan)
5.7
Krusche

Hello. It's kind of easy work for us. Please check our reviews and examples in your inbox.

$40 USD dalam 1 hari
(21 Ulasan)
5.2
chriskerpini

Excel-VBA instructor, 10 years experience. More details on PM.

$40 USD dalam 0 hari
(20 Ulasan)
4.8
imudita

I have done it. Please see PMB.

$30 USD dalam 0 hari
(27 Ulasan)
4.7
psprongs

I have extensive experience in data processing using excel. Please check PMB

$45 USD dalam 1 hari
(10 Ulasan)
4.5
microk

Excel whiz here. Please see pm.

$35 USD dalam 1 hari
(28 Ulasan)
4.4
FLtowhid

please see my PM.

$80 USD dalam 7 hari
(4 Ulasan)
3.8
sumshank

Thanks for your time in reading my bid. Here is what I can offer: - Excellent MS Excel skills, having used it extensively during my work with the Information Technology industry. - My Excel work includes usage of Lebih banyak

$50 USD dalam 1 hari
(3 Ulasan)
2.4
pradeep1210

Excel VBA expert here. Please see PMB.

$45 USD dalam 0 hari
(1 Ulasan)
1.9
atifta

Excel Guru is here boss

$50 USD dalam 1 hari
(1 Ulasan)
1.2
ziabd

I have longterm experience in developing excel macros. Please feel free to contact.

$30 USD dalam 1 hari
(0 Ulasan)
0.0
olaabiola

I have all it takes to complete your project in good time. Try me out. Check out my Resume. OLAOYE RAFIU ABIOLA OBJECTIVE: Accountant/Book-keeper/Data Entry Specialist/Researcher/ Power point Presentation Lebih banyak

$40 USD dalam 5 hari
(0 Ulasan)
0.0
garyfiginal

Dear Sir, Concern to your demand, 1 .I am able to speak English and Chinese fluently 2. Skype, email, MSN are my regular communication tools. 3. Daily report is no problem. 4. Strong computer skill in Excel, Lebih banyak

$50 USD dalam 3 hari
(0 Ulasan)
0.0
marufok

Excel works are quite easy for me.

$45 USD dalam 2 hari
(0 Ulasan)
0.0
Sandheep76

I can solve this problem. Please see PM

$100 USD dalam 0 hari
(0 Ulasan)
0.0