| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i create a formula for selected range?
I have a spreadsheet that contain data by category. Example:
Foundation ----------- cost 1 -----------cost 2 Foundation - guy 1 ---- $100 ---------- $150 Foundation - guy 2 ---- $120 ---------- $160 -- X Foundation - guy 3 --- $130 ---------- $190 If I put an "X" or maybe "highlight" on column Foundation - guy2 for example, I would like to populate his information to a different sheet. Do you know how to go about it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| specify range name in formula with concatenated string | Excel Worksheet Functions | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Threaded Mode
