S Suresh Badhani Member Oct 20, 2018 #1 Please help to resolve the issue. Attachments File temp.xlsx File temp.xlsx 20.3 KB · Views: 8
AliGW Well-Known Member Oct 20, 2018 #2 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???
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???
S Suresh Badhani Member Oct 20, 2018 #3 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.
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.
V vletm Excel Ninja Oct 20, 2018 #4 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 File temp.xlsx 59.9 KB · Views: 5
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?
S Suresh Badhani Member Oct 22, 2018 #6 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 File temp (2).xlsx 19.4 KB · Views: 3
I removed unwanted fields and update remark of issues . As per your true false no solution find . Plz see file . Thanking you
V vletm Excel Ninja Oct 22, 2018 #7 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 File temp (2).xlsx 57.1 KB · Views: 2
Suresh Badhani One sample ... How You would solve those if all or same same value? then Your 'rules' won't work ... or how?
B bosco_yip Excel Ninja Oct 22, 2018 #8 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 Comparsion.xlsx 13.3 KB · Views: 5
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
S Suresh Badhani Member Oct 23, 2018 #9 Dear Bosco, Great effort and job done . Thank s for your effort . Hats of you. Regard's Suresh Badhani
Dear Bosco, Great effort and job done . Thank s for your effort . Hats of you. Regard's Suresh Badhani