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.

Search All Jobs:

Copy Type 15 Page Word Document

I have been supplied a 15 page Word document that I need copy-typed and re-supplied to me as a Word document/text file. It does not have to be formatted as per the existing document - I simply just need the words as i will be reformatting it in InDesign...

  • Fixed Price Project
  • $30-$250
  • Job Expired

Fill In A Spreadsheet With Data

I want to receive data sets or live feeds directly from the Federal Motor Carrier Safety Administration on every single motor carrier, broker, and freight forwarder registered with the FMCSA. As well as new authority applicants and MC numbers that get issued by the FMCSA each day...

  • Fixed Price Project
  • $250-$750
  • Job Expired

Professional Freelancer Need Job

I am Professional Freelancer and am looking forward working on your projects. I will apply my fullest knowledge and experience in the given projects and implement my duties with determination and devotion...

Skills Required: Copy Typing , Data Entry , Data Processing , Excel , Word
  • Fixed Price Project
  • €30-€250
  • Job Expired

PDF To Word Typing Data Entry

Hello, We are currently in process of digitizing older books ( stories, newspapers etc) . And we need a good typist with proper knowledge of MS-Word . We will provide you website. You just update the data via typing. Please don't use any OCR programs. You need to manually type. Project shou

Skills Required: Data Entry , Data Processing , Excel
  • Fixed Price Project
  • $2-$8
  • Job Expired

Fill In A Spreadsheet With Data

Hi I simply have some data that I would like to take from one document and entered into excel. I'm looking to take the class name and section number and put them into a list from this document. Example: ARCH 100 D100

Skills Required: Data Entry , Excel
  • Fixed Price Project
  • $10-$30
  • Job Expired

Excel Trainer

We are looking for a trainer to give out a full day training in advanced skills in using pivot table with fluent English. Thanks a lot!!

Skills Required: Data Processing , Excel
  • Fixed Price Project
  • $240-$2000
  • Job Expired

Urgent Required Some Excel & Word Work

Project Description: I have 2 works: 1. I have bunch of data in word format text. Need to get that entered on our website...

Skills Required: Copy Typing , Data Entry , Excel , Powerpoint , Word
  • Fixed Price Project
  • $2-$8
  • Job Expired

Create A Logarithmic Function To Match My Criteria

I need a logarithmic function that matches these criteria: The input x is between 0 and 1 The input y is also between 0 and 1, this represents 2 standard deviations (the uncertainty in x) as a percentage of x The output will be between 0 and 1...

  • Fixed Price Project
  • $10-$30
  • Job Expired

Cours Et Solutions De Maths Pour Basique

Je suis un Professeur de Maths 1 - Explication les leçons de maths avec la langue français et Arabie 2- Explication les solutions des exercices de maths 3- les niveaux sont: level 1 et 2 et 3 4- Explication avec des méthodes très faciles 5- augmentation le niveau dans un duré rapide

  • Fixed Price Project
  • €2-€6
  • Job Expired

Script Customization (Bluebell By Scriptsahoy.com)

We are looking for developers or programmers who have experience with the Bluebell script by scriptsahoy.com. Contractor Requirement - Customized the script above below and show us an example before you bid please...

Skills Required: Algorithm , MySQL , PHP
  • Fixed Price Project
  • $750-$1500
  • Job Expired

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • $30-$250
  • Start Date
  • 01/23/2012 08:20:49 AM
  • Job Status
  • Job Expired