Sep 18 2020 12:16 AM
Hi All,
I am working on a spreadsheet which contains monitoring of a few events. One of these events is "Stale market price date check". This are all in column AE of "exception data input" tab of the attached.
As the spreadsheet contains many funds, I am hoping to find the stale priced assets for each fund when selected. I wish to show in columns T & U of the "summary" tab, the assets which match this exception for the fund. I am hoping to use macro or similar to find a way to find the assets in AE of "exception data input" that match the fund in cell E4 of the summary tab. Then sort by the most common or number of times this has occurred.
Can someone please help me find a way to address this issue.
Many thanks,
Sep 18 2020 12:29 PM
Your sheet is convoluted enough (not that mine aren't) for someone outside of your field, outside of your specialty, to find navigating difficult. So I'm going to point you in a direction that seems to me might well work. If you wish more help, I suggest you give an example not just of the high-level concept, but of an actual instance or two:
As it is, you're kind of expecting us to be mind-readers as well as Excel geeks.
All that said, as it does look as if you're comfortable with Excel in the main, I'd suggest that some of the newest functions, available only in the newest version of Excel, might work. FILTER in particular, will take multiple criteria, which you have, and apply them to a database, such as you have, and return the results that meet the criteria. Those results can be summed, sorted, listed......
Here's a YouTube video that serves as an excellent introduction to that function and some associated ones. https://www.youtube.com/watch?v=9I9DtFOVPIg