Google Docs - Picking out the highest value cell

Google Docs - Picking out the highest value cell - Printable Version

+- Discovery Gaming Community (https://discoverygc.com/forums)
+-- Forum: Welcome (https://discoverygc.com/forums/forumdisplay.php?fid=399)
+--- Forum: Help & Support (https://discoverygc.com/forums/forumdisplay.php?fid=26)
+--- Thread: Google Docs - Picking out the highest value cell (/showthread.php?tid=127837)

Google Docs - Picking out the highest value cell - Connor - 03-29-2015

So I'm having a slight problem finding a way of highlighting the highest value on a document that is always changing. Does anyone know how to select a group of cells and force all of the highest values in those cells to light up as a colour via conditional formating?

RE: Google Docs - Picking out the highest value cell - SnakThree - 03-29-2015

(03-29-2015, 05:17 PM)Snoopy Wrote: So I'm having a slight problem finding a way of highlighting the highest value on a document that is always changing. Does anyone know how to select a group of cells and force all of the highest values in those cells to light up as a colour via conditional formating?

Not sure about highlighting it, but you can make new cell with =MAX(range)

RE: Google Docs - Picking out the highest value cell - Connor - 03-29-2015

I think I've nailed it now with your help, @Snak3. I did your =MAX() and then entered a =VLOOKUP() and it seems to have worked so far! Cheers for the help.

Edit: What I've done hasn't worked... QQ

Edit2: This is what I have so far

[Image: Ibb4jts.png]

The problem is that It works for this because the Vlookup is searching for the 3rd row, but when the votes go to, lets say 4, it picks out the 4th name and places is where the highest vote is.

IE:

Names .................Votes

a..............................1
b..............................2
c..............................3
d.............................. 0
e ..............................1
f ..............................0
g ..............................0
h .............................. 1

Highest vote: C

Names .................Votes

a..............................4
b..............................2
c..............................3
d.............................. 0
e ..............................1
f ..............................0
g ..............................0
h ..............................

Highest vote: D

Because the highest value is 4 (A) so the VLOOKUP looks for row 4 and takes the letter D as the highest value where it should be picking out A because it has the highest amount of votes.

I hope that isn't too confusing.

RE: Google Docs - Picking out the highest value cell - Connor - 03-30-2015

Got it working by replacing the numbers on the left with the =COUNTIF() formulas used under the vote count and by keeping the =MAX()

[Image: vHVr0hO.png]