• 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.

Extract column name with comparison

What's the issue? Why should I have to open your file to find out? Explain what you are wanting help with in your post. Why have you posted a poll???
 
Dear AliGW, Issue I have submitted in file attached . I have explained in attached file and about Poll I do not what is this this come auto when I submitted a question. So please.
 
Suresh Badhani
Can You verify Your given 'results' to row 14?
I added TRUE/FALSE values to rows 16&17 ... and I could figure Your results!

POLL
... while You did Your issue here
... did You read and clicked only needed/wanted options?
 

Attachments

  • File temp.xlsx
    59.9 KB · Views: 5
I removed unwanted fields and update remark of issues . As per your true false no solution find . Plz see file . Thanking you
 

Attachments

  • File temp (2).xlsx
    19.4 KB · Views: 3
Suresh Badhani
One sample ...
How You would solve those if all or same same value?
then Your 'rules' won't work ... or how?
 

Attachments

  • File temp (2).xlsx
    57.1 KB · Views: 2
or................

In C14, copied across to I14

=INDEX({"N3 < N1 & N2";"N3 < N1";"N3 < N2";"OK"},BIN2DEC(0+(C6>C4)&0+(C6>C5))+1)

Regards
Bosco
 

Attachments

  • Comparsion.xlsx
    13.3 KB · Views: 5
Back
Top