Prev: XMAS
Next: Excel 2007 AutoSaves
From: msnyc07 on 25 Dec 2009 19:28
Hi thanks for that, I think you might have misunderstood the challenge, my
fault if so.

I don't need a count it is just that a nested table was presented in a
clumsy way i.e.

Level 3 | Level 2 | Level 1

which led to lots of duplication since I just wanted
Level 1
Level 2
Level 3

All I did was this

Fruit | Citrus | Orange
Fruit | Citrus | Lemon
Meat | Beef | Filet
Meat | Beef | Pork
Vegetable | Green | Broccoli
Vegetable | Green | Lettuce
Vegetable | Orange | Carrot

and copy partial columns down and then got rid of dupes!

Thanks though!

Merry Christmas!


"Max" wrote:

> Best thing to give you is a working example:
> http://cjoint.com/?mAbiANHCdV
>
> Success, finally? Thump the air, hit the YES below
> --
> Max
> Singapore
> ---
> "msnyc07" wrote:
> > Hey thanks for all that. I did paste in and nothing happened, tried typing by
> > hand and get a "Formula contains an error" though :(
>
From: Max on 26 Dec 2009 05:40
Aha, thought I did read your original posting ok, and you did give a
depiction of the desired results. But maybe you changed your mind somewhere
along the way. cheers
--
Max
Singapore
---
"msnyc07" wrote:
> Hi thanks for that, I think you might have misunderstood the challenge, my
> fault if so.
>
> I don't need a count it is just that a nested table was presented in a
> clumsy way i.e.
>
> Level 3 | Level 2 | Level 1
>
> which led to lots of duplication since I just wanted
> Level 1
> Level 2
> Level 3
>
> All I did was this
>
> Fruit | Citrus | Orange
> Fruit | Citrus | Lemon
> Meat | Beef | Filet
> Meat | Beef | Pork
> Vegetable | Green | Broccoli
> Vegetable | Green | Lettuce
> Vegetable | Orange | Carrot
>
> and copy partial columns down and then got rid of dupes!
>
> Thanks though!
>
> Merry Christmas!

First  |  Prev  | 
Pages: 1 2
Prev: XMAS
Next: Excel 2007 AutoSaves