title: Excel - working with text across multiple worksheets
body: <p>I have an excel file that uses multiple worksheets to summarize payments and the payment schedule for multiple properties.</p>
  
  <p>It's set up so that the first sheet is a summary of everything, with subsequent sheets detailing different properties. I have a column (just for descriptions) that I want to bring back the text to the first sheet, and if there are multiple entries on subsequent sheets for it to let me know.</p>
  
  <p>I know excel doesn't like working with text across multiple worksheets so this code below worked well to bring out a single entry for me. It will always be in the same cell on subsequent sheets.</p>
  
  <pre><code>=IF(COUNTA(Sheet1:Sheet5!D15)=0,"", IF(COUNTA(Sheet1:Sheet5!D15)=1, (Sheet1!D15&amp;Sheet2!D15&amp;Sheet3!D15&amp;Sheet4!D15&amp;Sheet5!D15), "--&gt; Multiple Entries"))
  </code></pre>
  
  <p>However I've come across a situation where I do need to put two identical entries in subsequent sheets. </p>
  
  <p>For an example using | as a sheet break</p>
  
  <p>"" | "Paid #1" | "" | "" </p>
  
  <p>"Paid #1" | "Paid #1" | "" | ""</p>
  
  <p>"" | "Paid #2" | "Paid #1" | "" </p>
  
  <p>Case #2 is the odd one where its ok to have multiple identical entries but #3 where they are different needs to be highlighted, as I have it now (--> Multiple Entries) is enough. Right now both cases would be highlighted.</p>
  
  <p>I don't know where to start really, I can't find a 3d reference (something along the lines of match) that handles text, any suggestions?</p>
  
  <p>As always, thanks in advance, I really appreciate all the help.</p>