Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Reference to another cell-value not in same row?

2 replies [Last post]
Thu, 2010-04-22 03:51
Bo Johnsen
User offline. Last seen 8 years 7 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
Is there any way to make references to another cell-value (same data type) when using customized formulas - and not using VBA - if that cell is:
1)not in the same row, but in the same column, e.g. 5 rows above
2)not in the same row and not in the same column, e.g. 5 rows above and 2 columns to the left.

This is easy handled in Excel, but what about MS Project?

Best regards,

Bo
Top

Replies

Fri, 2010-04-23 02:25
#1
Bo Johnsen
User offline. Last seen 8 years 7 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
thanks
Top
Thu, 2010-04-22 19:42
#2
Trevor Rabey
User offline. Last seen 1 year 21 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
no.
Top