List or colour Cells of results

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

Excel 2007

=If(VLOOKUP(B3,$A$2:$A$10,1,FALSE),COUNTIF($A$2:$A$13,B2),"")

The above formula is looking at a figure in a selected cell then looks in
the selected array to match that figure and then count how many occurences if
any.

What I would also like to have is a formula to tell me in what cells the
matches are or highlight the cells of the matches. Is this possible or am I
being overambitious?
 
--
Jamie


Jamie said:
Excel 2007

=If(VLOOKUP(B3,$A$2:$A$10,1,FALSE),COUNTIF($A$2:$A$13,B2),"")

The above formula is looking at a figure in a selected cell then looks in
the selected array to match that figure and then count how many occurences if
any.

What I would also like to have is a formula to tell me in what cells the
matches are or highlight the cells of the matches. Is this possible or am I
being overambitious?
Click to expand...

I have found a previous posting for showing what cells the corresponding
figure is in but would still like to know if i can get the cell that figure
is in to colour fill also.

Jamie
 
Back
Top