trivial(?) excel macro or pivot table

Closed Posted Apr 3, 2014 Paid on delivery
Closed Paid on delivery

Macro or pivot table to process a spreadsheet that contains three columns of dates into a summary report. Basically there are three columns of timestamps. The output needs to be: for each day, what is the count of that day in each of the three columns. The data will be regenerated as needed so this macro or pivot table will be run each time with the new data. See attached example. note: we may not have powerpivot, so please use only standard commands

Excel

Project ID: #5756480

About the project

26 proposals Remote project Active May 10, 2014

26 freelancers are bidding on average $26 for this job

jaylancer43

Hello - I am an Expert Techno-Functional Analyst in lots of arenas of IT industry including Excel Macros and formulas. I am an Engineering Graduate with an MBA degree. If you see I am among the niche bidder who has More

$30 USD in 1 day
(718 Reviews)
8.5
deepbluetech

Hi, I am an Excel macro specialist and would be happy to take on your project. Please confirm and I shall deliver an Excel macro based solution meeting your requirement within a day. Regards, Arul

$50 USD in 1 day
(173 Reviews)
7.3
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$30 USD in 0 days
(326 Reviews)
7.6
Khurramz

A proposal has not yet been provided

$24 USD in 1 day
(357 Reviews)
7.4
zExcel

Hi, I'll be happy to help you with this task Please feel free to message me if you need to discuss any issues prior to award

$45 USD in 1 day
(251 Reviews)
7.6
maverick44000

Hi Keeler. I can fix your issue in 30 mins by using a VBA macro. Kindly share the sheet so I may have a look. Regards. Usman.

$40 USD in 1 day
(67 Reviews)
6.7
aarifakhtar

Hi: I can do this within few hours. Please connect with me to discuss more. Also, Please check my project reviews. I am good at Excel and macro programming.

$10 USD in 1 day
(165 Reviews)
7.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$30 USD in 1 day
(115 Reviews)
6.2
ethicalboy

Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba More

$24 USD in 1 day
(60 Reviews)
5.2
tomislav1975

I can make this very fast. I can make this very fast. I can make this very fast. I can make this very fast.

$25 USD in 1 day
(34 Reviews)
5.2
dank111

Hi, This is Dan. I have understood the job. I can do a combination of functions and macro to get the desired output. Now this output file can be set as a template which can be reuse for new datasets. Please message More

$35 USD in 2 days
(11 Reviews)
4.6
Midlander

I have "automated" the calculation already using your example using simple formulae. You can try it as a sample as soon as you message me, and have the "full unprotected version" as soon as you pay the fee into the sit More

$30 USD in 0 days
(11 Reviews)
4.5
Aan12

This is a very simple task. I will do it for the minimum price in one or two hours. I think that I go to use a formula to transform the date/hour in date date and then, make a pivot table to count them. If you are int More

$10 USD in 0 days
(17 Reviews)
4.1
excelsolution

Hi, I work extensively on excel / vba. There are two ways to create this pivot/report 1, Using macro to create a temporary table with dates (excluding time part) and the corresponding entries (say 'Create', "Ackn More

$25 USD in 0 days
(14 Reviews)
3.8
Jamesdmartin

Hi! I have everything completed. The first thing you need to do is run a set of equations that clean up the timestamp data. The Pivot Table will see each date and timestamp as individual fields because each one is More

$35 USD in 0 days
(4 Reviews)
3.4
seanmdale

Use =SUMPRODUCT((ROUNDDOWN((Source!$A$2:$A$18),0)=VALUE(TEXT(B$1,"0")))*1) in cell B2 on the Report tab. This formulae gives you the result, I can automate this with a macro to provide a distinct list of dates in the r More

$15 USD in 0 days
(5 Reviews)
3.0
raviprashanth83

On seeing your request for the Excel project, I fully understand the project needs, and also I feel its a nice one to start with. Based on my skill sets, I am fully capable of doing it, with promised lead time. I w More

$10 USD in 1 day
(3 Reviews)
1.9
loveoyinlola

Hello Sir/Ma, I have excellent skills in data entry and processing, I believe my skill is perfect to get your job done in a short time. Thank you

$25 USD in 1 day
(4 Reviews)
1.0
umeyster

Good day, I've done some spreadsheets like the one you're hiring for. I hope we can get in touch ASAP.

$25 USD in 3 days
(0 Reviews)
0.0
nerellasrinivasa

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0