Hi All,
I have attached a workbook to help.
I would like to present the data from Sheet 1 on Sheet 2 in a slightly different way.
I want to show, on Sheet 2, all of the projects in Phase A, Phase B, Phase C. So all of the projects in Phase A will be listed in Column A etc.
I'm sure this should be too hard?!
Thanks all for your help today!
dvent
Last edited by dvent; 11-05-2008 at 03:13 PM.
Using your posted workbook....on Sheet2...
Copy that formula down and across through E10.
Please Login or Register to view this content.
These are the results:
Is that something you can work with?Please Login or Register to view this content.
Last edited by Ron Coderre; 11-05-2008 at 12:38 PM.
Thanks Ron
I have tried to copy into my real spreadsheet without luck.
Can you simply explain which bits I need to change and what to look out for?
What is happening is that Column A is working but Column B - F seem to be pulling incorrect info.
Thanks
dvent
I attached an edited version of your workbook that contains the formula I posted.
Does that help?
Thats as I thought. The only thing that changes from Column A to B is the A or B i.e.
.......*"&A$2
.......*"&B$2
When I have put into my new workbook I have the following 2 formulas:
Column A:
Column B:Please Login or Register to view this content.
RESULTS_RR!$AO$3:$AO$40 is where my CURRENT PHASE column is.Please Login or Register to view this content.
B$2 is where my PHASE TITLE is to look up.
RESULTS_RR!$A$3:$A$40 is where my PROJECT NAME column is.
...?
dvent
After adjusting references, I found the flaw in your formula....
SoPlease Login or Register to view this content.
Copy that formula across and down.Please Login or Register to view this content.
Done, yet?
Brilliant! Thanks ron!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks