| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cells equal to another cell a certain # over
I'm sorry, I forgot the file is on manual calculate. Once I hit F9 the
formula Bryan gave me works great. I do have one probelem though. The information I want actually starts in H1. There is information in the columns in front including a row description and a total. The cells A1 through E1 are blank. I don't want this information in F1 and G1 showing up. Is there any way to disinclude them from the offset formula result? Thanks for the help thus far! Jaclyn "Fin Analyst" wrote: I tried both of these formulas suggested and the result is labeled "volatile" and not showing any numbers in the cells. Any other suggestions? "John James" wrote: The formula for, say, cell E6 is =OFFSET(E5,0,A3) -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531737 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Value of one cell a certain number of cells away from another cell | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Threaded Mode
