Excel Auto filter

20.0 GBP

20.0 GBP peopleperhour Technology & Programming Overseas
3 days ago

Description

Hi All,
a) I want to paste Raw client data into tab " Raw Data" in excel
b) However I want the data automatically - when I flip over to the "Auto_Filtered_ClientData" tab to auto filter data i dont need to exclude eveything under a specific value ( in this case under 5) but to include Blanks and "-"
C) once fitlered I also need it to sort it from Largest to Smallest in the Amount column of the Auto Filtered CLient data tab
d) Any value in the amount column of "Auto_Filtered_ClientData" tab that has "-" or "#NA" this needs to be replaced with a zero "0".
e) The Settings Tab - should be able to adjust values NOT to include each time ( so this can be adjusted in the future).
I want to avoid Macro buttons , and VBA as much as possible (if at all?) - I just want to dump the raw data and then see the results populate automatically in the second tab "Auto_Filtered_ClientData"
Thanks

Go Now
关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

Greetings all, We need help finishing up a site that is using an LMS Model. We are using Wordpress with the main application being Memberpress. While also using other servers like cloudways and cloudinary. I'll give a little more depth in the description later on in the week, just trying ti draw interest for now with indviduals/team familiar with working on LMS sites. Some of the things we're looking to have done is: A pop-up after each video lesson is complete, to prompt that the class has received a musical record that plays a snippet of a track. That works like a trophy system. A music player, got a page for it but no functional player. Setting up click and play quizzes, on the quiz button on each lesson. (subject to change) Adding a button on what is already a pop-up window to play media that may be video and/or audio. That is all for now, will update with more information as soon as I can this week. Thank you and Regards, TeVon AI Suggestion: This WordPress site using Memberpress LMS requires additional features and functionality. The goal is to enhance the online learning experience for users by gamifying lessons and adding multimedia elements. Some tasks include implementing a post-video pop-up with a "musical trophy" notification as well as building out a click-and-play quiz button. Integrating a functional music player on a designated page and allowing media playback directly from existing pop-ups are also priorities. The ideal freelancer will have experience customizing Memberpress and integrating additional applications through plugins. Comfort working with APIs, media upload/embed features, and quiz/assessment tools is essential. Please provide relevant portfolio work and hourly rates through the platform messaging system.
1600.0 USD Technology & Programming peopleperhour Overseas
16 hour ago
Flutter Developer Opportunity We are seeking an experienced Flutter developer to enhance and maintain a well-established app on Android and iOS. Your expertise in Flutter, CocoaPods, and native Android/iOS integration will ensure seamless updates and stability. This role demands commitment to quality and timely delivery, even on weekends or holidays. Project Overview 1. Existing App: - Fully functional APK and IPA (Dated 20/12/2024) with features like: - Camera integration and data exchange via the method channel. - Available on Apple Store and Google Play, fully operational except for a camera communication issue on iOS (already fixed in new code you will implement). 2. Code Updates: - Bug fix for iOS method channel integrated into new code. - App features include selfie snapping and real-time data exchange, live on Play Store and App Store. 3. Environment Setup: - iOS uses CocoaPods; Android includes Swift/Kotlin native code. - Configurations are stable and require ongoing maintenance. Scope of Work Phase 1: Restore Functionality - Reinstate menus (M16a, M16s, M16l) from Git. - Fix product count display. - Save data pre-login. - Configure CocoaPods and Android components. Phase 2: Replace Firebase with SSE - Remove Firebase dependencies. - Implement Server-Sent Events (SSE) for real-time notifications. - Update and test notifications for Android and iOS. Estimated Time: 20 hours (8–9 for Phase 1; 12–13 for Phase 2). Key Requirements 1. Experience: - Flutter (3.3.8), Dart (2.18.4). - Android Gradle (7.4), Build Tools (33.0.0), Java 11. - iOS Xcode (14+), Swift (5.0), CocoaPods (1.11.0). - Replacing Firebase with SSE. 2. Technical Expertise: - Provide code snippets for: - SSE/WebSocket implementation in Flutter. - Flutter-to-native communication using Swift (iOS) and Kotlin (Android). - Proven record of native integration (CocoaPods/Swift/Kotlin). 3. Professionalism: - Punctuality and commitment to deadlines. - Clear, consistent communication. Expectations - Complete the project in 2.5 days with no regression. - Provide functional code with rigorous testing. - Penalties apply for missed deadlines or subpar work. What We Provide - Functional APK and IPA versions. - Clear instructions and supportive communication. This role demands exceptional skills, efficiency, and adherence to professional standards. The compensation is on par with European developers. If you meet the criteria and can deliver, we look forward to your application.
35.0 USD Technology & Programming peopleperhour Overseas
1 days ago
I am looking for a skilled Bubble.io developer to create a simple, one-page Profile Picture (PFP) Generator Template that businesses and communities can purchase, customize, and publish. The template will allow users to create personalized profile pictures by layering predefined assets over a base character. It should be designed to function as a template that can be easily adapted by buyers to meet their specific branding needs. Key Features: User Experience: A single-page design similar to this example: https://pinopfpgenerator.vercel.app/. Intuitive controls for users to randomize layers, clear designs, and download the final PFP as a high-resolution PNG. Template Customization: Template buyers can upload and manage their own asset images (e.g., hats, glasses, backgrounds). Asset categories can be easily renamed and grouped into sections for better organization. Simple branding options, allowing businesses to add their logo or title. Ease of Use: Fully responsive design for desktop and mobile devices. A clean, engaging interface designed to attract and retain users. Deliverables: A fully functional Bubble.io template designed for easy duplication and customization. Simple asset management options for template buyers. Clear documentation on how buyers can customize the template, including asset uploads, branding, and publishing. If you have experience building templates or tools on Bubble.io, please share your portfolio. This project aims to provide a versatile, ready-to-use product that businesses can quickly adapt and publish to engage their communities.
342.0 GBP Technology & Programming peopleperhour Overseas
14 hour ago

HuntsBot,a one-stop outsourcing task, remote job, product ideas sharing and subscription platform, which supports DingTalk, Lark, WeCom, Email and Telegram robot subscription. The platform will push outsourcing task requirements, remote work opportunities, product ideas to every subscribed user with timely, stable and reliable.

简体中文 English

Platform

Support

Links

Contact US

Any questions or suggestions during use, you can contact us in the following ways:

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.