Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transposing Multiple Cell References to Multiple Values (NOT total
Hi Everyone
Sometimes it is useful for me to show that a cell contains a string of numbers which make up a total. For instance, I would show in a Cell that the total you see ($1000) is made up of $700 + $300 Sometimes, those individual amounts come from different sources / links. So, (as an example) H11 ($700) plus G20 ($300) = $1000 In the cell it shows = H11 + G20 Is there any function which will transpose those cell references to the amounts they represent WITHOUT summing them in the cell? IE I would like to get = H11 + G20 to show = 700 + 300 NOT =1000 Does anyone have any ideas? This kind of thing is very useful for reconciliations etc. thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transposing Multiple Cell references as Multiple Values | Excel Discussion (Misc queries) | |||
show multiple values that add to total in bar graph | Charts and Charting in Excel | |||
total value relating to cell values in multiple columns! | Excel Discussion (Misc queries) | |||
How do I put multiple references in the same cell? | Excel Worksheet Functions | |||
multiple cell references | Links and Linking in Excel |