=AND($A1<>",$A1<>$A2)

  • Thread starter Thread starter Guest
  • Start date Start date
Hi
probably a small typo. Should read
=AND($A1<>"",$A1<>$A2)

checks that A1 is not empty and is not equal to the next cell in A2
 
It is saying

test for A1 not containing no data, and also if A1 not equals the value
below. If both conditions are met it returns TRUE, if one or both is not met
it returns FALSE. These can be used in conditional formatting to determine
whether the format is set or not.

This was used in your case to find the last item is a series of like items,
to highlight them.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
a1 = sum(a1;a2) 2
Evaluate "nested-merge" function? 3
Function =DIAS.LAB(A1;A2) 3
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Excel =SUM(A1=A1+B1) 0
formula for excel sheet. 4
Vlookup and return sheet name also 2

Back
Top