Hi guys!
After the EXCELLENT more than helpfull response to my last post im asking to pick your brains again!
You guys are WAY more advanced than me... but with your help im getting there and appreciate it greatly!
So heres what im trying to achieve...
I have Cells D10 - D19 which return a number to 3 decimal places eg, 1.56, 2.15, 25.2 etc To the left of these cells is the name of people (C10 - C19) each corresponding to the number directly to its right. Eg,
C10 = Andrew Wood D10 = 1.56
C11 = Mark Williams D11 = 1.84
C12 = ...... D12 = ....
all the way down to C19 & D19.
Im tryin to get a Cell to look at all the numbers in the range (D10-D19) and do the following.
1) If TWO or more numbers (D10-D19) are EXACTLY the same between 1.00-3.00 then Display 'X' if not Display 'Y'
OR
2) If THREE or more numbers (D10-D19) are between (and including) 1.00-1.99 (basically in the 1's) AND Three or more numbers (D10-D19) are between (and including) 2.00-2.99 (basicall in the 2's) then Display 'X' if not Display 'Y'
OR
3) If THREE or more numbers (D10-D19) are between (and including) 1.00-1.99 (basically in the 1's) AND Three or more numbers (D10-D19) are between (and including) 3.00-3.99 (basicall in the 3's) then Display 'X' if not Display 'Y'
OR
4) If THREE or more numbers (D10-D19) are between (and including) 2.00-2.99 (basically in the 2's) AND Three or more numbers (D10-D19) are between (and including) 3.00-3.99 (basicall in the 3's) then Display 'X' if not Display 'Y'
Does the above make sense? Have i explianed this well enough!?
I really appreicate you guys helping me out with me starting with Excel and ive already learned SO MUCH! I cant help feeling that for some of you this is EASY! While im still getting my head round everything im trying to achieve.
Thanks alot for taking the time if you decide to reply! Any help appreciated!
Andy
Bookmarks