Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute & relative references
I am trying to copy an if function. =IF($C$4='April 09'!$B38,"HIT","HOLD").
I want column B to be ablsolute and the row to be relative. However, I am trying copy and display the results across columns (instead of rows) on a different sheet. When I copy the formula down it works perfectly....when I try to go across, it gets compared to Cell B38. Make sense? Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute & relative references
copy your function down the column as far as you want to go. Select the
cells you just dragged down and select "Copy" Go to the leftmost of you rdestination cells, right click and select "Paste Special". There is a check box at the bottom of the Paste Special dialog that says "Transpose". Check that box and it will copy across instead of down. -- HTH JonR "zzulu4" wrote: I am trying to copy an if function. =IF($C$4='April 09'!$B38,"HIT","HOLD"). I want column B to be ablsolute and the row to be relative. However, I am trying copy and display the results across columns (instead of rows) on a different sheet. When I copy the formula down it works perfectly....when I try to go across, it gets compared to Cell B38. Make sense? Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute & relative references
Perfect! Thank You!
"zzulu4" wrote: I am trying to copy an if function. =IF($C$4='April 09'!$B38,"HIT","HOLD"). I want column B to be ablsolute and the row to be relative. However, I am trying copy and display the results across columns (instead of rows) on a different sheet. When I copy the formula down it works perfectly....when I try to go across, it gets compared to Cell B38. Make sense? Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Absolute and Relative Cell References | Excel Discussion (Misc queries) | |||
Something other than Absolute, Relative or Mixed references | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Relative, absolute & mixed references in many cells | Excel Worksheet Functions | |||
how to switch between relative and absolute references | New Users to Excel |