View Single Post
 
Old 10-07-2021, 02:30 AM
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 528
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

It looks like I've misunderstood completely the requirement.
To help me better understand, I'd like you to explain to me how you arrived at the result in just one cell. Please refer to the file I attached in my last message so we're both talking about the same cells.
I'm interested in how you arrive at the R in cell AB17, which is for row 17 and January 2022.
You say R means there are 3 or more negative values.
I'd like you to tell me:
1. Which 3 or more cells contain the negative values to get that R result in just that one cell AB17
2. Which cells should just that cell AB17 examine to see if they are negative or not.


If you want to do the same with a few other result cells to make thing clearer, that's fine. Cell AD5 would be a good one.

Last edited by p45cal; 10-07-2021 at 06:13 AM.
Reply With Quote