Forum

Hi Jim, I've added a PQ solution to your file. See attached. Riny

I guess you could do this is in PQ by grouping, merging and subtracting.

Perhaps the attached file does what you ask for. It contains a table (the green one) created with Power Query, based on the data in columns A:O.

Assuming that you are trying this on Excel365, I believe you need to create separate areas that contain the pairs of data validation lists, as demonst...

Hi Leroy, Perhaps I'm just slow today but I still don't get it. You mention that you want "a nested table with a conditional column for Levy $". Is...

Hi Tom, Power Pivot can do this. Demonstrated it in your file which I re-attached below. Riny

I understand the question regarding 2(a), but how is Excel supposed to know who is admin, a lecturer or a student? You need to have that information l...

Great! Glad you worked out a solution.

Hi Leroy, I took a look at the pbix file but found it difficult to figure out what you are trying to achieve. Decided to copy the data and queries ...

Perhaps the attached file contains the PQ solution you need. Otherwise I may have misunderstood.

Thanks for the file. I'm not convinced that VBA is the correct tool. It seems to be ideal for Power Query. Are you familiar with that? Looking at t...

Hi Martyn, Can you please attach a file, rather than a picture via Dropbox? You can group by ID and add a custom column keeping the first 12 row...

It would be helpful if you could attach a file so that we can see what you are talking about. If you did try, perhaps you forgot to press "Start uploa...

Hi, Could you attach a workbook containing what you have and what end result is needed. It's difficult to visualize what you are trying to achieve ...

Glad it worked!