Excel remove duplicates keep first instancepráce

pasar informacion a excel. pasar informacion a excel

Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.

...application, Working People. Video Objective: Introduce "Working People" as a useful tool for managers to easily and efficiently track employees' work on various projects and activities, work hours, vacations, and salaries. Showcase how the app helps generate clear reports and facilitates decision-making in personnel management. What the Video Should Look Like: Are you a manager struggling to keep track of employee work hours, vacations, and salaries? Don't worry! Introducing Working People, an easy-to-use app that simplifies employee management. In the video, you will see a frustrated manager facing challenges in managing employee work hours and ongoing projects. But fear not, Working People is here to help! Witness how the app effortlessly records ongoing...

On my multistore: I have linked 7 multistores. TASK1: -On , I want to remove two types of material options from the dropdown list: "Transparent sticker (only for white wall)” “White sticker (for colorfull wall)" TASK 2: Add to the Material “Restick, white sticker” —> “Restick, white sticker (can be used several times)” Here is the translation of "(can be used several times)” in all languages: SK: (možno použiť viackrát) CZ: (ize použít několikrát) DE: (kann mehrmals verwendet werden) FR: (réutilisable plusieurs fois) PL: (może być używany wielokrotnie) These changes should appear permanently on all website (, , , , , , )

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

...Here’s a list of the tables from the database of the live site, I think we need them, but please feel free to migrate anything else if we need it to have all the data required from the live site. Another thing, it’s good to prepare a whole plan of the migration process, because when you want to start, we need to put the live site on maintenance mode until migration is done, and we don’t want to keep it long under maintenance for the client u know… Tables from database that required to be migrated. wp_learndash_pro_quiz_category wp_learndash_pro_quiz_form wp_learndash_pro_quiz_lock wp_learndash_pro_quiz_master wp_learndash_pro_quiz_prerequisite wp_learndash_pro_quiz_question wp_learndash_pro_quiz_statistic wp_learndash_pro_quiz_statistic_ref wp_learndash...

Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.

For planned family beach resort I need new website. Expected design and scope as (I wil...menus, each page type in one working example) then I will fill in the content myself, I will clone the pages myself to publish more rooms, more articles, etc. Content - I will transfer from my old website - all content from here must be available in new design and I need to add room booking based on WooCommerce as available in the Theme. I am not in hurry, but I need to keep the cost low and good final quality. So, pls review my above requirements and verify your bid. Pro pripravovany projekt maleho pensionu jsem zvolil WP theme Bellevue Hotel, ktery koupim. Poptavam pomoc pri nastaveni, instalaci a pripadnych drobnych upravach.

Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.

Poptáváme: Instalaci nové instance, nebo použít naší stávající instance, základní konfigurace instance, pokud bude třeba. Pro ukládání konfigurací a parametrů (endpointy…) bychom rádi využili instanci MS SQL Serveru Výběr - instalace dalších podpůrných modulů a nástrojů (např. ) WSO2 VSCode extension pro Visual Studio – preferované WSO2 Integration Studio Další nástroje… Výstupem by měl být podrobný popis kroků pro instalaci a základní nastavení všech používaných produktů. Pomoc s integrací již běžíc&i...

datae

datae

mise en forme

Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket

Napraviti Excel VBA program

hiii hw r u ....................................................................................................................................................................

...odpovědi se mu zpráva pošle do přijatých a zároveň odešle emailem notifikace o nové zprávě na portálu. V případě že uživatel odpoví, zpráva se zobrazí pod danou komunikací, čím se zachová i komunikační historie. 1.5 Live podpora tento modul bude fungovat na stejné bázi jako zprávy s rozdílem, že se bude chatovat online a v jiném grafickém rozhraní. Po ukončení live instance, se celá komunikace pod daným číslem instance nebo identifikátorem uloží opět v položce zprávy. – Popř. využijeme 1.6 - Struktura webu, umožní vytváření edi...

...BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designin...

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

...Candidate: - Proven experience in logistics and shipping, particularly with air freight. - A strong network in the logistics industry to secure competitive air-shipping rates. - Prior experience in handling electronics and clothes, with a clear understanding of the fragility of such goods. - Familiarity with customs regulations in the GCC countries listed above. - Excellent communication skills to keep me updated on the progress of the shipments. Best regards,...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

A high resolution interior design (e.g using Vray) of our living room. We like natural materials. We will keep the fireplace with black belgian hardstone. We will also keep the same wooden floor. We also plan to keep the large main eating table with the red lamps, but optionally would be open to different lamp colors there. We likely also would like to keep the one dark grey wall on which the TV is positioned as it was recently painted. If possible a Fen Shui aligned design. The windows in the picture are facing west. We are especially looking for design ideas for a new couch, accessories, living room table and lamp. As well as suggestions for where to place plants. Also where to best place the paintings of our 3 children.

