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.
Hello there, I need some help with me Discrete mathematics final exam. This will be an urgent situation, with the exam being due in 24 hours. I have the exam in word doc format This is the book we are using for the class http://www.amazon...
Kindly find attached the problems. I have 6 matrix problems I need help in. Please have a look and let me know whether you can do it. I need the answers and some brief explanation of the procedure, if any.
Hi, I need a converter. encrypted key in the string. I have a set of encrypted keys, using the same encrypt, which correspond to strings accurate. I need know wihich encrypt is used and to create a small form for automatic encrypt/decrypt. Leave a message and send a sample of it. Bid, Only skille
Hello Freelancer !! I need an expert of statistics .I have an assignment .so if you have knowledge then place bid here I am waiting thanks..................................................................................................................
Project Description: Datamining project: need to take a real dataset and generate 10 natural language queries from that .Use weka software and we have to execute those all queries using that software with a neat documentation which includes all diagrams...
Need to create a simulation of sensor networks using Matlab and would be able to show nodes communicating with each other, sending messages from sink node to other nodes and response back.
Hello I need an expert of statistics so if you have knowledge in statistics then please bid .............. Thanks happy bidding .. It's ongoing work I have a many clients which wants math related help .so it's great opportunity for you guys