I have a workbook with a lot of data. Column A lists Date and Time. I would like to separate this into two separate columns. The report has one row for each minute. I would like to learn how to filter out rows with time increments (e.g. every 15 minutes) in order to reduce the amount of data. Then I would like to learn how to automate the data review so numbers above a certain value highlight with red shading.
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement.
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project
Proposed Milestones
$100 USD - payment once project delivered
Hi,
I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat.
-Chandra
Relevant Skills and Experience
Excel vba, formulas, conditional formatting
Proposed Milestones
$50 USD - Milestone
I would like to discuss the project requirements to get the scope of the work.
I've read your brief and can see that you'd like to have an Excel spreadsheet.
Relevant Skills and Experience
I have 7 years experience in designing and developing Excel spreadsheets filled with formulas and VBA code.
Proposed Milestones
$60 USD - Deliver final and fully functional version
When can we chat or talk? I am online from 3 to 11 pm (GMT 3).
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Stay tuned, I'm still working on this proposal.
I am ready to do the workbook with Column A into two separate columns. We promise you 100% quality within the time limits
Relevant Skills and Experience
EXCEL
Proposed Milestones
$55 USD - Quality work
separating date and time isn't matter, its just one min work
for data viewing, we can use filters
for color sharing, we've to apply conditional formatting
Relevant Skills and Experience
which version of Excel? you are using?
please discuss, i can guide you
i am looking your response
thanks
Proposed Milestones
$70 USD - for desired things
Sir, I am from vSol CORP. We are a team of 19 people. I have checked your project requirement, we are professional with spreadsheet.
Relevant Skills and Experience
We have worked on several similar projects, but for client privacy reason I am not disclosing here. Still, we can discuss it. For a quick preview, you can check our feedback section.
Proposed Milestones
$80 USD - We are flexible to adjust as require by you.
We do provide a non-paid trial. Can we chat here? Please reply me when you will be available. Thanks
Excel Expert
Relevant Skills and Experience
I have taken a look at the sheet and i can do and show you what you are asking for.
Proposed Milestones
$30 USD - Complete
Relevant Skills and Experience
18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 MONTHS , spent at least 225 HOURS on automation in Excel every month.
Proposed Milestones
$80 USD - Macro to separate data in column, filter per defined time increment, conditional formatting
Similarly, for conditional formatting the limit can be provided as a variable for highlighting.
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, and output in Excel using VBA.
Relevant Skills and Experience
I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please contact me to discuss the details.
Proposed Milestones
$60 USD - Excel formulas and VBA code
I own a small business registered in Illinois. You could pay me as a freelancer or a business.
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Documen
Relevant Skills and Experience
Excel
Proposed Milestones
$77 USD - k
Column A (Date - Time). Teach you how to filter out rows with time increments and how to apply conditional formatting (highlight numbers above a certain value). Duration: 1 day
Relevant Skills and Experience
I have 16 years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with any Excel project.
Proposed Milestones
$60 USD - Default milestone
separate data in tow columns and highlight value above certain numbers
Relevant Skills and Experience
Excel/VBA
Proposed Milestones
$150 USD - Completed excel
Hello, I Have more than 14 years of exp. Completed 320+ projects. Look at my feedback. Thanks.
Greetings for the day!!
We have experience working on this subject.
We ensure 100% QUALITY with ON-TIME Deliveries.
Please allow us to take this opportunity.
Thanks & Regards,
Team@The24CarrotsInc
Relevant Skills and Experience
VBA,EXCEL
Proposed Milestones
$80 USD - 100% Satisfaction Of Deliverables
Hello!
I am an experienced freelancer interested in working on your project.
I am experienced with Excel and Data Entry, i would like to hear more about this job from you.
Best regards, Mladen
Relevant Skills and Experience
excel, data entry
Proposed Milestones
$111 USD - job done
Hi
i can help with in many ways ,i suggest to implement a script to split the date and time and sort the data with a simple command
i actually splited the first column
i invite you to talk on chat
Relevant Skills and Experience
Java,python
Proposed Milestones
$55 USD - final script
Greetings
Hope you are doing well.
I am a CPA (CA/ACCA) Finalist and I provide a range of services, majorly focusing on excel, accounting, financial management, cost accounting and other allied subjects. I have been working in the above fields for 3 years now and have an extensive experience in the same.
Looking at the project description, I am quite certain that I can execute it with utmost responsibility. Being proficient with Microsoft Excel and having created several complex excel templates for a series of clients will be an added advantage.
Looking forward for your reply in order to discuss the same in details.
Regards
Jitin Goyal
The date & time can be seperated using formulas and proper formatting. A macro can be written to highlight values above a certain value.
Relevant Skills and Experience
Excel VBA
Proposed Milestones
$30 USD - Entire Task
I presume you are looking for a macro to do the task?
Dear Sir
I am an excel professional having hands on expertise in data analysis and management I will do your project as per your requirements by applying conditional formatting and sorting.
Best regards
Humayoon