Hi All,
I have 3 columns of data:
"Post Category" TEXT
"Send Time" DD/MM/YYYY MM/HH/SS
"Clicks" NUMBER
What I am trying to do is see the total clicks for each post category with the "send time" of this month, ranked by clicks, there might be other metrics to add on...
I'm finding this really hard to total. See the attached $$ I hope you can help!?Grouping Name + Date + Number + Ordering.xlsx
Some of your values in column B are stored as text while others are dates. You can see this by highlighting column B, Data, Text to Columns, Delimited, Next, Next, Date (whichever format you prefer).
Spread the love, add to the Rep
"None of us are as smart as all of us."
The easiest solution would be just using pivot table for this task.
PS. Make sure that dates are real dates (in column B it seems yoyu have texts which just look like a date).
Best Regards,
Kaper
Just to show what I mean - see attached file with Pivot Table for your data.
Hi kasper,
This is what I want but I need formulas as I want something to works on the fly. Not sure why some dates are text but I used *03/2015* and that appears to work.
Any ideas?
guy,
See attached for a possible formulaic method, but I agree with Kaper that this is probably more efficient if done with PTs.
I offer this option.
In the yellow cells can choose the year and month.
This was brilliant but I was wondering if there was a way to change the formula slightly so it could read todays year and month, for example:Originally Posted by Czeslaw
=IFERROR(LOOKUP(2,1/ISERROR(MATCH(A$6:A$1482,E$5:E5,))/LEN(A$6:A$1482)/(YEAR($B$6:$B$1482)=$F$1)/(MONTH($B$6:$B$1482)=$F$2),A$6:A$1482),"")
=IFERROR(LOOKUP(2,1/ISERROR(MATCH(A$6:A$1482,E$5:E5,))/LEN(A$6:A$1482)/(YEAR(TODAY()/(MONTH(TODAY(),A$6:A$1482),"")
Please select which option you better
suitable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks