Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2014, 12:03 PM
ketanco ketanco is offline finding referring cells Windows 7 64bit finding referring cells Office 2007
Expert
finding referring cells
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default finding referring cells


I am not sure if this can be done in excel but lets see...

Assume the following in a 3 column table:

Cell A1: Concrete
Cell A2: Excavation
Cell A3: Footings
Cell A4: Formwork

...

A10: Steel Column
A11: Wood Frame


Cell B10: =a1 & ", " & a2 & ", " & a3 (which displays Concrete, Excavation, Footings)
Cell B11 =a1 & ", " & a3 & ", " & a4 (which displays Concrete, Footings, Formwork)


Here is my question...

Can cell C1 scan the contents of a range of cells in column B, which has similar formulas, and display a cell's content from column A, which used A1 in its formula? (if cell B10 used A1, then C1 should display content of A10. If also B11 used A1, then C1 should also display content of A11 and so on... so in this case, C1 will display "Steel Column, Wood Frame")

(think of this as a simple schedule program, where column A has activity names, B has predecessors, and C has successors. I want C (successor) to display automatically which other activities mentioned that particular row as a predecessor)
Reply With Quote
  #2  
Old 04-24-2014, 12:50 PM
gebobs gebobs is offline finding referring cells Windows 7 64bit finding referring cells Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Why reinvent the wheel? If you use chrome, there some basic project management apps you can download for free.
Reply With Quote
  #3  
Old 04-24-2014, 01:09 PM
ketanco ketanco is offline finding referring cells Windows 7 64bit finding referring cells Office 2007
Expert
finding referring cells
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

thanks but I have a file in excel that I am using right now. can anyone answer my question please?
Reply With Quote
  #4  
Old 04-25-2014, 12:55 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline finding referring cells Windows 7 64bit finding referring cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet ( no pics) showing BEFORE and AFTER - tHX
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 04-25-2014, 12:27 PM
ketanco ketanco is offline finding referring cells Windows 7 64bit finding referring cells Office 2007
Expert
finding referring cells
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

ok for example:

----------A(activities)--------B(predecessors)-------------C(successors)
1-----excavation--------------------------------------formwork, rebar
2------formwork---------------excavation--------------rebar, columns
3--------rebar-----------------formwork, excavation-----------columns
4-------columns------------rebar,formwork------------------

the contents of column A are manually entered.
For column B, cells have formulas like a1 & ", " & a2 & ", " & a3... as much terms from column A as needed, and they display the text there as you see.

The question is for column C. I am asking the formula to write in C. The text should display like I wrote as a result. What it must do is, for any row, say row2, it must scan column B, and, for each row in column B that mentioned the cell A1, the formula in C1 must include the corresponding cells from A.

So in this case, for row 2, C2 looks at column B. and sees that A2 was mentioned in B3 and B4. So, it writes A3 and A4 in its formula.

So in other words, whatever activities mentiones an activity as a predecessor, that predecessor activity must mention those activities as its successor automatically.
Reply With Quote
  #6  
Old 04-26-2014, 12:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline finding referring cells Windows 7 64bit finding referring cells Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sheet as asked - Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #7  
Old 04-29-2014, 12:17 PM
ketanco ketanco is offline finding referring cells Windows 7 64bit finding referring cells Office 2007
Expert
finding referring cells
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

how can i post a sheet here? i just attach the excel file?
Reply With Quote
  #8  
Old 04-30-2014, 07:46 AM
gebobs gebobs is offline finding referring cells Windows 7 64bit finding referring cells Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Yes. In the toolbar above where you type your reply, there is a paperclip icon. Click it to open the Manage Attachments dialog. Or you will find Additional Options below with a Manage Attachments button that will open the same dialog.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
finding referring cells Finding and filtering on a group of cells gundas Excel Programming 1 04-16-2013 03:52 AM
Formulas in many Sheets referring to corresponding column in one sheet ue418 Excel 0 07-11-2012 02:04 AM
finding referring cells How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
finding more the one gsrikanth Excel 0 05-14-2012 03:25 AM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft