<div>
Or simply this....<br />
In D2<br />

<pre><code id="code-20-41831106-1">=MAX(C2:C3)</code></pre>
</div>


<div>
You're welcome Robb! Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
I have a very large spreadsheet with data that looks like the following: The underline here just means that column is blank.<br />
So this is the structure. &nbsp;Its always 2 rows per grouping to look at. &nbsp;If my formula was working it would do the following to the text below.<br />
there is no patterns with the numbers. &nbsp;only that it needs to be moved to the right one column and also up and right on the previous row.<br />
This pattern goes on for about 500+ rows.<br />
<br />
BEFORE::<br />
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22208 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ROOT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_______<br />
21191 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22210 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19505 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_______<br />
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22212 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ROOT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_______<br />
21192 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22214 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19506 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;_______<br />
<br />
AFTER:<br />
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22208 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ROOT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19505 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
21191 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22210 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19505 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19505 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22212 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ROOT &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19506 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
21192 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22214 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19506 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;19506
</div>
</div>


I have a very large spreadsheet with data that looks like the following: The underline here just means that column is blank.
So this is the structure.  Its always 2 rows per grouping to look at.  If my formula was working it would do the following to the text below.
there is no patterns with the numbers.  only that it needs to be moved to the right one column and also up and right on the previous row.
This pattern goes on for about 500+ rows.

BEFORE::
NULL	22208	ROOT	_______
21191	22210	19505	_______
NULL	22212	ROOT	_______
21192	22214	19506	_______

AFTER:
NULL	22208	ROOT	19505	
21191	22210	19505	19505	
NULL	22212	ROOT	19506	
21192	22214	19506	19506

excell formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.