Hi
Im very beginner with excel. I got a task with need help. I read forums now several days but I cannt got any solution yet. Try Vlookup index match formulas but always run into walls.
I need result for the B column. I already fill the B how it have to be look like and write the criteria into the excel.
Thanks in advance If any help I can get.
Stopo
Last edited by Pepe Le Mokko; 01-16-2020 at 03:36 AM. Reason: Removed superfluous title part
I think the conditions is wrong. For 3rd line. C <= D in that row where is last X is 2nd row and in the 3rd row "ABC 123" value is 2nd again.
Maybe I wasnt clear and exact enough sorry. 3th "ABC 123" is Y in the B column because C3<=D2 / where last X / is.
This proposal requires that the data be shifted down one row. Once that is done the following formula replicates the original values with one exception (row 9):Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
HiOriginally Posted by JeteMc
This proposal requires that the data be shifted down one row. Once that is done the following formula replicates the original values with one exception (row 9):Formula:Please Login or Register to view this content.
Let us know if you have any questions.
THX working perfectly!
Stopo
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
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.
You're Welcome and thank you for the feedback. Please take a moment to do as AliGW requests and mark the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks