How to trim multi-stock data by matching dates
Hello everyone,
Please - does anyone know how I can only keep stockdata that has the same date?
Here is an example of what I mean:
Excel_sorting_problem.png
I only want to keep the dates and the corresponding stock movements that are comparible (i.e. don't have missing data).
Thank you,
Best regards,
Last edited by HappyExcelLife; 02-16-2023 at 06:38 AM.
Assuming your real data is as represented by the picture, maybe with a macro like this?
Please Login or Register to view this content.
Last edited by Croweater; 02-14-2023 at 09:50 PM.
Thank you for this - however the number of stocks is dynamic so I would probably have to throw in a loop function like "do until" or "do while" but is there no way to do this within excel itself, besides using Macros? Just curiosity, it's okay if it is the only way.
Try this,
H2
=CHOOSECOLS(FILTER(A2:F100,(A2:A100<>"")*(B2:B100<>"")*(C2:C100<>"")*(D2:D100<>"")*(E2:E100<>"")*(F2:F100<>""),""),{1,2,4,6})
Thank you so much! This is just what I needed ^_^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks