Ask Your Question

Pivot Table + Array + Transpose or dont know what? HELP! [closed]

asked 2012-09-02 00:13:01 +0200

grn gravatar image

updated 2015-10-21 02:23:00 +0200

Alex Kemp gravatar image

Hello friends,

Thanks for helping so far. Have tried lots of things, but could not come up with a solution. May be someone out there can help.

I want a data to be tabulated from:

TC    Char
02:53 host
02:56 neil
03:05 rick
04:02 slim
06:01 host
07:15 neil
10:02 neil


Char Count TC
host   2   02:53 06:01
neil   3   02:56 07:15 10:02
rick   1   03:05
slim   1   04:02

Any clues? There is lots and lots of data. Need a completely automated solution.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 01:57:20.835052

1 Answer

Sort by » oldest newest most voted

answered 2013-01-31 02:46:17 +0200

m.a.riosv gravatar image

Hi grn,

find attached a sample file, using a Pivot Table to get the unique values and Array formulas to get the hours for every value.

edit flag offensive delete link more


HI Mario,

Although your sample has the solution, I was unable to apply it to my data. I tried copy-pasting the formula as you mentioned. I know I am missing something here. I do not understand most of the functions and the concept of relative and absolute reference, which you have used in your formula.

If it is possible to guide more elaborately, it will be really helpful.

Alternatively, is it possible to achieve this in Base?

grn gravatar imagegrn ( 2013-08-11 12:25:02 +0200 )edit

Hi gm, do you get the Pivot table working? Have you enter the formula with Ctrl+Enter no only Enter?

m.a.riosv gravatar imagem.a.riosv ( 2013-08-11 14:46:01 +0200 )edit

Question Tools


Asked: 2012-09-02 00:13:01 +0200

Seen: 456 times

Last updated: Jan 31 '13