Log In
Register
Home
September 14, 2020
Offline
Hi,
All members,
I have a problem. I attach the file kindly Resolve the problem.
Thanks,
Reehan
July 16, 2010
Offline
Hi Reehan,
Please also explain the problem in the thread so that others know what the problem is before downloading the file and the question and solution are searchable for others to find and seek help from.
Also, it's not clear in your file what you want, sorry. Even with the data and required your comments are confusing because you say 'without using any words like, sale or cash, yet your required example contains those exact words. Please clarify.
Mynda
September 14, 2020
Offline
Hi,
I have an Excel sheet that has 2 Sections, names: Data Section & Example Section.
The example section is only for understanding, what I want.
I want lower cell Value to the back of the upper cell by using Formula.
Example:
These are three values in Column "C".
Zafer
Cash
Sale
and Lower Value is "Sale". I want Sale in the Back of Cash Column "B"
I attach the file, kindly also check it as an example.
Thanks,
Reehan
July 16, 2010
Offline
You can't really do this with a formula as there's no consistent pattern, but you can use Power Query, see example file attached.
Note: can you please take care not to re-attach your file each time you edit your question. You've uploaded 7 extra files!
Thanks,
Mynda
1 Guest(s)
