• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Provblems creating formula for action follow -up

S

sveinhelge.urdal

Member
I have a table like this:
TitleNext dueForecastReceived from OriginatorSent to CheckerChecker returnReturned to OriginatorWith OriginatorWith CheckerWith UsComments
Test 119.04.202415.04.2024XReceived by us but not expedited
Test 230.01.202423.02.202423.02.202415.03.2024XReply from Checker received but not processed
Test 301.04.202401.04.2024XNot issued by Originator
Test 425.08.202306.04.202408.04.2024XSent to Checker but not returned to us
Test 512.04.202419.01.202426.02.202413.03.202427.03.202429.03.2024XReturned to Originator for update
My goal is to make Excel insert the cross marks as shown in the columns that indicates with whom the action is right now. Columns H, I and J.

Can anyone help?
 

Attachments

  • Example.xlsx
    10.5 KB · Views: 12
Yes ... You did those Yourself.
I try to ask other way...
How did You know to which cell You mark those crossmarks?
As I tried to ask in #3 reply
- did You check Comments and after that You marked those crossmarks?
 
vletm said:
Yes ... You did those Yourself.
I try to ask other way...
How did You know to which cell You mark those crossmarks?
As I tried to ask in #3 reply
- did You check Comments and after that You marked those crossmarks?
Click to expand...
An explanation to wath I am thinking.
Comments
Cross in With Us shall be when it is received from originator but column E,F and G is empty. Or like in the nect row.
Cross in with us if column F is not empty and G is impty.
Cross in with originator if Column D is empty
Crossin with checker if columnd D and E is not empty, but column F is empty
Cross in with originator ifColumn G is not empty
 
Okay ...
You skipped to check and verify based Your #6 writings.
If that is correct then why did You skip to crossmark third With Us?
 
About Your:
My goal is to make Excel insert the cross marks as shown in the columns that indicates with whom the action is right now. Columns H, I and J.
Why do there missing one crossmark?
 
Is this explanation better?
ABCDEFGHIJ
TitleNext dueForecastReceived from OriginatorSent to CheckerChecker returnReturned to OriginatorWith OriginatorWith CheckerWith Us
Test 119.04.202415.04.2024X here if D is not empty and E is empty
Test 230.01.202423.02.202423.02.202415.03.2024X here if F is not empty and G is empty.
Test 301.04.202401.04.2024X her if D is empty
Test 425.08.202306.04.202408.04.2024X her if E is not empty and F is empty
Test 512.04.202419.01.202426.02.202413.03.202427.03.202429.03.2024X her if G is not empty
 
You must log in or register to reply here.
Back
Top