I'm looking for a skilled photo editor who can completely remove sun rays from an outdoor photo featuring a motorcycle and a person. Your expertise in professional photo editing and manipulation will be crucial to achieving a flawless end result. Here are my requirements: - Complete removal of sun rays from the image. - Retain the overall quality and integrity of the image while executing the task. - Experience working with outdoor photography and dealing with lighting elements. - Excellent attention to detail to ensure a natural look after removal. - The ability to work efficiently to deliver the project within the agreed timeframes.

I'm seeking a seasoned Google AdWords specialist to help increase the traffic to my e-commerce website. Key Points: - I'm looking to drive more visitors to my site, helping to establish a broader online presence. - I am open to a strategy that will increase both quality...boost conversions. Skills & Experience: - Strong expertise in Google AdWords and PPC campaigns with a proven track record of success. - Prior experience working with e-commerce businesses is a big plus. - Excellent knowledge of driving website traffic and understanding of e-commerce dynamics. - A creative and analytical approach to optimizing AdWords campaigns. - Strong communication skills to keep me informed about the progress and results. Please share your relevant experience and approach to t...

I'm looking for a qualified Android developer who can modify an existing apk for me. I need some specific modifications to be made. Requirements: - Remove license code request. - Disable external server connection to - Make sure the "REPLACE" button continues to work as intended. The purpose of the "REPLACE" button in this apk is to inject pre-recorded video into the native Android camera or stream transmitted via obs from the pc into the native Android camera. This is a crucial functionality of the apk that needs to be maintained and work perfectly after modifications. Ideal Skills and Experience: - Proficient in Android application development. - Experience in modifying existing apks. - Familiarity with video injection into an Android camera.

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...

Beginner level freealancer...a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet ...

...products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is sufficient More agentes are necessary. ADMINISTRATOR PAGE: The administrator can add, edit or remove an agent. Just Name, Surname, phone, emai...

...database), or Replace database on web (delete database on web and reupload from Access). Administrator must be able to import from Excel files into MS Access database (voters). When importing from excel to MS Access database (locally) then ms access database must be updated with the following rules: 1. When a record doesn’t exist in Access, but exist in Excel, create it 2. When a record exist in Excel and Access (based on field: EL_NO, UPDATED ALL FIELDS FROM EXCEL AND OVERWRITE ACCESS FIELDS except THOSE FIELDS IN Access starting with FINAL_ and user data entries. 3. In excel files there it is possible to exist duplicate entries (based on field EL_NO). In that case remove duplicated and leave the record which has a value (<>N...

...data acquisition in real time at 1000 samples per second in 24 bit precision 2. Raw data signal bandwidth /frequencies restricted to less then 1000 hz by hardware RC anti aliasing filter to avoid aliasing 3. Following Digital in sequence to be applied to raw signal . a. low pass filter 0-170 hzs ( to remove high frequency random / white noise b. High pass filter 1 hz to 400 hz (to remove low frequency dur DC signal coupling ) c. Very steep(narrow band) notch filter at 50 hz / 60 hz to remove power line interference a & b can be combined as band pass filter if possible also a , b & c can also be combines a single filter algorithm to obtain desired frequency response frequency response of all three signal enclosed 4. A 32 bit ARM processor of -...

Creating thumbnails and banners for Google Chrome Extension Thumbnail 440*280 The main task when drawing this banner is to force users to pay attention to your extension. ...logo and name: “Time Zone Meeting Planner. - Size: 440*280 - Format: png Big banner (screenshot) 1280*800 A simplified screenshot of the extension conveying the essence of the product, and not necessarily all the functionality of the product. - Use a screenshot, remove all secondary elements (settings, offset, etc) - Draw a mouse and its movement while selecting time - Use text: “Find the best meeting time across time zones.” - Size: 1280x800 - Format: png Big banner (screenshot) 1280*800 Same instructions as for the first one but demonstrate searching the time zone. Use text:...

I'm seeking a reliable, friendly companion to keep me company on a daily basis while my husband is away on a work trip from July 18th 2024 - July 26th 2024. The arrangement is for 24-hour hangout sessions. Key Tasks: - Help me care for my animals (I have 8 cats, 2 dogs and a ferret) such as: feeding, walking, cleaning litter boxes. - Engage in home-based activities: I allow smoking in my garage and I have an Xbox and a PS5. Listening ti music and watching anime is a plus! - I currently do not have a license so helping me run errands would also be appreciated. - Be present and supportive: While this is not a traditional job, I value good company and would appreciate someone who can be a positive presence in my daily routine. Ideal Candidate: - Friendly and engaging personality...

...will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

...need to scale it down to a single instance. - Compute resources: The reduction should align proportionately with the decrease in application instances. This is an IBM Maximo Application Suite installation that was done with an AWS Marketplace Template "IBM Maximo Application Suite (BYOL)". The template built all the instances (9 including 3 masters, 3 workers, and 3 workers (using m5.2Xlarge and m5.4xlarge) along with a boot node and bastion host) and the volumes (26 of them with 6.23 TB of storage being used) and it is way overkill for just using as a sandbox to learn in and educate. They had no other Template option when installing. Ideal Skills & Experience: - Expertise in handling the Red Hat OpenShift environment - Strong knowledge of AWS and instance ...

Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.

...sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If you have the...

...elements (React) most of the work is for adding functionality and back-end. Key Features (I have API from CoinStats for these): - Real-time Price Updates: The dashboard should provide real-time updates on the prices of various cryptocurrencies. - Portfolio Balance Overview: I need to have a clear overview of my overall portfolio balance. - Transaction History Tracking: This feature will allow me to keep track of all my transactions in the crypto market. Additional Pages: - Indicator Tracking: An essential feature that should provide insights into various indicators for informed decision-making. - Project Launch Tracking: I want a dedicated page for tracking upcoming crypto projects that are yet to be launched. I will add the projects manually. - Watchlists: The dashboard sho...

I'm looking for a talented designer to create a minimalistic logo for my media company, GG Media. I'd like the design to embody simplicity, while still being memorable and unique. The logo will exclusively feature the company name, "GG Media". Attached is the current logo I want to keep the same font of the G's or very similar and somehow join them cleverly. The company is video and photo production. In terms of colors, I'm looking for a black and white palette. This choice is intentional, as I believe it will give the logo a modern and sophisticated aesthetic. The ideal candidate will have a proven track record of creating minimalistic, yet impactful logos. Experience in the media industry is a plus, but not a requirement. Skills needed: - Logo...

Hi Saira Arif M., as discussed this involves configuring Nginx on an AWS EC2 instance to properly serve a frontend React app under a custom domain while addressing SSL issues. Nginx configuration files need to be set up to ensure seamless access to the React site via the specified domain, resolving any SSL-related issues to ensure secure connections. my price is 10$ and I have one conditions: If you are happy we can do it right now

...be implemented - Redesigning the logo: A logo redesign to reflect the updated color scheme and font Content Updates: - Updating text: The text content on the website needs to be refreshed to be more compelling, accurate and engaging - Adding new images: Incorporating new images to add visual appeal and relevance to the content - Removing outdated information: Clearing out obsolete information to keep the website current and relevant Functionality Improvements: - Edit Wordpress Astra Pro essentials Theme: Enhance the theme and improve its YOAST SEO - Layout Enhancement: Refine the layout of the website to be more user-friendly and visually appealing - Pages & Features: I have a specific set of pages (6), a video, a contact page featuring a map, and an enquiry as well as ema...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new

I'm in need of a skilled professional to design and create an engaging website targeting children. The primary focus of the website should be interactive games to keep the young audience entertained and interested. Key Requirements: - Creating a visually appealing and user-friendly website specifically for children. - Incorporating interactive games that are both fun and educational. Ideal Skills and Experience: - Proficient in web design and development, particularly for children's websites. - Experience in creating interactive games within a web environment is highly desirable. - A good understanding of child-friendly design principles and user experience.

I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advantageous. ...

Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.

I'm looking to develop a user incentive-based Android app that rewards users for their engagement. The primary objective is to keep users engaged with the app and reward them for their time and effort. Key Features: - The app should allow users to earn money through completing simple surveys, watching ads, and trying new applications. - Users should be able to redeem their rewards in the form of gift cards. - The design should be simple and user-friendly, ensuring a seamless experience for the users. Skills and Experience: - Proven experience in Android app development, with a strong portfolio of successful apps. - Knowledge of integrating payment systems and managing user rewards in mobile applications. - Design skills that focus on user experience and engagement. - P...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

I'm in need of an experienced video editor for a project that involves creating entertainment content. Key Requirements: - Advanced video editing skills: You must be capable...content, maintaining viewer engagement throughout. - Sound editing: The ability to enhance audio quality and mix sound effectively. - Advanced color grading: Your capacity to bring out the mood of the content through color is crucial. - Special effects: While not the primary focus, the ability to incorporate special effects where necessary is a plus. This project will require a creative touch to keep viewers engaged throughout the video. The final product is expected to be more than 5 minutes, so experience in long-form video editing is highly preferred. Please share examples of your previous work in ...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation