Excel formula help need one to many vlookup type of formulaemplois

Filtrer

Mes recherches récentes
Filtrer par :
Budget
à
à
à
Type
Compétences
Langues
    État du travail
    7,071 excel formula help need one to many vlookup type of formula travaux trouvés au tarif de EUR
    Do some Excel Work S'est terminé left

    PLATE FORM - EXCEL Vlookup, Hlookup, Pivot Table, Validation, Formatting, Macro, Len, Trim, Proper, True False, Sum, Count, Count A, Count Blank, Chart, Count if, Clean, Concatenate, Filter, Advance Filter, Custom Filter, Right, left, Upper, Lower, Proper, Convert, Tex To Column, Formatting and more excel functions. TYPING SPEED In English

    €25 - €212
    €25 - €212
    0 offres

    As discussed............................................................................................................

    €19 / hr (Avg Bid)
    €19 / hr Offre moyenne
    1 offres

    hi I have this sheet attached and I need a formula for column E to give that result ie if the value in column A is OAR: EMP02717 (1 record) then the result in column E is EMP02717

    €18 (Avg Bid)
    €18 Offre moyenne
    14 offres

    Hello. I have two excel sheet with different value but the code are same so i want someone to use vlookup function and put the accurate match [se connecter pour voir l'URL] details on PM

    €3 / hr (Avg Bid)
    €3 / hr Offre moyenne
    5 offres

    1. Adjust script to find duplicates with more than 30k lines without crashing (maximum run time exceeded) https://docs.google.com/spreadsheets/d/1TS-OkJ8aokBqXyut0_XWCDp5RQ38-WnqBlU_z8fPNlU/edit#gid=0 2. Find a way to identify out of stock products (problem here is that there are more than 200k lines (200000) But could split them into several sheets

    €21 (Avg Bid)
    €21 Offre moyenne
    3 offres

    ...someone to generate the following formula please: - Column E on our excel sheet has times populated in them - the times are usually minutes (for example 21 minutes OR 30 minutes OR 33 minutes OR 1 hour 10 minutes) etc - we would like a formula creating which we will place into an adjacent new column (let's call this column X) - the formula should automati...

    €21 (Avg Bid)
    Garanti
    €21
    9 propositions

    ...in sheet 2 a formula which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe

    €31 (Avg Bid)
    €31 Offre moyenne
    20 offres

    ...column(20180920). I need to figure out the average days in between actions over a certain period X (variable, in # of days). So if X is 30, the formula would look at the average frequency of 'actions' (ie: in days) over the past 30 days. If X is 60, over the past 60 days, etc. See sample under Additional Project Files. I'm looking to f...

    €32 (Avg Bid)
    €32 Offre moyenne
    13 offres

    Hello i wold like to buy the formula that are used in this website: [se connecter pour voir l'URL] The formula, must be in Excel

    €38 / hr (Avg Bid)
    €38 / hr Offre moyenne
    5 offres

    I need a new website. I need you to design and build it based on my specification.

    €165 (Avg Bid)
    €165 Offre moyenne
    21 offres

    Melakukan sejumlah pekerjaan Excel SUM, COUNT, IF, VLOOKUP, LEN, dan lebih banyak pekerjaan Spreadsheet Excel.

    €328 (Avg Bid)
    €328 Offre moyenne
    25 offres

    I need two spreadsheets to be merged together. Then using formulas I need to update one spreadsheet using the others information, without it updating blanks.

    €183 (Avg Bid)
    €183 Offre moyenne
    66 offres

    The candidate should be Android Java Master and have many devices such as Google Pixel, Samsung, Xiaomi, Huawei or Nexus. i am having a crash on the pixel 2xl and a lot of things we are trying to do aren't just working out The app is supposed to take video from both cameras simultaenously, that doesn't work on all devices tough.

    €9 / hr (Avg Bid)
    €9 / hr Offre moyenne
    15 offres

    I NEED AN EXCEL FORMULA CREATED FOR A HYDRAULIC LOSS PIPE CALCULATOR, I WILL PROVIDE A VIDEO OF ME DOING IT THE LONGHAND WAY (BY HAND) I WILL THEN NEED YOU TO CREATE AN EXCEL PROGRAM FOR THE CALCULATIONS TO BE AUTOMATED - THE CALCULATIONS WILL BE BASED OF INPUT DATA EXTRACTED FROM A COMPUTER PROGRAM, THIS DATA WILL INCLUDE PIPE SIZES, ...

    €11 / hr (Avg Bid)
    €11 / hr Offre moyenne
    28 offres

    Only people with knowledge of DAX syntax and Powerpivot apply please. i need a pivot table that has in one of the columns the total amount of th dataset. Please see attachment.

    €21 (Avg Bid)
    €21 Offre moyenne
    10 offres

    My name is Pilar, I am working on building an excel for tax calculation purposes and I am running into some trouble with a formula that I cannot build-in on my own. The excel is basically an annual gain/loss stock portfolio statement that takes the dollar amount of the purchase and sale proceeds and converting it into the official Mexican peso rate

    €86 (Avg Bid)
    LDN
    €86 Offre moyenne
    35 offres

    This should be a quick formula to pass my way. Just need an "IF" formula. As you can see, in Column "A" I will be selecting the status of the MSR, and need it to auto fill the applicable total to the appropriate cell on the right (Received, In Progress, Complete, Shipped) No need to bid on this, as I have a...

    €14 (Avg Bid)
    €14 Offre moyenne
    2 offres

    Help me with Sensitivity analysis, Monte Carlo simulation, optimise the LCOE formula. I have done some part of the work and I need you to improve the overall paper and also help with Sensitivity analysis, Monte Carlo simulation, optimize the LCOE formula. More details will be shared. Thanks

    €102 (Avg Bid)
    €102 Offre moyenne
    10 offres

    I NEED AN EXCEL FORMULA CREATED FOR A HYDRAULIC LOSS PIPE CALCULATOR, I WILL PROVIDE A VIDEO OF ME DOING IT THE LONGHAND WAY (BY HAND) I WILL THEN NEED YOU TO CREATE AN EXCEL PROGRAM FOR THE CALCULATIONS TO BE AUTOMATED - THE CALCULATIONS WILL BE BASED OF INPUT DATA EXTRACTED FROM A COMPUTER PROGRAM, THIS DATA WILL INCLUDE PIPE SIZES, ...

    €73 (Avg Bid)
    €73 Offre moyenne
    73 offres

    Hi there, I have two documents. One shows: * Post code * Names of customers The other shows: * Post code * Longitude * Latitude I need the first document to ALSO show long & lat for all listed postcodes. that's it. So, long/lat' from sheet 2 need to be put onto sheet 1 I need it immediatetly. Very easy job.

    €3 / hr (Avg Bid)
    €3 / hr Offre moyenne
    18 offres

    We have vtiger v6 I believe and want to update if necesary plus obtain full performance. Like graphic reports, woriking automations etc... so the efficiency of the operation increases

    €524 (Avg Bid)
    €524 Offre moyenne
    13 offres

    Hello Freelancers, We are looking for a highly competent person to compile a targeted email list on linked in using Python or another language. We do not want a webscraper to do this manually. Must use a script. Manual will take too long. The FINAL product should just be a long excel list with 5 columns as follows. last name |first name | company

    €9 / hr (Avg Bid)
    €9 / hr Offre moyenne
    20 offres
    Excel formula 9 heures left
    VERIFIÉ

    I need my excel spreadsheet finished with formula ,it cant be done with VBA or Macro because only formula is alowed .

    €26 (Avg Bid)
    €26 Offre moyenne
    110 offres

    I made a robot it has 2 motors and 2 encoders attached the [se connecter pour voir l'URL] reads the value from the wheel...the [se connecter pour voir l'URL] reads the value from the wheel and display on ROS and I can see the movement on RVIS but the movement is not correct so the formula might need to be fix [se connecter pour voir l'URL] works fine but I wi...

    €31 (Avg Bid)
    €31 Offre moyenne
    11 offres

    I have ongoing work related to our previous project 'I need an Excel expert to help me find a solution to this problem via a formula or macro'

    €17 / hr (Avg Bid)
    €17 / hr Offre moyenne
    1 offres

    I need a Tinder Clone Built for Android and iOS. If you already have the source code this is a major plus.

    €1409 (Avg Bid)
    €1409 Offre moyenne
    96 offres

    We have created an excel file with Macro and VLookup that works fine in Windows but when opened on a Mac some of the features don't work. Either nothing happens or errors appear when we click buttons. We want someone to covert the code to be readable by both Windows Excel and Mac Excel

    €81 (Avg Bid)
    €81 Offre moyenne
    10 offres

    Only those guys who have vast expertise making quality links can contact, I need someone work daily basis provide maximum links per day (quality focus) ... Bid win those people who provide quality and no of links .

    €81 (Avg Bid)
    €81 Offre moyenne
    28 offres
    nail polish formula S'est terminé left

    ...suspension. i've made just about every kind of nail polish. Thermal color changing, neon, magnetic etc.... I need someone to create a new nail polish formula for me. all ideas are welcome. when u bid please submit a possible idea so i know u understand this project. you don't have to tell me the entire concept i just need to know u unde...

    €185 (Avg Bid)
    €185 Offre moyenne
    5 offres

    Hi, I have a complicated excel project underway which someone else designed - now one of the formulas doesn't work so I need help on how to extablish the error and then fix it. I need someone who can skype or do some kind of video call and screen share as I'd perfer to talk it through with someone.. I do not want to...

    €8 / hr (Avg Bid)
    €8 / hr Offre moyenne
    19 offres
    help with excel formula S'est terminé left

    I have a difficult excel set up which someone else built for me - One of my formulas is not working and I need help to work out how to fix it.

    €8 / hr (Avg Bid)
    €8 / hr Offre moyenne
    70 offres

    I need a formula or macro that will find in file [se connecter pour voir l'URL] values (article code searched) as in uploaded files values like in [se connecter pour voir l'URL]

    €76 (Avg Bid)
    €76 Offre moyenne
    40 offres

    Create a probability formula relating to blockchain Proof-of-Work systems: Given: 1. a hash of N bits, 2. a 'difficulty' of L leading zero bits, 3. a matching hash (generic solution S) is found on average in M minutes. (by varying a part of the input data, nonce) Someone selects one predetermined hash fitting the above requirements and sea...

    €433 (Avg Bid)
    €433 Offre moyenne
    6 offres

    Business card, flyer, 3-fold leaflet, catalog, book cover, sticker, logo, etc. I would like to purchase design samples for printed materials. There should be no copyright issues at all. I want an eps or svg file. if you do business with us, you will continue to work for years.

    €82 (Avg Bid)
    €82 Offre moyenne
    28 offres

    I want you to make web scrapping and build a list of some company. I will give more details on message. Bid only for those who are honest and responsible freelancer. Thanks

    €21 (Avg Bid)
    €21 Offre moyenne
    44 offres
    writing many S'est terminé left

    I need you to write a report for something.

    €25 (Avg Bid)
    €25 Offre moyenne
    22 offres

    We have a dashboard that holds some sensitive data on the backend, I need this data to be moved into a seperate workbook and a series on vlookup / Importrange formulas created to make the sheet read from the data workbook. NO more than 10 formula

    €19 (Avg Bid)
    €19 Offre moyenne
    5 offres

    Hi, I have an excel spreadsheet that I need to calculate the vector angle of the three plot points I have. Please modify my excel spreadsheet to memorize this conversion and input results in F column for each row. Also, please give me the math algo equation written on a notepad to calculate the vector angle. This way I can use it in other projects

    €22 (Avg Bid)
    €22 Offre moyenne
    19 offres

    I need your help to write a simple script to perform below actions. 1. download csv files in loop. I have 1 url which will have one variable parameter which is an incremental number to be looped for reference: this is what I have written in VB MyUrl = 'https://somewebsite.com/parameter1=something&parameter2=' for i = 1 to 30 MyNe...

    €20 (Avg Bid)
    €20 Offre moyenne
    14 offres
    excel formula needed S'est terminé left

    hello, i need an excel formula which would count the number of occurences in a column , attached is the sample file, the result should give me the list of codes that are present in column A , and count how many times it appears in the whole column. this is a very simple task, expected budget is 5$

    €10 (Avg Bid)
    €10 Offre moyenne
    37 offres

    Knowledge about Waveguides is a must. I will provide you with the code and the formula. The code is an implementation of a 2d rectangular waveguide.

    €22 (Avg Bid)
    €22 Offre moyenne
    15 offres

    I have a too many connections issues on my mysql I need to fix this issue by knowing exactly and accurately what the cause is.

    €115 (Avg Bid)
    €115 Offre moyenne
    21 offres

    I want to recruit a great virtual assistant to help me 10hr each day. Key activities will involve 1 - sending out emails on my behalf (which we can write together). 2 - helping me with managing lists & prospects 3 - general admin work & follow up 4 - have many skills do get and generate data. 5 - work full time without any bound. 6 - Very efficient

    €3 / hr (Avg Bid)
    €3 / hr Offre moyenne
    48 offres

    ...business logic in Excel and need a formula to scan several hundred transactions to find circular payments. In the example, A pays B, B pays C, C pays D, D pays E, E pays F, F pays A the elimination formula needs to remove from each payment the smallest circular amount. (A pays 180 to B; B pays 30 to C; C pays 50 to D; D ...

    €282 (Avg Bid)
    €282 Offre moyenne
    36 offres
    Excel Formula for worksheet S'est terminé left

    Need an Excel formula worker to duplicate words in a row to produce variations on a id number. example. hello1, hello2, hello3 etc. Please don not apply unless you know how to do device the right formula to duplicate these numbers Pays $30 AUD

    €16 (Avg Bid)
    €16 Offre moyenne
    6 offres

    I need a formula to calculate the difference between 2 values output in a percentage. 2 columns Actual and Forecast, where if actual is 0 and forecast is 0 - result 0%. Actual is 0, forecast 10 - result - (100%). Actual 10, forecast 0 - result - 100%

    €20 (Avg Bid)
    €20 Offre moyenne
    28 offres
    Do some data entry S'est terminé left

    I have some work, in an Excel spreadsheet. Vlookup Hlookup Pivot analytics Data representation Formulas and

    €91 (Avg Bid)
    €91 Offre moyenne
    57 offres

    wp task ongoing for many [se connecter pour voir l'URL] task ongoing for many [se connecter pour voir l'URL] task ongoing for many [se connecter pour voir l'URL] task ongoing for many [se connecter pour voir l'URL] task ongoing for many [se connecter pour voir l'URL] task ongoing for many fixes.

    €2 / hr (Avg Bid)
    €2 / hr Offre moyenne
    13 offres