#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
Why reinvent the wheel? If you use chrome, there some basic project management apps you can download for free.
|
#3
|
|||
|
|||
thanks but I have a file in excel that I am using right now. can anyone answer my question please?
|
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
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. |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
how can i post a sheet here? i just attach the excel file?
|
#8
|
|||
|
|||
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.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |