Excel Formula for Large Data Set with Multiple Spreadsheets

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

Need a formula that looks up the value of two criteria and matches it with a unique outcome variable. In the example document attached, we are looking for a formula that finds the unique ID (outcome variable) of each city, given the state that it resides. The formula must be easy to replicate across large data sets without any errors and will be used in a macro across dozens of spreadsheets.

Excel Visual Basic

ID Проекту: #10878974

Про проект

35 заявок(-ки) Дистанційний проект Остання активність 7 роки(ів) тому

35 фрілансерів(-и) готові виконати цю роботу у середньому за $70

seaanddream

Hi, my name is Sevinc. I read your "Excel Formula for Large Data Set with Multiple Spreadsheets" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and read Більше

$70 USD за 2 дні(-в)
(283 відгуків(и))
7.8
schoudhary1553

Dear Project Poster, I have 5 years of experience. I am looking for projects. Let me give an opportunity to work

$80 USD за 0 дні(-в)
(326 відгуків(и))
7.9
deepbluetech

Hi, I am an Excel formula / macro expert and would be happy to take on your project. Please confirm and I shall deliver the formula within a day. - What is the maximum number of rows to expect ? - I am assuming t Більше

$50 USD за 1 день
(202 відгуків(и))
7.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD за 1 день
(330 відгуків(и))
7.3
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by crea Більше

$35 USD за 2 дні(-в)
(234 відгуків(и))
7.4
zebracaro

I can do it for you quickly and exactly by vba. it í simple with one click

$150 USD за 5 дні(-в)
(125 відгуків(и))
7.0
someka

Hi there. Lets write your lookup formula. It can be achieved with native functions (so we dont need to vba code) Message me..

$74 USD за 0 дні(-в)
(142 відгуків(и))
7.2
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail Більше

$50 USD за 0 дні(-в)
(344 відгуків(и))
6.9
cugamelover

I can do exactly what you need within 24 hours or less. I'm a computer science professional with a PhD degree and extensive experience in Excel, macros, and VBA. I've done a lot of similar work. Please see reviews on m Більше

$50 USD за 3 дні(-в)
(183 відгуків(и))
7.1
DanielVizcaya91

HI there. I would be glad to help you out with this project. I work with large databases on a daily basis, which is why I have to combine data together all the time. I can create an easy formula for you to do what you Більше

$99 USD за 1 день
(88 відгуків(и))
6.7
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will give reference of my online work portfolio once I heard from you. I am ve Більше

$98 USD за 3 дні(-в)
(45 відгуків(и))
5.6
surekash7096

I have the expertise in Excel formulas and can create this one as per your requirement, quickly. Ready to start work immediately.

$50 USD за 1 день
(67 відгуків(и))
5.3
mallikasomu87

Hi, I have 7 years of experience in MS advanced excel data analysis, formatting, formulation, pivoting, charts, dashboards, reports, VBA automation. I can create this formula that can work for large dataset for you Більше

$30 USD за 1 день
(15 відгуків(и))
4.1
GeniuSBraiN

Hello, I can do the task in less time, and 100% accurate - I'm an experienced software developer specialized in desktop applications, tools, and scripts. - Have a long experience with MS-Excel (formulas & VBA macro Більше

$90 USD за 2 дні(-в)
(8 відгуків(и))
4.2
wissamSabry

I am an advanced user with over 10 years of MS Excel experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft E Більше

$50 USD за 0 дні(-в)
(14 відгуків(и))
4.3
milanmartinjuk

Hi, I can create the formula which could generate unique ID from the first letters of cities and states. This formula will be user-friendly because I could make it in VBA and insert in every cell as a function (UDF) Більше

$50 USD за 2 дні(-в)
(20 відгуків(и))
4.0
excel4engineers

Thanks for your instructions and example, it is clear. I will create new excel function called findid which will be used as average,min, max ..etc. You will be able to drag this function and copy it any where in the Більше

$30 USD за 1 день
(17 відгуків(и))
3.6
JLQ006

I can give you the formula in 3 hours if you award the project to me now. I've been using excel for 7 years so I'm pretty sure the project is easy.

$55 USD за 1 день
(16 відгуків(и))
3.7
mjanecek

Hi, thank you for posting your project. It is a very nice job. I could create a simple custom formula. It could be ready in three days for 100$. Check the feedback I received from my previous employers please. Feel Більше

$100 USD за 3 дні(-в)
(7 відгуків(и))
3.9
evidyarthi

Hi, I can complete this task in less than half an hour You can pay me after you have received the working formula We can chat before you award me the project Looking forward to hear from you and co Більше

$30 USD за 1 день
(6 відгуків(и))
2.6