Hi there,
I have this file where I'm working with multiple columns.
Column F is the result column.
I have attached the File.
Thanks in advance.
Hi there,
I have this file where I'm working with multiple columns.
Column F is the result column.
I have attached the File.
Thanks in advance.
Administrative Note:
Is your forum profile showing the version of Excel that you need this to work for?
Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.
The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.
Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
What is the logic?
Logic is:
If A2=A3, and B2 is between 1-4, again, B2 is between 5-9, C2=C3, than result in F2 = 1, and F3=0
Not sure if this is what you want. It's mostly correct with the odd anomaly
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I have no idea what that means.Logic is:
If A2=A3, and B2 is between 1-4, again, B2 is between 5-9, C2=C3, than result in F2 = 1, and F3=0
Sorry, If C2 and A2 is equal to C3 and A3, B2<=4, B2>=5, result should be 1 or else zero.
I don't understand1, 2, 3, 4 <= 4. 5, 6, 7, 8, 9, >= 5. Hence, 1, 2, 3, 4, 5, 6, 7, 8, 9B2<=4, B2>=5
This doesn't give you what you want but it demonstrates a possible approach:
Formula:Please Login or Register to view this content.
Hey boss,
Hope now i can make sense
If A2=A3, C2=C3, where B2 <=4, (Answer 1 or else zero )
Again, this doesn't give your expected results, but it is what you have described:
Formula:Please Login or Register to view this content.
Same outcome, different way:
Formula:Please Login or Register to view this content.
Please see updated File in excel attached to represent the data.
Column D is the result column.
If A2=A3, C2=C3, where B2 <=4, (Answer 1 or else zero )
Nope. I've tried this all different ways. Your expected results are not viable.
See the updated workbook. Compare the values in column A. They cannot produce your expected results.
Thanks a lot boss, appreciate your work and time spent on this.
You're welcome. Thanks for the rep.
Good luck working it out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks