How to filter data in excel using formula jobs

I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure

Here is a video for Memberships. The files are here: Now we have two Clean Host clips - one I've attempted to fix the hair below his right eye with a Gausian Blur filter, the other is untouched. If you can do a better fix on this please do. I think it's a bit distracting to leave the hair there. Let me know if you have any questions.

I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to...

I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import

...improvement. - Incorporate mechanics that reward players based on their performance in surviving and progressing through the endless waves of zombie enemies. 2. Gameplay Mechanics and Features: - Implement a procedurally generated system for enemy waves to ensure each playthrough is unique and offers varying challenges. - Introduce scaling difficulty that dynamically adjusts to the player's skill level, providing a continuously engaging experience. - Include endless mode-specific features such as leaderboards, milestones, or rewards that motivate players to push their limits and strive for higher scores. - Design gameplay loops that encourage players to strategize, adapt, and optimize their tactics to survive as long as poss...

... The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website Go ...

...with NextAuth and Google: Integration with NextAuth to enable user login via Google. Secure OAuth2 authentication flow to ensure user data protection. User registration through Google account, streamlining the sign-up process. Account and Subscription Management: Each account can manage one school, which can have multiple locations (campuses). Admin dashboard to manage subscriptions and assign school management capabilities to each account. Ability to sell subscriptions, where each subscription corresponds to a single school with its own set of locations, teachers, and resources. Role-based access control: Admin Role: Full access to manage the school, including locations, teachers, classes, and schedules. Manager Role: Limited ac...

I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail ...

We aim to develop a comprehensive e-commerce platform that enables individuals and businesses to easily and flexibly create and manage their online stores. The platform will be similar to Shopify and Salla, and will be built using the Laravel framework to ensure ease of use, flexibility, and security. We are seeking a skilled freelance developer to design and develop both the frontend user interface and the backend, including a comprehensive content and transaction management system. Main Tasks: Interface Design: Develop attractive and user-friendly interfaces, including the frontend and the administrative dashboard. and Development: Build core platform functionalities using Laravel, including product management, order processing, user m...

Looking to collaborate with Antenna experts for design/build of RFID UHF 860-960 MHz Active Digital always on antenna. It will support any RFID tags of the stated frequency range and the protocol. We have identified some possible technologies below but will rely on your expertise to pick one or combination of these or another suitable one from your experience. If you know of a pre-built solution that will be ideal. This antenna will be connected to our MCU via a comm port and be fully software defined. Our objective is to accomplish a 0.3 meters x,y,z 3D planer precision location of RFID UHF passive tags at about 25 meter cone at about 8 meters height from floor. Must be RFID UHF Frequency range (roughly 860-960 MHz, supporting US, Europe, Asia spectrums) App...

IMPORTANT FOLLOW THE SHORT YOUTUBE TUTORIAL I'm looking for a skilled Unity developer to create a small terrain for me. It's essential that this terrain is made with a provided image as the heightmap. I can also provide a tutorial of what is needed to be done using the heightmap i will provide The terrain is small, I'm not looking for anything too complex at this stage. i provided a raw image in case this dont work you can make one from the png In terms of environmental features, I would like a plane as the water body as a separated object. Ideal skills and experience for the job include: - Proficient in Unity with a strong background in terrain design - Ability to work with provided images for heightmaps - Strong un...

I'm looking to develop a comprehensive psychology app that will primarily focus on connecting users with licensed therapists. The ideal candidate for this project will have a deep understanding and experience in developing mobile and web applications, particularly in the psychology or mental health sector. Key Features: - User Registration and Profile Creation: The app should allow users to create accounts and set up their profiles. - Search and Filter for Therapists: A user-friendly search functionality should be implemented to help users find therapists that meet their specific needs. The app should be designed for iOS, Android, and Web platforms, therefore the candidate should be proficient in developing for these platforms. Experi...

...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automate...

Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking...

...seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to...

I'm seeking a PHP developer to create a user-friendly web application centered around searching and filtering baby names. Key Features: - The main functionality of the web application should allow users to search for baby names. - Users should be able to filter the names based on gender. - A sort by popularity feature should also be integrated. Search Functionality: - The search functionality should be flexible and encompass both key letter and key word searches. - These search options are crucial to ensuring a comprehensive and efficient user experience. Ideal Skills and Experience: - Proficient in PHP for robust web development. - Strong experience with database management and integration for efficient search functions. - Prior work on ...

...expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calendars of team members and shows available slots to external users to make booking with our experts - Admin can sync several calendars (of team member/experts) to one calendar booking form and the form will show availability for all the hours any of the linked expert calendars show available time. • Blog section - All type of Users can read, like, share on multiple so...

...proficient in C++ to develop a simple game layered on it. Given that I have not chosen a specific genre, a puzzle, adventure, or arcade game are all possible directions for this project. I remain open to your creative suggestions, but I want to stress that it should be very begginner and easy, something as simple as a monkey collecting random bananas spawning across the screen The game has to be: - Developed in C++, so strong skills in this language are necessary. - Created using Visual Studio. Therefore, familiarity with this software is a must. - MUST know about Game Engine basics!! This is less about being hyper focused on game creating and more about understanding the building of game engines. I already have the game eng...

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these shee...

...proficient in C++ to develop a simple game layered on it. Given that I have not chosen a specific genre, a puzzle, adventure, or arcade game are all possible directions for this project. I remain open to your creative suggestions, but I want to stress that it should be very begginner and easy, something as simple as a monkey collecting random bananas spawning across the screen The game has to be: - Developed in C++, so strong skills in this language are necessary. - Created using Visual Studio. Therefore, familiarity with this software is a must. - MUST know about Game Engine basics!! This is less about being hyper focused on game creating and more about understanding the building of game engines. I already have the game eng...

...looking to build a furniture listing website using Lavarel. The core functionalities I'm aiming for include; Registration for private users -Email -Phone number Registration for furniture stores - Store name - email - Phone number - Store logo - Store location - Create a listing page that will display all furniture submitted by furniture store - Add option in back end for users to add products to the sales page and show percentage off - Add option to contact via whatsapp - Add fuction to filter products by price, location, furniture type, new or used - Add super admin user who can add products and add phone numbers. The idea for this one is that in the beginning furniture stores are unlikely to list their pr...

please do above

...knack for making informative how-to/tutorial videos or are you more interest in comparing videos? If so, we have an amazing opportunity for you to join our team and showcase your talents on our established YouTube channel. We're looking for individuals who can create engaging step-by-step tutorials for software, apps, and email marketing tools. Please note, these are not animated explainer videos; we require screen recordings. Requirements: - Proficiency in English (native speakers preferred) - Willingness to record your phone/computer screen, along with your voice - Ability to explain concepts clearly and concisely - Access to a high-quality microphone I'm looking for someone that: - That's able to work w...

I am looking to significantly revamp my home's exterior in order to increase its curb appeal. The remodel should reflect a modern rustic style. The specific changes I intend to make include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities...

I'm looking for a professional who can help me generate contact information (name, email,...email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriente...

- Person detection using yolov7tiny or yolov8tiny, but only detecting one person - Only measuring the x,y,z position of one person. Initially, the person first detects, so when another person moves into the video it should only still measure the first person. - But with a click function, it should be possible to change to a person which we want to measure the x,y,z position and output these values exactly like in the video. - Fully support implementing it on the Client's Jetson nano - It should run smoothly like in the video. So no lags or delays - If it doesn't work smoothly on Jetson Nano then we'll help the client implement it in Windows Reference video Remarks of the client: "When starting the program, it should de...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

Unity XR FINiSHED GAME just convert to Vision PRO i have already finished my car need to convert for vision pro using unity 2022.3 picture attached, just need the conversion for vision pro , i dont need you to make the game, the game already finish and working, i will give you all stuff, just need the conversion for vision pro. Starting project in $125 usd ...... need a lot of comunication a nd serious person.

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I'm in need of a lightweight CRM application for managing FTP data transfer on Windows and Mac. The app should be around 1.90 kb in size. Here's what I'm looking for: - **File Transfer Tracking**: The app needs to provide real-time updates on the progress of file transfers. It should also maintain logs of completed transfers and notify me of any failed transfers. - **Contact Management**: A key feature of the CRM should be its ability to manage contacts. I should be able to add, edit, and delete contacts. These contacts should be organized into categories or groups. Additionally, I should be able to search and filter contacts based on specific criteria. - **Activity Logging**: The app should have a feature for activity...

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and completed on time.

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: Y...

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of auto...

I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group ...

More details: What is the purpose of the feasibility study? To evaluate the economic viability of the proposed system as defined in the study objectives. Write-up of concept to be provided upon execution of NDA. To assess the environmental impact of using biogas instead of natural gas for greenhouses What is the primary source of food waste that will be used in the anaerobic digester? Produce markets and restaurants waste from urban centers What is the expected output from the anaerobic digester? Sustainable renewable Biogas

Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.

Hired already client is aware of details

I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportu...

I'm seeking an experienced WordPress developer to create a bespoke photo gallery plugin with filter features. Key Features: - A user-friendly photo gallery for intuitive navigation. - Filter functionality, enabling users to sort images by specific categories or colors. - The plugin should be able to easily integrate into any WordPress website without conflicts. Ideal Skills: - Proficiency in WordPress plugin development. - Experience with creating user-friendly interfaces. - Strong knowledge of filter function integration. Your task will be to create a visually appealing and functional photo gallery plugin. Please provide examples of previous work or similar projects you've completed.

Please Sign Up or Login to see details.

I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to...

...everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page ...

I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color ...

...everyone, I am looking for a freelancer who is able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page ...

...am in need of a skilled expert to develop and set up a computer vision program to process a batch of SD video cards. This program will undertake a couple of key tasks: - Image Classification - Object Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java...

I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Prof...

...of TikTok LIVE Turkey. We provide free support to the streamers working with us. This system will allow people who bring us publishers with their own referral links to earn commission on the earnings of the publishers. It is not a titan chain style system to be earned from what they bring. IMPORTANT NOTES This system is a completely legal system where members actually work for us and earn from us through the publishers they bring to us. You can think of it as a basic Affiliate system. It can be used through a script with a membership system, ready, useful and nice design. People who will work as a partner of our agency will be able to enter from a url such as and login or register. Since this page will be open to everyone, it will have a ...

I have a simple powerbi poject. I have a dataset in excel based on which i need a table in the dashboard. I also require a filter to filter the rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can be A, B, C or blank in those columns. user X had values A, B and blank in the columns A, B and C In this case if you filter the data using value A from the dropdown, it should show user X also if you select B. However if you select value C in the filter the user/row will not be present.

I need help with a data entry task that involves extracting data from various websites and inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as we...