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:

Excel User Form

I want an Excel user form built and I want it to function in this way: Any data entered, should appear in the excel file - This excel would be shared among company staff so I want it in a way that if employee enters details on the on their copy of excel, they will not be able to edit but can read;..

Skills Required: Excel , Software Testing
  • Fixed Price Project
  • $10-$30
  • Job Expired

Job Offers Data Processing

For our job board in India, we propose 2 missions: 1. Publish job offers on our job board (language : English, location : India) 2...

Skills Required: Data Entry , Excel , Web Scraping , Web Search
  • Fixed Price Project
  • €30-€250
  • Job Expired

Assignment Report For Algorithm And Advanced Data Structure

All Pairs Shortest Paths Problem (APSPP) Consider a weighted complete graph G with vertex set G.V = {v0, v1, v2, ..., vn-1}. The weight of the edge from vi and vj is denoted as G.w(i, j). It is assumed that the weights of the edges are non-negative...

Skills Required: Algorithm , Mathematics
  • Fixed Price Project
  • $12-$150
  • 5 hours, 53 minutes left

Do Some Excel Work

I have filled an excel (.xls) spreadsheet with 80+ tabs and a bunch of individuals names that include URL hyperlinks. All of the hyperlinks are in the spreadsheet already. Please run a macro, extract the data required (see instructions), and combine it all into one tab...

  • Fixed Price Project
  • $10-$30
  • 4 days, 19 hours left

Do Some Work In Excel

I have filled an excel (.xls) spreadsheet with URL hyperlinks. All of the hyperlinks are in the spreadsheet already. Please run a macro, extract the data required (see instructions), and combine it all into one tab. Here are the directions: 1) Open .xls spreadsheet 2) The source tab in the ...

  • Fixed Price Project
  • $10-$30
  • 4 days, 19 hours left

Do Some Excel Work

I have filled an excel (.xls) spreadsheet with 80+ tabs and a bunch of individuals names that include URL hyperlinks. All of the hyperlinks are in the spreadsheet already. Please run a macro, extract the data required (see instructions), and combine it all into one tab...

  • Fixed Price Project
  • $10-$30
  • 4 days, 22 hours left

Count And Label Objects In A Photo

The attached photo of a ceiling has thousands of small acoustic circles attached to the ceiling. I need someone to COUNT the number of acoustic circles AND label each one of them with a unique (small but legible) number so it is easy to verify the total count of circles.

  • Fixed Price Project
  • $10-$30
  • 5 days, 23 hours left

Time Series Predictive Model Using C# Language

I need to add on a time series predictive model feature on my current application, based on auto regressive model, using the Least Square Minimization Algorithm. It must be done using visual studio 2010, C# programming language...

  • Fixed Price Project
  • $30-$250
  • 6 days, 5 hours left

Time Series Predictive Model Using C# Language

I need to add on a time series predictive model feature on my current application, based on auto regressive model, using the Least Square Minimization Algorithm. It must be done using visual studio 2010, C# programming language...

  • Fixed Price Project
  • $30-$250
  • 6 days, 5 hours left

Build And Run Code Using Microsoft Visual Studio -- 2

I've installed Microsoft visual studio Express, but I've been unable to run the demos of the svdfeature toolkit (see http://jmlr.org/papers/volume13/chen12a/chen12a.pdf) on my PC (windows 8, 64 bit)...

  • Fixed Price Project
  • $15-$25
  • 6 days, 23 hours left

Job Details

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