Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide Use column headings - Indirect?
*** similar to my previous query, but different!****
Howdie! so situation is Several Tabs (similar contents but different names) and a consolidated Tab. Within the Consolidated tab Cols A to Z each have a unique header (these are the names of other tabs in the same book) say Col A = Cat, Col B = Dog etc (ie we thus have a sheets entitled Cat, dog, etc...) In the consolidated tab I want to put a formulae In column A that performs the following calC: From (Tab entitled Cat) , add cell a1 and cell c3 and then divide by b3. Now I could just say =(Cat!a1+:Cat!a1c3)/Cat!b3, but then I would manually have to change cat to dog for each of my columns. I Any ideas??? Regards D *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
How do I divide a column into two? | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |