Find Jobs
Hire Freelancers

Array Comparison Script for Google Sheets

$10-30 USD

Zamknięte
Opublikowano 5 miesięcy temu

$10-30 USD

Płatne przy odbiorze
I need a customized script that works within Google Sheets to continually scan for differences in an array. Specifically, I am interested in identifying both additions and deletions to the array. I need a custom google sheets script that is checking two different cells. Each cell has items SKUs as an array. For example Cell 1 has XF11088, XF11088, VS11088, VS11088 I have a second cell that is importing scan data from google appsheet The data for example could be VS11088. I need a script that compares cell 1 and 2 and tells me the differences. In my case the differences should be XF11088, XF11088, VS11088, as the cell 2 has a single scan of the VS11088 Scope: • The script should be designed to actively check for differences at regular intervals, ideally every hour. • Most importantly, the script must monitor the array for both additions and deletions, rather than solely one or the other. Skills and Experience: • Experience with Google Sheets scripting • Knowledge of array management • Coding skills for creating active formula scripts Please note, at this time there's no requirement for additional functionalities like email notifications or auto-updating the array. The primary aim is the development of an efficient script to track additions and deletions in the array.
Identyfikator projektu: 37589071

Informację o projekcie

15 ofert
Zdalny projekt
Aktywny 4 miesiące temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
15 freelancerzy składają oferty o średniej wysokości $28 USD dla tej pracy
Awatar Użytkownika
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$80 USD w 2 dni
5,0 (8 opinii)
5,3
5,3
Awatar Użytkownika
Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within some hours
$30 USD w 1 dzień
4,7 (33 opinii)
5,0
5,0
Awatar Użytkownika
Hi there, Im ige, a Google Sheet expert and a seasoned data processing professional. Need a script that compares two arrays from cells that runs every hour? Please message me and let's discuss your requirements further. I'll be standing by to help.
$28 USD w 1 dzień
5,0 (13 opinii)
4,3
4,3
Awatar Użytkownika
Hi, I'm an experienced Google Apps Scripts developer. I can write a custom function for Google Sheets that you can use in cell 3 to compute differences whenever the data in cells 1 and 2 gets updated. You don't have to set an hourly interval to run the code. The custom function will work and behave just like the built-in functions. So, let's discuss your project with me. Start the conversation by sending me a message, even when I appear offline. I typically reply within a few minutes when online and in a few hours when offline.
$25 USD w 1 dzień
4,9 (8 opinii)
4,4
4,4
Awatar Użytkownika
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$30 USD w 4 dni
5,0 (8 opinii)
3,5
3,5
Awatar Użytkownika
Greetings, I am a skilled Google Sheets script developer with extensive experience in array management and active formula scripting. I understand the specific requirements of your project, and I propose to create a customized script that efficiently scans for differences in the specified cells, identifying both additions and deletions in the arrays. The script will be designed to run at regular intervals, ideally every hour, ensuring real-time monitoring. My expertise in Google Sheets scripting and coding skills will be employed to deliver a reliable solution focused on tracking changes in the arrays without the need for additional functionalities. I look forward to contributing to the development of an efficient and effective script tailored to your unique needs. Best regards, Zafar
$20 USD w 1 dzień
5,0 (3 opinii)
2,9
2,9
Awatar Użytkownika
Hi, I created the required Google sheets custom script/function, Tested, Working and Reday, Check smaple data and output here: https://docs.google.com/spreadsheets/d/1XetOp0WxD5-2KmqosGY8RG1MRusFZEHp95tZ9flE1lY/edit#gid=0 wait the sheet to load completely, refresh to load the function, and check , let me hear from you soon Will be happy to help! CHEERS :)
$30 USD w 1 dzień
5,0 (1 opinia)
1,4
1,4
Awatar Użytkownika
I have read your requirements of Array Comparison Script for Google Sheets. I’m pretty confident that I will be able to get your work done within the given time your requirements conclude. I am very keen to discuss further. You can reach me at any time on online. I have also a few clarifying questions on the project. I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards, Vishal Agrawal
$20 USD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within some hours
$20 USD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I have been working in spreadsheet and App scripts for the last 10 years locally with small businesses. Have made entire management systems for them using Google sheets and app scripts. Since I am new in Freelancer and am looking for building a good profile here, I am ready to work at reduced rates. I am confident to complete your request of creating depended dropdown lists. I am quoting it as low as possible so as to get a few jobs in freelancer.com and for the reviews
$20 USD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello, I will create a custom Google Sheets script for you to actively monitor and identify additions and deletions in two cells with array data. My script ensures efficient tracking without unnecessary functionalities. Let's streamline your data management.
$20 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I am writing to propose a solution for your need to continually monitor and identify differences in arrays within a Google Sheets environment. With my expertise in Google Sheets scripting and array management, I aim to develop a custom script that efficiently tracks additions and deletions in two arrays located in different cells of a Google Sheet. Project Understanding You are required to compare two cells in Google Sheets: Cell 1 containing multiple SKUs (e.g., XF11088, XF11088, VS11088, VS11088) and Cell 2 importing scan data from Google AppSheet (e.g., VS11088). The objective is to identify which SKUs in Cell 1 are not present in Cell 2, indicating additions or deletions. This comparison needs to be automated and executed at regular intervals, specifically every hour.
$30 USD w 5 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Cheyenne, United States
5,0
4
Zweryfikowana metoda płatności
Członek od lut 15, 2020

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.