hi Guys,
I have an example of a list of job that was carried out by engineers, I need to record in one line which companies they have visited on that day.
i have doen one previously that was simular, but I can't ge this one to work!!
It is supposed to be an array but when I put the array on all the data disappears!, and the data that stays is right but in the wrong order!!
IE 03/11/11 the enigneer attended 2 jobs, one of which was 'down' at BIG, but my formula brings back that the job was at DOG. But in the formula I am trying to vookup from the unique (eng/date/down) cell (in this instance B5) so the DOG is on column 5 on the raw data sheet. this is exactly the same as my other one but seems to have gone wrong somewhere!!
can anyone please look at my formula and see where I hvae gone astray!!
cheers
Donna
Bookmarks