Hi excel experts
the data in column a in groups between STRAT and END
How can I extract the data from these groups "FN" & "LATESTDATE" & "TEL" in columns G to I?
Hi excel experts
the data in column a in groups between STRAT and END
How can I extract the data from these groups "FN" & "LATESTDATE" & "TEL" in columns G to I?
Hello,
Here's a suggestion :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
thank you very much
If you copied cells from A10 to A18 and paste them into A28 and tried the code you will find the last one with wrong data
and as for the yellow group I need to extract the other information even if the information is not full so in this case the LATESTDATE and TEL should extracted
I prefer to depend on START & END
bump bump can you help please?
bump bump
can you help please?
Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
From the forum rules (link in the main menu above):
- If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Pl see attached file and code for macro.
I am not able to post code alone.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
thanks a lot for help me
I tested the file but I got only one result for the first group
upload the sample file.
Here's the final example
Try
Please Login or Register to view this content.
Amzing jindon. Works like charming
thank you very much
How can instead of 'No Name' I got the part '=D9=88=D8=AD=D9=8A=D8=AF=20=D8=B9=D8=AA=D8=A7=D8=A8=D9=8A' ?
Because you didn't explain the logic clearly, I wrote the code based on your data and the results in you attached workbook.
Still a guess and if this is not how you wanted, you need to show us the data and the result that you want.
Try change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
In the results of your code, in G4 I got 'No Name' and that result should be '=D9=88=D8=AD=D9=8A=D8=AF=20=D8=B9=D8=AA=D8=A7=D8=A8=D9=8A' instead of that text 'No Name'
that's the only change I need
try
Please Login or Register to view this content.
thank you very much. you helped me a lot. you are so great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks