Hi guys!
Cant believe how much help i have recieved on this forum upon starting my Excel Journey. Im learning so much from everyone and i ofthen thought WHY people are willing to help!? I had a reply from someone who has helped me recently explaining that 'We pay it forward...' & that when im in a position to help others thats the return!
This is so true!.. I hope i can repay people with my knowledge someday too.
Here is an overview of what im currently trying to achieve,
I have Cells C10-C19 which contain Names of People.
Directly to the right of these Names in Cells D10-D19 i have the Scores for these Names.
Directly to the right of the Scores in Cells E10-E19 i have Blank Cells where i need the Result of two seperate Formula's (explained below) to Display the Name with a specific score.
Additionally i have a Cell Range A38-A46 that also need to be Checked. If any of these cells contain 'X'... then Display 'X' next to the Name rather than the name itself.
If the Cells Range A38-A46 are blank or contain 'Y' (basically anything other than 'X') then Display the Name next to the Name.
I need your help/advice with the following 2 seperate Formulas;
I have a Cell (N9) which i need to perform the following.
1) IF Cell A35 is '0' AND Cell A36 is '2'
AND
2) IF Cells within range A38-A46 DONT contain 'X'
THEN
3) Display the Name in range C10-C19 which is next to the LOWEST score between (and including) 2.00 - 2.99 from range D10-D19 in the corresponding Cell to the right (range E10-E19)
AND
4) Display 'Y' in the original Cell N9
BUT
5) IF Cell A35 is NOT '0' OR Cell A36 is NOT '2'
OR
6) IF Cells within range A38-A46 DO contain 'X' then display 'X' in the original Cell (N9) only
------------------------------------------------------------------------------------------
The other formula i need is a variation of the 3) rule above;
------------------------------------------------------------------------------------------
I have a Cell (N10) which i need to perform the following.
1) IF Cell A35 is '0' AND Cell A36 is '3'
AND
2) IF Cells within range A38-A46 DONT contain 'X'
THEN
3) Display the Name in range C10-C19 which is next to the HIGHEST score between (and including) 2.10 - 2.50 from range D10-D19 in the corresponding Cell to the right (range E10-E19)
AND
4) Display 'Y' in the original Cell N10
BUT
5) IF Cell A35 is NOT '0' OR Cell A36 is NOT '3'
OR
6) IF Cells within range A38-A46 DO contain 'X' then display 'X' in the original Cell (N9) only
Im so appreciative of the help/advice you guys have given on my Excel journey thus far! I hope to be able to do the same in the future.
I honestly cant thank you enough!
Thanks for reading
Bookmarks